Re: [SQLObject] Trouble with cascade

[Oleg B. <ph...@ph...>]

Hello. Sorry for the late answer. I was on vacation. (It is strange nobody
answered the question.)

On Mon, Jun 15, 2009 at 06:56:06PM +0300, Imri Goldberg wrote:
> I had some trouble with cascade='null' not being acted on when using
> deleteMany instead of destroySelf.
[skip]
> The output is:
> [<Abc 2 field1='goodbye' finalID=1>, <Abc 4 field1='shmidt' finalID=None>]
> I would expect that both objects would have finalID set to None.

   .deleteMany() sens DELETE query to the backend, so for ON DELETE
constraints it requires the backend properly implements cascading. It seems
SQLite doesn't implement it. I ran you program verbatim on Postgtres and
both finalID were None.
   .destroySelf() implements cascading itself, without relying on a
backend.

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.