From e560794883c5a3259aa4208ee7c5aa0740cb3087 Mon Sep 17 00:00:00 2001 From: Federico Caselli Date: Tue, 12 Mar 2024 23:05:50 +0100 Subject: [PATCH] improve docs for sqlite memory db Change-Id: Icdbc13bdad3fb5ae69e79605bb7e6cb82d538c80 References: #10968 --- lib/sqlalchemy/dialects/sqlite/pysqlite.py | 9 ++++++--- lib/sqlalchemy/ext/automap.py | 2 +- 2 files changed, 7 insertions(+), 4 deletions(-) diff --git a/lib/sqlalchemy/dialects/sqlite/pysqlite.py b/lib/sqlalchemy/dialects/sqlite/pysqlite.py index 006d7f0422..43ce043a97 100644 --- a/lib/sqlalchemy/dialects/sqlite/pysqlite.py +++ b/lib/sqlalchemy/dialects/sqlite/pysqlite.py @@ -51,11 +51,14 @@ used. Double backslashes are probably needed:: # absolute path on Windows e = create_engine('sqlite:///C:\\path\\to\\database.db') -The sqlite ``:memory:`` identifier is the default if no filepath is -present. Specify ``sqlite://`` and nothing else:: +To use sqlite ``:memory:`` database specify it as the filename using +``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://') + e = create_engine('sqlite://:memory:') + # also in-memory database + e2 = create_engine('sqlite://') .. _pysqlite_uri_connections: diff --git a/lib/sqlalchemy/ext/automap.py b/lib/sqlalchemy/ext/automap.py index 8b0f47b8eb..5cee3c9644 100644 --- a/lib/sqlalchemy/ext/automap.py +++ b/lib/sqlalchemy/ext/automap.py @@ -1006,7 +1006,7 @@ class AutomapBase: :class:`.util.Properties`, such as ``items()``, the getitem form is also supported:: - Item = Base.classes["item"] + Item = Base.classes["items"] """ -- 2.47.2