11 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: is MapperExtension.a...
FromSent OnAttachments
David Bonner29 Apr 2008 14:54 
Michael Bayer30 Apr 2008 06:28 
Rick Morrison30 Apr 2008 07:55 
David Bonner30 Apr 2008 08:09 
David Bonner30 Apr 2008 08:21 
Rick Morrison30 Apr 2008 08:22 
David Bonner30 Apr 2008 08:28 
Michael Bayer30 Apr 2008 08:30 
David Bonner30 Apr 2008 09:14 
Michael Bayer30 Apr 2008 11:50 
David Bonner30 Apr 2008 11:57 
Subject:[sqlalchemy] Re: is MapperExtension.after_update() called before the UPDATE is issued to the DB?
From:Michael Bayer (mike@zzzcomputing.com)
Date:04/30/2008 08:30:34 AM
List:com.googlegroups.sqlalchemy

On Apr 30, 2008, at 11:22 AM, David Bonner wrote:

When this code drops me into pdb, the data in instance.notes looks like the new value, but querying the db in a separate process gets me the old value.

flush() always uses a transaction, so when your pdb process hits, the transaction has not been committed yet and results are not visible outside of the transaction. the "transactional" keyword on Session does not mean "don't use transactions at all", it means "don't automatically enter a transaction outside of a flush". Its been renamed to "autocommit" in 0.5.