From 663e6f1d60c99fa93da479b4f6f3b3c5e49cc2a8 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 21 Aug 2024 10:49:27 -0400 Subject: [PATCH] add missing slash for sqlite URL with explicit :memory: Fixes: #11772 Change-Id: I3bdb1c81c5a503cb16143c9d1c130ec79769fbca --- lib/sqlalchemy/dialects/sqlite/pysqlite.py | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/lib/sqlalchemy/dialects/sqlite/pysqlite.py b/lib/sqlalchemy/dialects/sqlite/pysqlite.py index 43ce043a97..ab6ce6dc43 100644 --- a/lib/sqlalchemy/dialects/sqlite/pysqlite.py +++ b/lib/sqlalchemy/dialects/sqlite/pysqlite.py @@ -52,11 +52,11 @@ used. Double backslashes are probably needed:: e = create_engine('sqlite:///C:\\path\\to\\database.db') To use sqlite ``:memory:`` database specify it as the filename using -``sqlite://:memory:``. It's also the default if no filepath is +``sqlite:///:memory:``. It's also the default if no filepath is present, specifying only ``sqlite://`` and nothing else:: - # in-memory database - e = create_engine('sqlite://:memory:') + # in-memory database (note three slashes) + e = create_engine('sqlite:///:memory:') # also in-memory database e2 = create_engine('sqlite://') -- 2.47.2