Fix entry point and some issues with sqlite glob operand

[datasette-pytables.git] / datasette_pytables / __init__.py

diff --git a/datasette_pytables/__init__.py b/datasette_pytables/__init__.py
index 7b4d33c1b8ffc4c7d7bdb1392c1fbfa13d11d247..4c1cc0f9837aff45375c1f6c1654b8e71d359094 100644 (file)
--- a/datasette_pytables/__init__.py
+++ b/datasette_pytables/__init__.py
@@ -122,6 +122,10 @@ class PyTablesConnector(dc.Connector):
         truncated = False
         description = ()
 
+        # Some Datasette queries uses glob operand, not supported by Pytables
+        if ' glob ' in sql:
+            return results, truncated, description
+
         parsed_sql = parse_sql(sql, params)
 
         while isinstance(parsed_sql['from'], dict):
@@ -231,8 +235,7 @@ class PyTablesConnector(dc.Connector):
 
         # Execute query
         if query:
-            if not ' glob ' in query:
-                table_rows = table.where(query, params, start, end)
+            table_rows = table.where(query, params, start, end)
         elif orderby:
             table_rows = table.itersorted(orderby, start=start, stop=end)
         else: