Hi, I'm using sqlalchemy version 0.7.8 and MySQL Ver 14.14 Distrib 5.5.25, for osx10.6 (i386) using readline 5.1. All my tables are using InnoDB.
I'm trying to change the isolation_level, following http://docs.sqlalchemy.org/en/rel_0_7/dialects/mysql.html engine = create_engine( '[redacted]', echo=True, isolation_level="READ UNCOMMITTED" ) connection = engine.connect() # Twice to make sure ... connection.execution_options(isolation_level="READ UNCOMMITTED") # Begin a non-ORM transaction trans = connection.begin() # Bind the session to the connection Session.configure(bind=connection) from model.toaster import Toaster t = Toaster() Session.add(t) Session.commit() It does not seem to be working, I can't query object created in this transaction from another transaction. I put "READ UNCOMMITTED" twice for testing. Here is the echo output: SELECT DATABASE() () SHOW VARIABLES LIKE 'character_set%%' () SHOW VARIABLES LIKE 'lower_case_table_names' () SHOW COLLATION () SHOW VARIABLES LIKE 'sql_mode' () BEGIN (implicit) INSERT INTO toaster (created_at) VALUES (UTC_TIMESTAMP) (...) I guess I should see "SET SESSION TRANSACTION ISOLATION LEVEL <level>" but it does not appear. Thanks for your help! Chx -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/J2Ww_oAfMs0J. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
