DataMapper ORM v1.8.2

[eluser]WanWizard[/eluser]
This works, but fires an awful lot of queries.

If you need related information and you need to loop over a resultset, it's usually best to add the required fields to the query using include_related().

Also note that Datamapper does not support threeway relations. Functionally it works fine, as you have noticed, but the relational logic can not deal with it.

Which means that if you delete a parent record, Datamapper will delete the relationship record that links the parent to the other tables. Regardless of the fact that the other two tables still need that record to define the relationship between them.

You have to be aware of this fact.

If you want to do this the safe way, include the relationship table as a normal table. Make a model for it, and define the relationship between the three models and the relationship model as one-to-many.