On Tue, Feb 27, 2007 at 04:54:17PM -0300, Leandro Lucarella wrote:
> Hi! Is there any documentation on 'cascade', 'constraints' SOCol options
> (besides the source code ;)?

   SQLObject's docs really need a lot of work. A small doc patch about your
discoveries can help.

> As far as I can understand from the code, 'cascade' could be None (meaning
> no action is done explicitely), True (meaning ON DELETE CASCADE), False
> (meaning ON DELETE RESTRICT) and 'null' (meaning ON DELETE SET NULL).
> you can only use it in ForeignKey columns.

   Right.

> I see there are no constraints
> set to intermediate tables of RelatedJoin, they don't even specify that
> they are Foreingkeys

   It could be implemented by per-connection type basis, the framework is
already there. It just happens nobody has implemented the constraints.
   Want to help? What DB do you use?

> When a Role is removed, is there any way to tell SQLObject (and that he
> tells to the RDBM) to remove all role_user rows that has the id of the
> removed role?

   This was implemented in SQLObject 0.7.2. Must happens automagically on
row.destroySelf().

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

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to