From 0cca04a8922418130a30003f0c518b77548353a9 Mon Sep 17 00:00:00 2001 From: Paul Johnston Date: Wed, 8 Aug 2007 20:41:23 +0000 Subject: [PATCH] automatically use_scope_identity if an appropriate version of PyODBC is installed --- lib/sqlalchemy/databases/mssql.py | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/lib/sqlalchemy/databases/mssql.py b/lib/sqlalchemy/databases/mssql.py index ba1c0fd9d6..6c78501857 100644 --- a/lib/sqlalchemy/databases/mssql.py +++ b/lib/sqlalchemy/databases/mssql.py @@ -704,6 +704,15 @@ class MSSQLDialect_pymssql(MSSQLDialect): class MSSQLDialect_pyodbc(MSSQLDialect): + def __init__(self, **params): + super(MSSQLDialect_pyodbc, self).__init__(**params) + # whether use_scope_identity will work depends on the version of pyodbc + try: + import pyodbc + self.use_scope_identity = hasattr(pyodbc.Cursor, 'nextset') + except: + pass + def import_dbapi(cls): import pyodbc as module return module -- 2.47.2