Bug #163 Details

Database: Restore full database abstraction

StatusTesting (ass. to yves)PriorityMedium
AuthoryvesDate01 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:
dumpdb.inc (various MySQL-specific calls)
thread.inc (insert into select)

--- Update installation documentation when this bug changes! ---
Keywords
Reported version1.5Due version1.6
Progress
  95 %
Estimated costAverage work
Changes history:
DateUserAction
01 Aug 2004 00:44yvesOpened task
06 Aug 2004 08:23yvesChanged status (New → Acknowledged)
  Changed description
07 Aug 2004 21:06yvesChanged reported version ( → 1.5)
  Changed due version ( → 1.6)
10 Aug 2004 20:07yvesChanged description
22 Oct 2004 00:04yvesChanged due version (1.6 → 1.8)
09 Jan 2005 16:47yvesChanged description
10 Jan 2005 17:07yvesChanged description
30 Jan 2005 00:39yvesChanged description
17 Apr 2005 21:39yvesChanged status (Acknowledged → Assigned)
  Changed percent complete (0 % → 50 %)
  Changed due version (1.8 → 1.5.4)
  Changed assigned user ( → yves)
20 Apr 2005 13:22yvesChanged status (Assigned → Testing)
  Changed description
  Changed percent complete (50 % → 95 %)
  Changed estimated cost (Unknown → Average work)
08 Sep 2005 18:16yvesChanged description
09 Sep 2005 15:47yvesChanged description
03 Nov 2005 20:18yvesChanged description
© 2003–2017 by Yves Goergen web1@unclassified.de
Content last updated on 2005-11-03 20:18
dotforward webhosting Get Firefox XHTML 1.1 CSS