DMZ 1.7.1 (DataMapper OverZealous Edition)

[eluser]OverZealous[/eluser]
@someoneinomaha

Personally, I would use join_fields as you originally intended. This ensures that if you delete all photos, you also delete the primary. The section on join_fields in the manual covers the three basic methods that work with them.

If you want to have multiple relationships instead, then I would do it like this:

Code:

class Classified {
    $has_many => array('photo');
    $has_one => array('mainphoto' => array('class' => 'photo', 'other_field' => 'classified_main');
}

class Photo {
    $has_many => array(
        'classified',
        'classified_main' => array('class' => 'photo', 'other_field' => 'mainphoto')
    );
}

// Table classifieds_photos
id
classified_id
photo_id
classified_main_id
mainphoto_id

Then you have to save the main photo in two ways:

Code:

$classified = new Classified();
// TODO: set fields, save photos, etc.
$relations = array(
    'photo' => array($photo1, $photo2, $photo3),
    'mainphoto' => array($photo1)
);
$classified->save($relations);

Also, if you delete the mainphoto, it has to be deleted twice:

Code:

$classified->delete_mainphoto($photo1);
$classified->delete($photo1);

Some of these problems are alleviated with using the join field. The JF has it's own minor problems, as well.