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. > > -- 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.
