Posted by Dikkie Dik on 10/15/05 01:34

Nikolas Hagelstein wrote:
>>>As for database layers, I am writing my own as well. Started out as
>>>individual classes, it is maturing to something that combines some nice
>>>performance enhancements and data checking on the real database part and
>>>some common inherited functionality on the lazy tablewrappers part.
>>>I am building mostly multi-language sites now, and I have some standard
>>>controls that work with my "feeding" of the language-dependent strings.
>
> sounds interessting could you provide a more deeper view to it?
> bye,
> NIKOLAS
>
Most tables are represented by a lazy collection class. My "latest
trick" is to equip the collections with a ScheduleForLoad method. This
is used for objects I want to retrieve, but not right away. Whenever a
database action is necessary, the already scheduled objects are loaded
as well with a single SQL command. This is usually a HANDLER statement.
The table wrappers started out as single classes, but I am refactoring
them now to have a common superclass with abstract methods for object
creation. Yes, I'm using PHP5.
The table wrappers are held together by a backend object, that acts as
the root of the data layer. The backend object knows all table wrappers.
When I am finished generating a page, I only have to call the Dispose
method of the backend, as it propagates it throughout the whole backend
structure.
The frontend structure (the user interface) consists still of loose
classes and a controls collection, but it will be structure in the same
manner: a frontend object will hold the controls collection and can
generate new controls.
I am currenty dividing the controls in standard HTML controls and
"phrase-aware" controls that often extend from the HTML controls.
The multilanguage strings are "phrases": a sort of thoughts that are not
yet expressed in a language. They are in a table with only an ID field.
There is also a languages table, and a translations table with a
translation for each phrase and language.

Best regards

[Back to original message]