Bug #163 Details
Database: Restore full database abstraction
| Status | Testing (ass. to yves) | Priority | Medium |
| Author | yves | Date | 01 Aug 2004 00:44 |
Restore full database abstraction so that other DBMS can be supported, too
Find all database queries and extend the database class by necessary methods like JOINs of all kinds
No IDatabase::Exec() call should be left outside database.lib.php
All WHEREs may use backtick-quoting of column names, i.e. in WHERE clauses. MySQL is fine with this, but MS-SQL probably speaks differently.
see ADOdb: http://adodb.sourceforge.net/
http://sqlrelay.sourceforge.net/
PEAR DB
/*PHP Data Objects (PDO): http://www.php.net/manual/en/ref.pdo.php (still experimental, PHP 5.1)*/
remaining IDatabase.Exec() calls are:
--- Update installation documentation when this bug changes! ---
Find all database queries and extend the database class by necessary methods like JOINs of all kinds
No IDatabase::Exec() call should be left outside database.lib.php
All WHEREs may use backtick-quoting of column names, i.e. in WHERE clauses. MySQL is fine with this, but MS-SQL probably speaks differently.
see ADOdb: http://adodb.sourceforge.net/
http://sqlrelay.sourceforge.net/
PEAR DB
/*PHP Data Objects (PDO): http://www.php.net/manual/en/ref.pdo.php (still experimental, PHP 5.1)*/
remaining IDatabase.Exec() calls are:
dumpdb.inc (various MySQL-specific calls)
thread.inc (insert into select)
--- Update installation documentation when this bug changes! ---
| Keywords | |||
| Reported version | 1.5 | Due version | 1.6 |
| Progress | 95 % | Estimated cost | Average work |
Changes history:
| Date | User | Action |
| 01 Aug 2004 00:44 | yves | Opened task |
| 06 Aug 2004 08:23 | yves | Changed status (New → Acknowledged) |
| Changed description | ||
| 07 Aug 2004 21:06 | yves | Changed reported version ( → 1.5) |
| Changed due version ( → 1.6) | ||
| 10 Aug 2004 20:07 | yves | Changed description |
| 22 Oct 2004 00:04 | yves | Changed due version (1.6 → 1.8) |
| 09 Jan 2005 16:47 | yves | Changed description |
| 10 Jan 2005 17:07 | yves | Changed description |
| 30 Jan 2005 00:39 | yves | Changed description |
| 17 Apr 2005 21:39 | yves | Changed status (Acknowledged → Assigned) |
| Changed percent complete (0 % → 50 %) | ||
| Changed due version (1.8 → 1.5.4) | ||
| Changed assigned user ( → yves) | ||
| 20 Apr 2005 13:22 | yves | Changed status (Assigned → Testing) |
| Changed description | ||
| Changed percent complete (50 % → 95 %) | ||
| Changed estimated cost (Unknown → Average work) | ||
| 08 Sep 2005 18:16 | yves | Changed description |
| 09 Sep 2005 15:47 | yves | Changed description |
| 03 Nov 2005 20:18 | yves | Changed description |
