summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/dialects/sqlite/pysqlite.py
diff options
context:
space:
mode:
authorYongJieYongJie <KhooYongJie@gmx.com>2021-04-28 13:30:09 -0400
committerFederico Caselli <cfederico87@gmail.com>2021-04-28 20:52:34 +0200
commit1ee6332ba261cc1b6bbc8f427d17f81614b07d9b (patch)
tree3bdb6554999b6e7275b27734d73b30e9323b337b /lib/sqlalchemy/dialects/sqlite/pysqlite.py
parent7fdaac7b2910b5612420378519b9f60d4649daff (diff)
downloadsqlalchemy-1ee6332ba261cc1b6bbc8f427d17f81614b07d9b.tar.gz
Use SingletonThreadPool for in-memory SQLite
database created using filename uri Default to using ``SingletonThreadPool`` for in-memory SQLite databases created using URI filenames. Previously the default pool used was the ``NullPool`` that precented sharing the same database between multiple engines. Fixes: #6379 Closes: #6380 Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/6380 Pull-request-sha: 3b8024417a3a54c8269d43e40801aa4e58593540 Change-Id: Ice09622796455e796ede7711c98f3ceec13aa949
Diffstat (limited to 'lib/sqlalchemy/dialects/sqlite/pysqlite.py')
-rw-r--r--lib/sqlalchemy/dialects/sqlite/pysqlite.py4
1 files changed, 3 insertions, 1 deletions
diff --git a/lib/sqlalchemy/dialects/sqlite/pysqlite.py b/lib/sqlalchemy/dialects/sqlite/pysqlite.py
index 0b091e73b..20a4bb7ac 100644
--- a/lib/sqlalchemy/dialects/sqlite/pysqlite.py
+++ b/lib/sqlalchemy/dialects/sqlite/pysqlite.py
@@ -474,7 +474,9 @@ class SQLiteDialect_pysqlite(SQLiteDialect):
@classmethod
def _is_url_file_db(cls, url):
- if url.database and url.database != ":memory:":
+ if (url.database and url.database != ":memory:") and (
+ url.query.get("mode", None) != "memory"
+ ):
return True
else:
return False