Check if table exists before getting table definition

[datasette-connectors.git] / datasette_connectors / cursor.py

diff --git a/datasette_connectors/cursor.py b/datasette_connectors/cursor.py
index f3898cc23f4d97eca9eba0e12a9e7b1ea95fe240..bf3a1b1dbf177ec48f33ff216365ccca17db6ed1 100644 (file)
--- a/datasette_connectors/cursor.py
+++ b/datasette_connectors/cursor.py
@@ -67,7 +67,8 @@ class Cursor:
             if self.connector.table_exists(params[0]):
                 results = [{'1': '1'}]
         elif sql == "select sql from sqlite_master where name = :n and type=:t":
-            results = [{'sql': self.connector.table_definition(params['t'], params['n'])}]
+            if self.connector.table_exists(params['n']):
+                results = [{'sql': self.connector.table_definition(params['t'], params['n'])}]
         elif sql == "select sql from sqlite_master where tbl_name = :n and type='index' and sql is not null":
             results = [{'sql': sql} for sql in self.connector.indices_definition(params['n'])]
         else: