From a9a1f912fd9445d7496584a256e449ad1fd2a808 Mon Sep 17 00:00:00 2001 From: Jonathan Ellis Date: Sun, 29 Jul 2007 04:15:14 +0000 Subject: engine.table_names() tested vs sqlite and pg. mssql should also be ok (uses ischema like pg.) others are best-guess based on has_table code. --- lib/sqlalchemy/databases/sqlite.py | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'lib/sqlalchemy/databases/sqlite.py') diff --git a/lib/sqlalchemy/databases/sqlite.py b/lib/sqlalchemy/databases/sqlite.py index 725ea23e2..9492de8da 100644 --- a/lib/sqlalchemy/databases/sqlite.py +++ b/lib/sqlalchemy/databases/sqlite.py @@ -224,6 +224,10 @@ class SQLiteDialect(ansisql.ANSIDialect): def oid_column_name(self, column): return "oid" + + def table_names(self, connection, schema): + s = "SELECT name FROM sqlite_master WHERE type='table'" + return [row[0] for row in connection.execute(s)] def has_table(self, connection, table_name, schema=None): cursor = connection.execute("PRAGMA table_info(%s)" % -- cgit v1.2.1