From c124fa36d5af2c85c87c51d24e92387adffbe3d2 Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Wed, 18 May 2016 11:07:02 -0400
Subject: Support "blank" schema when MetaData.schema is set

Previously, it was impossible to have a Table that has
None for a schema name when the "schema" parameter on
MetaData was set.  A new symbol sqlalchemy.schema.BLANK_SCHEMA
is added which indicates that the schema name should unconditionally
be set to None.  In particular, this value must be passed within
cross-schema foreign key reflection, so that a Table which
is in the "default" schema can be represented properly.

Fixes: #3716
Change-Id: I3d24f99c22cded206c5379fd32a225e74edb7a8e
---
 test/sql/test_metadata.py | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'test/sql')

diff --git a/test/sql/test_metadata.py b/test/sql/test_metadata.py
index 050929d3d..449956fcd 100644
--- a/test/sql/test_metadata.py
+++ b/test/sql/test_metadata.py
@@ -7,7 +7,8 @@ from sqlalchemy import Integer, String, UniqueConstraint, \
     CheckConstraint, ForeignKey, MetaData, Sequence, \
     ForeignKeyConstraint, PrimaryKeyConstraint, ColumnDefault, Index, event,\
     events, Unicode, types as sqltypes, bindparam, \
-    Table, Column, Boolean, Enum, func, text, TypeDecorator
+    Table, Column, Boolean, Enum, func, text, TypeDecorator, \
+    BLANK_SCHEMA
 from sqlalchemy import schema, exc
 from sqlalchemy.engine import default
 from sqlalchemy.sql import elements, naming
@@ -446,6 +447,7 @@ class MetaDataTest(fixtures.TestBase, ComparesTables):
                     ('t2', m1, 'sch2', None, 'sch2', None),
                     ('t3', m1, 'sch2', True, 'sch2', True),
                     ('t4', m1, 'sch1', None, 'sch1', None),
+                    ('t5', m1, BLANK_SCHEMA, None, None, None),
                     ('t1', m2, None, None, 'sch1', True),
                     ('t2', m2, 'sch2', None, 'sch2', None),
                     ('t3', m2, 'sch2', True, 'sch2', True),
@@ -458,6 +460,7 @@ class MetaDataTest(fixtures.TestBase, ComparesTables):
                     ('t2', m4, 'sch2', None, 'sch2', None),
                     ('t3', m4, 'sch2', True, 'sch2', True),
                     ('t4', m4, 'sch1', None, 'sch1', None),
+                    ('t5', m4, BLANK_SCHEMA, None, None, None),
                 ]):
             kw = {}
             if schema is not None:
-- 
cgit v1.2.1