Hi All,
I'm wondering where I can find out more about the kind of thing
described here:
http://www.sqlalchemy.org/docs/session.html#enabling-two-phase-commit
Here's the situation:
engine = create_engine(...encoding='utf-8', pool_recycle=3600)
SessionCls = sessionmaker(bind=engine, autoflush=True, autocommit=False)
...stuff...
session1 = SessionCls()
...do ORM-ish stuff in session1..
session2 = sessionmaker(create_engine('mysql://server/legacy_db,
echo=False,
pool_recycle=3600))()
session2.execute('raw sql update',{...some keywords to substitute...}
Now, what we'd like to do at this point is have both session1 and
session2 commit or rollback in a two-phase manner.
How can we achieve this?
cheers,
Chris
--
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.
