How to delete Relationships between models Many To Many

Question

How to delete Relationships between models Many To Many

moledet Sep '16

Created Sep '16	Last Reply May '17	Replies 2	Views 1003	Votes 1

moledet 17.5k

Sep '16

I was created model as manyToMany like this

<?php
 $this->hasManyToMany('id',
              'Vokuro\Models\BannerSitePlace',
              'banner_id',
              'site_place_id',
              'Vokuro\Models\SitePlace',
              'id',
              array('alias' => 'places')
          );

On update entity after

<?php
  $banner->places = $places;
  $banner->save();// or ->update

The old relationships not deleted. If i try delete before save all data like

<?php
 foreach($banner->places as $place){
    $place->delete();
  }

Phalcon tried to delete "place" that related also to an anather model instead of to delete relationship. How delete only relationships?

1

Wojciech Ślawski
145.0k

Accepted
answer

edited Sep '16
Sep '16

$placesIds = [1, 2, 3, 4];
$bannerPlaces = BannerSitePlace::find([
    'conditions' => 'banner_id = :id: AND site_place_id IN ({placesIds:array})',
    'bind' => [
        'id' => $id,
        'placesIds' => $placesIds
    ]
]);
$bannerPlaces->delete();

Easier can be just add hasMany relation with alias bannerPlaces. And then just $banner->bannerPlaces->delete();

moledet · Answer 1 · 2016-09-20T10:52:21-07:00

was added

$this->hasMany('id', 'BannerSitePlace', 'banner_id', array('alias' => 'BannerSitePlaces'));

and get error

Model 'BannerSitePlace' could not be loaded

Delete by find get error

A primary key must be defined in the model in order to perform the operation

Wojciech Ślawski · Answer 2 · 2016-09-20T11:39:08-07:00

Because you forgot an namespace - Vokuro\Models\BannerSitePlace. Well looks like just Vokuro\Models\BannerSitePlace don't have primiary key - add it then.

moledet · Answer 3 · 2016-09-20T11:44:32-07:00

moledet
17.5k

in reply to

Wojciech Ślawski

Sep '16

all work in two ways after added primary autoincrement key