MainelyDesign.com Blog

Delete Dependent Just Deleted All My Records

Posted on 09/17/2009 at 10:12 am by Kevin Wentworth
Viewed 2,486 times | 8 comments

Oh man! I just deleted all my database records using $model->del($id) with dependent=>true in the model association. That wasn't supposed to happen! It turns out to be an issue with how I specified my model association. What's weird is that everything works fine except when I go to do the delete with cascade set to true.

Use an array for conditions when associating models

I was using some older model code and never changed it because everything worked fine. However, the issue came down to not using an array for my conditions within the model association. I have a model gallery that hasMany images and is dependent. Below is the old code and the new code:

Bad code (note the conditions string):

Show Plain Text

class Gallery extends AppModel {
 
    var $name = 'Gallery';
    var $hasMany = array(
        'Image' => array
        (
            'className' => 'Image',
            'order' => 'Image.sort_order ASC',
            'foreignKey' => 'type_id',
            'conditions' => "Image.type = 'gallery'", //BAD!
            'dependent' => true
        ),
    );  
    
}

Good code (note the conditions array):

Show Plain Text

class Gallery extends AppModel {
 
    var $name = 'Gallery';
    var $hasMany = array(
        'Image' => array
        (
            'className' => 'Image',
            'order' => 'Image.sort_order ASC',
            'foreignKey' => 'type_id',
            'conditions' => array('Image.type' => 'gallery'), //GOOD!
            'dependent' => true
        ),
    );  
    
}

Array_merge() error in model.php at line 1763

The issue is that CakePHP wants to merge the conditions array with the existing conditions. That's why your model association conditions MUST be an array.

Cheers,

-Kevin Wentworth

Tags for Delete Dependent Just Deleted All My Records

Cakephp | Web Programming | Mysql | Usage | Database

Comments for this Posting

Posted by narnia

on 10/12/10

great post, just the kind of information I was looking for

http://www.youtube.com/watch?v=oryKVZfix_Y

Posted by PXStevey

on 24/1/11

Hi, I'm new I would like to welcome all... :)

http://filesarchive.wroclaw.pl/

Posted by Poker Gratis

on 17/2/11

Texto prazeroza nesta página, visões como aqui está dão valor a quem reflectir neste blogue .....
Realiza muito mais do teu blogue, aos teus utilizadores.

http://www.pokersemdeposito.com/