On 09/12/2010 10:37 AM, chaouche yacine wrote: > Yes, except I wanted the children *not* to be deleted but raise an > integrity_error exception instead, because what was done is that they were > not deleted but their FK (pointing to the parent) were set to NULL and they > were raising a non-null constraint related exception. > > > > > --- On Sun, 9/12/10, alex bodnaru <[email protected]> wrote: > >> From: alex bodnaru <[email protected]> >> Subject: Re: [elixir] problem with cascade deletes >> To: [email protected] >> Date: Sunday, September 12, 2010, 1:21 AM >> hello yacine, >> >> elixir isn't known to reinvent sa, but please point me to >> things you would >> change for a pure approach. >> part of the lower level stuff is needed to turn foreign >> keys on in sqlite. >> >> in the mean time, i did a declarative example which fails >> like elixir. >> >> btw. this is the same problem you have also previously >> reported on this list. >> >> alex >> >> On 09/12/2010 09:58 AM, chaouche yacine wrote: >>> hello alex, >>> >>> In your elixir program, you are mixing some imports >> from sqlalchemy (create_engine from example) with imports >> from elixir. Did you try an elixir only approach ? >>> Y.Chaouche >>> >>> >>> >>> --- On Sat, 9/11/10, alex bodnaru <[email protected]> >> wrote: >>>> From: alex bodnaru <[email protected]> >>>> Subject: [elixir] problem with cascade deletes >>>> To: [email protected] >>>> Date: Saturday, September 11, 2010, 6:31 AM >>>> >>>> hello friends, >>>> >>>> there seems to be a flaw in elixir with cascade >> deletes. >>>> i have a program that does it with sqlalchemy orm, >> and a >>>> similar one to do it >>>> with elixir. >>>> instead of deleting the elixir program only nulls >> the keys >>>> in the child. >>>> >>>> the programs are attached. >>>> >>>> best regards, >>>> alex >>>> >>>> -- >>>> You received this message because you are >> subscribed to the >>>> Google Groups "SQLElixir" group. >>>> To post to this group, send email to [email protected]. >>>> To unsubscribe from this group, send email to >> [email protected]. >>>> For more options, visit this group at >>>> http://groups.google.com/group/sqlelixir?hl=en. >>>> >>>> >>> >>> >> -- >> You received this message because you are subscribed to the >> Google Groups "SQLElixir" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/sqlelixir?hl=en. >> >> > > > look, this happens here too ;)
-- You received this message because you are subscribed to the Google Groups "SQLElixir" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlelixir?hl=en.
