[sqlalchemy] Re: ondelete cascade with turbogears/SA

2007-08-16 Thread James
just to make sure I'm understanding this: even though mysql is configured to cascade deletes for this relationship, SA needs to be told about it so that it doesn't prevent it from cascading by first nulling the foreign key? I tried this: class Account(ActiveMapper): class mapping:

[sqlalchemy] Re: ondelete cascade with turbogears/SA

2007-08-16 Thread Michael Bayer
On Aug 16, 11:48 am, James [EMAIL PROTECTED] wrote: just to make sure I'm understanding this: even though mysql is configured to cascade deletes for this relationship, SA needs to be told about it so that it doesn't prevent it from cascading by first nulling the foreign key? yes more or

[sqlalchemy] Re: ondelete cascade with turbogears/SA

2007-08-16 Thread James
I've seen some of the Elixir info and thought it was too new to start using just yet. How hard is it to transition from ActiveMapper to Elixir, given a moderately sized model and a moderate amount of access by controllers? If I go with direct access to SA API in model, where do the