Re: [Phpgroupware-developers] Schema Availability to Apps

[Michael Dean]

Actually, I plan on bringing DCL's db_core to phpGW in the future.  It
abstracts the server-specific database layers.  It supports constructing
select, insert, update, and delete statements.

Combining db_core with LoadSchema would make writing classes very
trivial, and still allow room for overriding methods when the need
arises.

On Wed, 2003-05-21 at 01:34, Ralf Becker wrote:
> I use something similar in some of my apps:
> 
> It's an (abstract) base-class for an so-layer. It includes the schema 
> and works on that information. It has functions for reading, writeting 
> or searching in the table and two function to convert the 
> db-representation of the data-object in the internal one and back (with 
> can be extended / overwritten in the extending class).
> 
> If you want to check it out: etemplate/inc/so_sql.inc.php
> 
> Examples how to use the class are in the etemplte tutorial and each 
> function has ein extensive include-doc.
> 
> Ralf
> 
> PS It does not deal with MSSQL or Sybase (missing) datetime types at the 
> moment, but its easy to add, as the class is aware of the type of each 
> colum and abstracts the sql to access the table (you dont need to write 
> sql direct).