Re: DAO/VO Pattern Help

Hello, on 07/13/2005 01:28 PM Jed R. Brubaker said the following:

As I am trying to take my PHP code in a more enterprise direction with strict model/logic/view layers, I have been working with DAOs and the matching VOs. So I am running into a problem that I could really use some direction on: DAO/VO works great with single tables, but I tend to make my database work for its existance, and joins ar eeverywhere. What I don't understand is how to approach DAO/VO when table joins are involved. Can anyone think of some good resources?

You may want to take a look at Metastorage. It is a mature Object-Relational mapping (ORM) code generation tool. It lets you design the classes of your application persistent objects using a simple XML format that defines the class variables, relationships, validation rules and define the types of functions that you want to manipulate the objects. Then it generates the ORM classes, classes to install or update your database schema, so you do not have to hand code SQL. It also supports an Object Query Language (OQL) that lets you define search expressions that are converted into efficient SQL to let your search and retrieve persistent objects that satisfy a given condition, all without writing a single line of SQL. Here you may find more about it: http://www.meta-language.net/metastorage.html Screenshots of the Web interface: http://www.meta-language.net/screenshots.html A tutorial: http://www.meta-language.net/metastorage-tutorial.html -- Regards, Manuel Lemos PHP Classes - Free ready to use OOP components written in PHP http://www.phpclasses.org/ PHP Reviews - Reviews of PHP books and other products http://www.phpclasses.org/reviews/ Metastorage - Data object relational mapping layer generator http://www.meta-language.net/metastorage.html