CakePHP recursive delete

Question

There are posts and comments table.

For one post there are multiple comments.

If i delete one post will the comments for that post be automatically deleted in cakephp ?

book.cakephp.org/view/1039/Associations-Linking-Models-Together (look for "dependent") — NullUserException
– NullUserException, Commented Sep 1, 2011 at 7:40
Yes, i want to delete those comments with that post. How can i do that ? — cola
– cola, Commented Sep 1, 2011 at 7:56
Have you tried it? book.cakephp.org/view/1036/delete: "Deletes the record identified by $id. By default, also deletes records dependent on the record specified to be deleted." — JJJ
– JJJ, Commented Sep 1, 2011 at 8:30

Anh Pham · Accepted Answer · 2011-09-01 08:41:41Z

6

var $hasMany = array(
  'Comment' => array(
     'className' => 'Comment',
     'foreignKey' => 'post_id',
     'dependent'=> true
   )
);

answered Sep 1, 2011 at 8:41

Anh Pham

5,4713 gold badges25 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

'dependent'=> true is the key !

shesek · Accepted Answer · 2011-09-01 08:20:32Z

1

This really shouldn't be up to CakePHP... let your database handle that by using FOREIGN KEY constraints and set it to ON DELETE CASCADE

answered Sep 1, 2011 at 8:20

shesek

4,7001 gold badge30 silver badges27 bronze badges

Benjamin Crouzier · Accepted Answer · 2011-09-01 07:52:50Z

0

If you are using the foreign key Constraint ON DELETE CASCADE, yes.

See here for documentation (works with engine InnoDB)

answered Sep 1, 2011 at 7:52

Benjamin Crouzier

42.2k48 gold badges179 silver badges240 bronze badges

I didn't use foreign key constraint. var $hasMany=array('Comment'); and var $belongsTo = array('Post');