On Feb 11, 2011, at 2:55 PM, Romy wrote: > On Feb 11, 9:10 am, Michael Bayer <[email protected]> wrote: >>> For instance, rearranging the below to: >> >>> user = User.query.filter_by(id=1).first() >>> user.x = user.x + 1 >>> elixir.session.commit() >> >>> results in a BEGIN, SELECT, UPDATE, COMMIT log output. When I >>> introduce another query before the commit, the COMMIT is never >>> printed. >> >> That's just something specific to what your code is doing. If you call >> commit(), and there's a transaction in progress, and it doesn't throw an >> exception, you'll see COMMIT in the logs. If you're still playing around >> with autocommit=True, there's no transaction unless you just called begin(). > > That's just it -- all of the above is happening with autocommit=False. > Why would a transaction not be present ? Even if this was affected by > the underlying engine (eg, MyISAM), I'd still expect the BEGIN/COMMIT > output to be either consistent or completely non-existent.
that is absolutely true. works in all of our tests.... do you have one to demonstrate ? > > -- > 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. > -- 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.
