[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Phpgroupware-developers] Schema Availability to Apps
From: |
Michael Dean |
Subject: |
Re: [Phpgroupware-developers] Schema Availability to Apps |
Date: |
21 May 2003 08:43:02 -0500 |
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).