DMZ 1.7.1 (DataMapper OverZealous Edition)

[eluser]Unknown[/eluser]
Hi all.
Firstly, thanks for your Lib, this is a very good job .

I'm looking for setting avanced relationships between more than 2 tables, but don't find a way to manage this natively with DMZ.

Consider this example.
4 tables: products / colors / sizes / types

1 product has one colors/sizes/types.

1 color has many sizes/types/products

1 size has many colors/types/products

1 type has many colors/sizes/products

In real life, there is more tables following theses relations.

Setting up relations with tables couples will be a pain, so the solution can be to create 1 global relations table like this:

table relations:

Code:

-id (auto-increment)
-product_id
-size_id
-type_id
-color_id

But i'm not sure how to configure (if it's possible) DataMapper Models, even with advanced relationship, where the table "relations" can handle more than 2 relationships.

Of course, i can manage this manually with AR and joins, but i really like the way to instantiate and manage objects.

Ideas are welcome, thanks.