Related models are not being removed (relations many to many)

Question

Related models are not being removed (relations many to many)

stas29a Nov '14

Created Nov '14	Last Reply Nov '14	Replies 1	Views 509	Votes 0

stas29a 550

Nov '14

Hi. I have model with relations many to many and I can't delete releted models. Here is code:

class GroupImages extends Model { public $id;

public function initialize()
{          
    $this->setSource('group_images');
    $this->hasManyToMany('id', 'ImagesOfGroup', 'group_image_id', 'image_id', 'Images', 'id', ['alias' => 'ImagesOfGroup']);        
}

public function setImages($arImages = [])
{
    $this->ImagesOfGroup->delete();
}

}

class ImagesOfGroup extends Model { public $image_id; public $group_image_id;

public function initialize()
{
    $this->setSource('images_of_group');
    $this->belongsTo('image_id', 'Images', 'id');
    $this->belongsTo('group_image_id', 'GroupImages', 'id');
}

}

I'm trying this $this->ImagesOfGroup->delete() but it is not working. Method delete returns true but when looking through logs there is no sql for delete records.

Dmitriy Zhavoronkov · Answer 1 · 2014-11-12T03:18:07-07:00

I think you should traversing a resultset with a foreach to delete each row, because your ImagesOfGroup contains many records but not the single one.

public function setImages($arImages = [])
{
    foreach($this->ImagesOfGroup as $row)
    {
        $row->delete();
    }
}

stas29a · Answer 2 · 2014-11-12T04:59:33-07:00

Thank you for your answer! It is not working too :( I don't understand why your code and my example working with other relations and is not working with many to many.