Re: [Zope-dev] Possible bug in zope.sqlalchemy - missing commit()

Hermann Himmelbauer wrote:

Hi, I'm experiencing some possible bug with sqlalchemy here:

- I query for some data - Update some data - Make no flush (autoflush is set to False)

Then no commit is issued, hence my data is not updated in the database.

At least, I looked at the function "tpc_vote" and put some print statement there and self.tx seems to be None, therefore, no commit() is issued.

If I do a session.flush() after the updates, the session is perfectly commited.

Does anyone know why and what I can do about it?

Best Regards, Hermann

Set autoflush=True or explicitly flush. Laurence