Cascade Delete Problem. Help, please!

aaaa0441 · #1 (**permalink**) 09-02-2007, 03:56 PM

I have the following three classes set with cascade delete. But, cascade delete is only working for a direct relationship (i.e. parent-child). It is not working for a grandparent-grandchild relationship.
E.g. when I delete a user, only posters that references this user are cascade deleted. However, the posterImages that reference the deleted posters are left untouched in the posterImage table.

Is that a flaw of ZF?

PHP Code:


			
class User extends Zend_Db_DixMarsTable

{

    protected $_name = 'user';

    protected $_dependentTables = array('Poster');

}

PHP Code:


			
class Poster extends Zend_Db_DixMarsTable

{

    protected $_name = 'poster';

    protected $_dependentTables = array('PosterImage');

    protected $_referenceMap = array(

        'trader' => array(

            'columns'        => 'trader',

            'refTableClass'    => 'User',

            'refColumns'    => 'id',

            'onDelete'        => self::CASCADE,

            'onUpdate'        => self::CASCADE

        )

    );

}

PHP Code:


			
class PosterImage extends Zend_Db_DixMarsTable

{

    protected $_name = 'posterImage';

    protected $_referenceMap = array(

        'Poster' => array(

            'columns'        => 'poster',

            'refTableClass'    => 'Poster',

            'refColumns'    => 'id',

            'onDelete'        => self::CASCADE,

            'onUpdate'        => self::CASCADE

        )

    );

}

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode