Datamapper ORM Multi-tabel Relationship Halp!

[eluser]WanWizard[/eluser]
Sorry about the typo.

No, Purchases -> has_one -> Options. Not has_many, you're using an in-table FK, so one purchase record can only point to one option record.

If you want to know all options for the purchase of a specific template, use

Code:

$user = new User(1);
$template = new Template(16);

// get the details of the purchase of template 16 by user 1
$purchase = new Purchase();
$purchase->where_related($user)->where_related($template)->option->get();