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.commit() session.query....for..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. 2. I am new to Sqlalchemy and DB based apps in general. The actual problem I am trying to solve is to write apis that create/update/ delete objects while in a long running transaction without having to commit this long running transaction. I am trying to use nested transactions to see if I can get this to work but if there is a better way to do this then such pointers will be much appreciated. -srp --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
