FazBrowse GitHub Viewer | Trending |
URL:
| Home
Tools: [Download Repo ZIP]   [Original HTTPS Page]

support sqlite .autocommit parameter (Python 3.12) · Issue #8795 · sqlalchemy/sqlalchemy · GitHub

Repository navigation

support sqlite .autocommit parameter (Python 3.12) #8795

Open

Description

see python/cpython#93823.

change will be something equivalent towards:

diff --git a/lib/sqlalchemy/dialects/sqlite/pysqlite.py b/lib/sqlalchemy/dialects/sqlite/pysqlite.py
index 19949441fb..fe0627a1ab 100644
--- a/lib/sqlalchemy/dialects/sqlite/pysqlite.py
+++ b/lib/sqlalchemy/dialects/sqlite/pysqlite.py
@@ -531,11 +531,18 @@ class SQLiteDialect_pysqlite(SQLiteDialect):
     )
 
     def set_isolation_level(self, dbapi_connection, level):
-
         if level == "AUTOCOMMIT":
-            dbapi_connection.isolation_level = None
+            # support sqlite .autocommit feature
+            if hasattr(dbapi_connection, "autocommit"):
+                dbapi_connection.autocommit = True
+            else:
+                dbapi_connection.isolation_level = None
         else:
-            dbapi_connection.isolation_level = ""
+            # support sqlite .autocommit feature
+            if hasattr(dbapi_connection, "autocommit"):
+                dbapi_connection.autocommit = False
+            else:
+                dbapi_connection.isolation_level = ""
             return super(SQLiteDialect_pysqlite, self).set_isolation_level(
                 dbapi_connection, level
             )

Activity

  1. added this to the 2.x.x milestone on Nov 12, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions


      Back | FazBrowse Home | New Git URL