googleapis · skuruppu · Dec 1, 2021 · Nov 30, 2021 · Dec 1, 2021 · Dec 1, 2021
@@ -257,7 +257,7 @@ Data types table mapping SQLAlchemy types to Cloud Spanner types:
 ### Other limitations 
 - WITH RECURSIVE statement is not supported.
 - Named schemas are not supported.
-- Temporary tables are not supported, real tables are used instead.
+- Temporary tables are not supported.
 - Numeric type dimensions (scale and precision) are constant. See the [docs](https://cloud.google.com/spanner/docs/data-types#numeric_types).
 
 ## Best practices

@@ -17,4 +17,4 @@
 
 @temp_table_keyword_args.for_db("spanner")
 def _spanner_temp_table_keyword_args(cfg, eng):
-    return {}
+    return {"prefixes": ["TEMPORARY"]}
@@ -68,6 +68,11 @@ def isolation_level(self):
     def sequences(self):
         return exclusions.closed()
 
+    @property
+    def temporary_tables(self):
+        """Target database supports temporary tables."""
+        return exclusions.closed()
+
     def get_order_by_collation(self, _):
         """Get the default collation name.
 

@@ -341,6 +341,9 @@ def post_create_table(self, table):
         cols = [col.name for col in table.primary_key.columns]
         post_cmds = " PRIMARY KEY ({})".format(", ".join(cols))
 
+        if "TEMPORARY" in table._prefixes:
+            raise NotImplementedError("Temporary tables are not supported.")
+
         if table.kwargs.get("spanner_interleave_in"):
             post_cmds += ",\nINTERLEAVE IN PARENT {}".format(
                 table.kwargs["spanner_interleave_in"]

@@ -36,7 +36,6 @@
 from sqlalchemy.testing import provide_metadata, emits_warning
 from sqlalchemy.testing import fixtures
 from sqlalchemy.testing import is_true
-from sqlalchemy.testing.provision import temp_table_keyword_args
 from sqlalchemy.testing.schema import Column
 from sqlalchemy.testing.schema import Table
 from sqlalchemy import literal_column
@@ -676,7 +675,6 @@ def define_temp_tables(cls, metadata):
         creating unique constraints. Overriding the test to replace
         constraints with indexes in testing data.
         """
-        kw = temp_table_keyword_args(config, config.db)
         user_tmp = Table(
             "user_tmp",
             metadata,
@@ -685,7 +683,6 @@ def define_temp_tables(cls, metadata):
             Column("foo", sqlalchemy.INT),
             sqlalchemy.Index("user_tmp_uq", "name", unique=True),
             sqlalchemy.Index("user_tmp_ix", "foo"),
-            **kw,
         )
         if (
             testing.requires.view_reflection.enabled