[sqlalchemy] Re: cascading question

2007-03-19 Thread Michael Bayer
yes, thats ticket #249. ive expanded the scope of that ticket since this particular pattern is much more general usage than what I initially thought it was. anyway this will be the next ticket i fix since its pretty major. On Mar 19, 2007, at 5:54 AM, Alexandre CONRAD wrote: Hello Mike,

[sqlalchemy] Re: cascading question

2007-03-19 Thread Michael Bayer
ok that ticket is fixed in the trunk On Mar 19, 2007, at 5:54 AM, Alexandre CONRAD wrote: from sqlalchemy import * meta = DynamicMetaData() # Sites site_table = Table('sites', meta, Column('id', Integer, primary_key=True), Column('name', Unicode(20), nullable=False,

[sqlalchemy] Re: cascading question

2007-03-16 Thread Alexandre CONRAD
Humm, this doesn't help as if a site is deleted, it deletes the options that where related to that option. I want to be able to: - delete an option without deleting a site - delete a site without deleting an option just delete (clean up) the related rows inside the weak options_has_sites

[sqlalchemy] Re: cascading question

2007-03-16 Thread Michael Bayer
the rows in the M2M table should be deleted automatically.it *might* require that your instances are present in the session but its not supposed to. can you make me a short test case for this one ? its not the first time ive heard about it. technically you can just put ON DELETE