[Deprecated] DMZ 1.5.3 (DataMapper OverZealous Edition)

[eluser]OverZealous[/eluser]
@warrennz
It looks like they are all $has_one relationships, correct?

If this is the case, then you don't need a separate table at all. Add these columns to the accounts table:

Code:

* creator_id
* installer_id
* canceler_id
* owner_id

Then, set up your models like this:

Code:

class Account extends DataMapper {
    $has_one = array(
        'creator' => array('class' => 'user', 'other_field' => 'createdaccount'),
        'installer' => array('class' => 'user', 'other_field' => 'installedaccount'),
        'canceler' => array('class' => 'user', 'other_field' => 'canceledaccount'),
        'owner' => array('class' => 'user', 'other_field' => 'ownedaccount')
    );
}

class User extends DataMapper {
    $has_many = array(
        'createdaccount' => array('class' => 'account', 'other_field' => 'creator'),
        'installedaccount' => array('class' => 'account', 'other_field' => 'installer'),
        'canceledaccount' => array('class' => 'account', 'other_field' => 'canceler'),
        'ownedaccount' => array('class' => 'account', 'other_field' => 'owner')
    );
}

Notice how each reference is mirrored, so that other_field becomes the relationship key on the opposite object.

Alternatively, you can make any one of those (say, owner) a standard relationship. Ex: change the column from owner_id to user_id, and replace the whole owner with just user and ownedaccount with just account.

Finally, if you want to continue to use a dedicated join table, or these are not $has_one relationships, you need to set up a single accounts_users table with these columns (or you can mix-and-match):

Code:

* id
* owner_id
* ownedaccount_id
* creator_id
* createdaccount_id
* etc.

All columns are integers and must allow NULLs.

In other words, DMZ will always look for the same join table when relating two different objects, but use the column names generated from the related_field name.

Accessing those relationships are like normal, e.g. $account->canceler->get().