forked from alanszlosek/dbFacile
/
FUTURE.txt
26 lines (20 loc) · 977 Bytes
/
FUTURE.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
dbFacile - The easily used PHP Database Abstraction Class
Copyright (C) 2007-2008 Alan Szlosek
----
FUTURE ITEMS AND IDEAS
- important (got a comment about this): quote all table and field references in single-quotes or backticks, whichever is appropriate for connected DB
- fix the workaround for when you don't want fields escaped or quoted (insert/update)
- table prefix to prepend to all tables (except for hand-typed queries)? might be too much work
- getTables()
- error out if don't have dbHandle
- check for valid tables passed to insert(), update(), delete()
- return generated primary key on insert for mssql
- possibly use information_schema
- use scope_identity() ... needs testing
- http://msdn2.microsoft.com/en-us/library/ms190315.aspx
- fetchRow to use limit for some DBs?
- PDO for sqlite3
- mssql table info
http://msdn2.microsoft.com/en-us/library/ms187752.aspx
BAD IDEAS
- fetchColumn implodes all columns in query and then appends to value array