Hi, I've just had a heck of a time getting transactions to behave correctly after upgrading to 0.4dev from 0.3.6, and I just wanted to make sure that I am doing things correctly.
I've found that to totally control transactions myself, and get ORM sessions (i.e Session.flush()) to interact with SQL transactions i.e table.insert().execute(), I had to do the following. engine = create_engine(appconfig.dburi, strategy='threadlocal', echo=False) Session = scoped_session(sessionmaker(bind=engine, autoflush=False, transactional=False)) metadata = MetaData(engine) then. engine.begin() try: // Session.flush() // mytable.insert().execute() stuff engine.commit except: engine.rollback() Does this seem correct ? Previously i used autoflush=True, transactional=True together with Session.begin(), Session.commit(), Session.rollback() and I ran into all sorts of issues e.g transaction was started but never committed etc. Thanks Huy --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
