Method to set transaction isolation level
It would be useful to set transaction isolation level from python code in a server independent manner. Backends without such a thing should simply ignore this setting. I did not write an implementation, since I'm not sure exactly where to add this code.
Comments (8)
-
repo owner -
repo owner - changed milestone to blue sky
-
repo owner we would like to add methods on
Connection
which provide this feature. -
repo owner - changed milestone to 0.5.xx
-
mssql also support setting the transaction isolation level, unless I'm not understanding what is desired here.
-
Account Deleted I have an initial patch for the psycopg2 part of this. Instead of adding a method on Connection I moved connect() from only inside DefaultEngineStrategy.create to the dialects. This way the dbapi.connect() call is not executed directly but deferred to the dialect.
I'm not sure about mssql; I don't have access to that.
-
Added in 5f6b770b9c10458ab2c293fa1a646ced05f6d673 for 0.6. Thanks Adam Lowry!
Additional dialect support will be added before 0.6.0.
-
repo owner - removed milestone
Removing milestone: 0.6.0 (automated comment)
- Log in to comment
neither am i. closest thing you can do for now is write your own connect() function which sets it on each connection. also afaik psycopg2 is the only DBAPI that supports transaction isolation in any way.