Method to set transaction isolation level

[Former user]

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.

[Mike Bayer]

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.

[Mike Bayer]

we would like to add methods on Connection which provide this feature.

[Michael Trier]

mssql also support setting the transaction isolation level, unless I'm not understanding what is desired here.

[Former user]

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.

[jek]

Added in 5f6b770b9c10458ab2c293fa1a646ced05f6d673 for 0.6. Thanks Adam Lowry!

Additional dialect support will be added before 0.6.0.

[Mike Bayer]

Removing milestone: 0.6.0 (automated comment)