MyOM - object to mysql database mapper classes

The idea of the tool comes from j2ee jpa api, but there are no facilities to manage object relations. You could just store slq queries in xml files under some name, execute this queries and produce php class instances instead of recordsets. You could use JOIN query like every other query.

Example: Let suppose that you have some join query and you would like to load its result in some class instances. You must create a php class with fields coresponding to the query resultset fields names.

select f1, f2, f3 …. from table1, table 2 where …

class MyExample { f1; f2; f3;

}

Store your query in MyExample.xml and give it some name. Register MyExample.xml in maps.xml. By using the entity manager you could execute the query and it will produce an arry of MyExample instances. So the you could execute whatever sql query you want. The good things : 1. the code is better structured, more object oriented 2. database access is under some level of isolation so you could migrate to other database by writting new entity manager and modify some slq but not the business logic of all the application

ahhh i know J2EE , this sounds like Hibernate… I’ll purchase it as soon as possible