diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2017-08-29 14:31:43 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2017-08-29 14:32:35 -0400 |
| commit | 56950a78db62d880a2f2c240c8c5873af86310c2 (patch) | |
| tree | f04e099dada18965e03c59ad6151cc144a392823 /lib/sqlalchemy/dialects/mssql/pymssql.py | |
| parent | ec4f567f31856a92bd91144112cd29df356a8ca8 (diff) | |
| download | sqlalchemy-56950a78db62d880a2f2c240c8c5873af86310c2.tar.gz | |
Implement AUTOCOMMIT for pyodbc, pymssql
In prep for CI coverage for SQL Server, allow AUTOCOMMIT
isolation level to work
Change-Id: I850b977e75f53385986f2c181be4e4412dd3b3f4
Diffstat (limited to 'lib/sqlalchemy/dialects/mssql/pymssql.py')
| -rw-r--r-- | lib/sqlalchemy/dialects/mssql/pymssql.py | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/lib/sqlalchemy/dialects/mssql/pymssql.py b/lib/sqlalchemy/dialects/mssql/pymssql.py index 57ca8ab3d..cd800471d 100644 --- a/lib/sqlalchemy/dialects/mssql/pymssql.py +++ b/lib/sqlalchemy/dialects/mssql/pymssql.py @@ -94,4 +94,12 @@ class MSDialect_pymssql(MSDialect): else: return False + def set_isolation_level(self, connection, level): + if level == 'AUTOCOMMIT': + connection.autocommit(True) + else: + connection.autocommit(False) + super(MSDialect_pymssql, self).set_isolation_level(connection, + level) + dialect = MSDialect_pymssql |