From 8174e7236be3937d20fa0931af4799ab9b0f1f29 Mon Sep 17 00:00:00 2001 From: Brian Van Klaveren Date: Wed, 9 Sep 2015 14:03:14 -0700 Subject: Support get_schema_names for SQLite --- lib/sqlalchemy/dialects/sqlite/base.py | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'lib/sqlalchemy/dialects/sqlite/base.py') diff --git a/lib/sqlalchemy/dialects/sqlite/base.py b/lib/sqlalchemy/dialects/sqlite/base.py index e19047b76..fcb39da86 100644 --- a/lib/sqlalchemy/dialects/sqlite/base.py +++ b/lib/sqlalchemy/dialects/sqlite/base.py @@ -1094,6 +1094,13 @@ class SQLiteDialect(default.DefaultDialect): else: return None + @reflection.cache + def get_schema_names(self, connection, **kw): + s = "PRAGMA database_list" + dl = connection.execute(s) + + return [db[1] for db in dl] + @reflection.cache def get_table_names(self, connection, schema=None, **kw): if schema is not None: -- cgit v1.2.1