DMZ 1.7.1 (DataMapper OverZealous Edition)

[eluser]OverZealous[/eluser]
[quote author="foonk" date="1269037776"]
I just started using this library and I really like it. I've tried doctrine and ignited record and dmz seems to be exactly what i'm looking for. So far it's been the easiest to use and fastest ORM. Thanks for writing this code.
[/quote]
You are welcome! I appreciate the support.

I am running into a problem with advanced relationships.

Your code looks correct from here. :-S

One thing is to make sure that the $owner object has been loaded correctly! It's an easy mistake to make.

Also, is it possible you have the $has_one relationship defined both as an in-table foreign key AND on your join table? You only need one.

Code:

TABLE events
id ... owner_id // only one of these should exist

TABLE events_users
id ... owner_id // only one of these should exist

If not that, then, one thing you can try is removing owner_id and ownedevent_id from the events_users table, and adding owner_id to the events table.

While it should work just fine storing the owner relationship on your events_users table, you will also see a significant performance gain by using an ITFK, especially with DMZ 1.7, as it optimizes queries to take advantage of them.


Don't forget to go through the steps listed in the troubleshooting guide, especially the part about checking your queries.