Hi, It seems even with vanilla DBSession = scoped_session(sessionmaker()), all my SQLs, even the SELECT --
DBSession.configure(bind=engine) Base.metadata.bind = engine dbsession = DBSession() dbsession.expire_on_commit = False dbsession.autocommit = True dbsession.query(...) are wrapped in one giant transaction -- 2011-05-08 15:22:48,857 INFO sqlalchemy.engine.base.Engine.0x...9aac BEGIN (implicit) 2011-05-08 15:22:48,865 INFO sqlalchemy.engine.base.Engine.0x...9aac SELECT ... Is there a way to disable SQLAlchemy transaction or at least make them only applicable to small regions of INSERT and UPDATE? Thanks in advance! Jerry -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. 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.
