[sqlalchemy] Re: Outer transaction does not see changes from nested transaction - SA 0.5

2009-01-17 Thread Michael Bayer
On Jan 17, 2009, at 2:10 AM, Saju Pillai wrote: > The sequence of events I mentioned were incorrect. The following > happens > > session.begin_nested() > session.delete(some_obj) > session.commit() > > if some_obj in some_other_obj.foreign_key_based_collection: > ---> retur

[sqlalchemy] Re: Outer transaction does not see changes from nested transaction - SA 0.5

2009-01-16 Thread Saju Pillai
> > > session.begin_nested() > > session.delete(some_obj) > > session.commit() > > > session.queryfor..some_obj finds it. > > > 1. How can I get the changes in the nested transaction to turn up in > > the outer transaction without having to commit the outer transaction. > > you should be gett

[sqlalchemy] Re: Outer transaction does not see changes from nested transaction - SA 0.5

2009-01-16 Thread Michael Bayer
On Jan 16, 2009, at 3:18 AM, Saju Pillai wrote: > > Hi, > > I start a nested transaction and delete a object from the session and > commit. The outer transaction does not see this delete. I tried to > flush but that didn't help. > > session.begin_nested() > session.delete(some_obj) > session.com