Delete associative table rows when deleting a main model entry

Question

I have 2 models, usergroups and usergrouppermissions. my usergrouppermissions has a field called user_group_id which links back to the main usergroup. In a case where I want to delete the user group, I automatically want it to delete the entry in the database for usergrouppermissions (as the user group wont exist) anymore. I have tried delete, however, it just deletes the usergroup.

  // Here is my model: (usergroup):
  public $hasMany = array(
       'UserGroupPermission'
  );

  // Here is the usergrouppermissions model:
  public $belongsTo = array(
        "UserGroup"
    );

Look at this answer: http://stackoverflow.com/questions/5712932/cakephp-delete-cascade-not-working — DarkFighter, Aug 13 '12 at 10:56

score 1 · Accepted Answer · answered Aug 13 '12 at 11:45

1

Try:

$this->Model->delete($item_to_delete_id,true);

delete() docs.

answered Aug 13 '12 at 11:45

L. Sanna

6,482
7
33
47

Delete associative table rows when deleting a main model entry

1 Answers1