In 1.0 I've overloaded the _fetch method to join tables to create an ORM-like app. I only really need this in one place so I don't wan't to change my app to Doctrine.

What I have is in theory simpe:

Customer database - contains customer id
-- Company database - contains company specific data
-- Person database - contains person specific data

Since the customer id is the same this seems like a good way of doing it. All I do is a join() where the company or person data are stored in a different var which is then also searched when the __get, save etc methods are called. Worked nicely until the _fetch got fundamentally changed...

I've looked at different ORM proposals but all efforts seem to have died off...

Pleaze share with me your dirty hack on how to solve this until the devs come up with an orm.

Thanks!

Ok, I've put together the attached class, not as quick as I hoped but pretty dirty. Got a little bigger than the max allowed txt...

This is my novice aproach to an ORM - Object-Relational mapping database object. Please give hints on howto make the class safer for future changes. Any hints are appreciated.

So far u can only have inheriting tables but it seems to work nicely. See the .3 version.

Attached Files

OrmTable_v0.3.zip (6.0 KB, 21 views)

Here is a tutorial/write up I did on a very simple ORM I wrote for 1.5

Zend_Db_Table with Normalized Tables Joshteam’s Weblog