Datamapper ORM Multi-tabel Relationship Halp!

[eluser]WanWizard[/eluser]
Datamapper doesn't support multi-relationship joins.

Datamappers expects the combination of the two foreign keys in a relationship table to be unique. If not, you'll get duplicate results when you query that relation.

I suggest you create this table as a separate table like in your example (lets call it purchases). Give it has_one's to user, template and option (and these three a has_many to this table), and use the value a normal data column.

So

User -> has many -> Purchases
Templates -> has many -> Purchases
Options -> has many -> Purchases
Purchases -> has one -> User
Purchases -> has one -> Template
Purchases -> has one -> User

You shouldn't have any problem with the desired usage:

Code:

$user = new User(1);

// get all this user's purchases
$user->purchase->get();

// get info about a specific purchase
$user->purchase->where('template_id', 16)->get();

// get all users that bought an option
$purchase = new Purchase();
$purchase->include_related('user')->where('option_id', 66)->get();