On Wed, Oct 10, 2007 at 03:41:22PM +0200, [EMAIL PROTECTED] wrote:
> I'd like to delete Multiple objects at once by deleting their parent
> object. I'd expect the DB's cascade mechanics to handle the details for me,
> but, as it seems, SQLObject deletes related objects BEFORE passing the
> delete command of the parent object to the DB.
> 
> An Example:
> 
> class AB(sqlobject.SQLObject):
>     a = sqlobject.ForeignKey('A', cascade = True)
>     b = sqlobject.ForeignKey('B', cascade = True)
> 
> class A(sqlobject.SQLObject):
>     b = sqlobject.RelatedJoin('B', intermediateTable = AB.sqlmeta.table,
> createRelatedTable = False)
> 
> class B(sqlobject.SQLObject):
>     a = sqlobject.RelatedJoin('A', intermediateTable = AB.sqlmeta.table,
> createRelatedTable = False)

   In case of RelatedJoins SQLObject deletes objects from the intermediate
table itself because the table can be hidden from the user at all - it is
usually automatically created and maintained.

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            [EMAIL PROTECTED]
           Programmers don't die, they just GOSUB without RETURN.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to