Mike Bayer avatar Mike Bayer committed a8bd000

postgres cant do this particular test b.c. the default "public" schema is taken
as a blank "schema" argument on Table

Comments (0)

Files changed (1)

test/engine/reflection.py

         assert buf.index("CREATE TABLE someschema.table1") > -1
         assert buf.index("CREATE TABLE someschema.table2") > -1
 
-    @testbase.unsupported('sqlite')
-    def testcreate(self):
+    @testbase.unsupported('sqlite', 'postgres')
+    def test_create_with_defaultschema(self):
         engine = testbase.db
         schema = engine.dialect.get_default_schema_name(engine)
 
+        # test reflection of tables with an explcit schemaname
+        # matching the default
         metadata = MetaData(testbase.db)
         table1 = Table('table1', metadata, 
             Column('col1', Integer, primary_key=True),
         metadata.clear()
         table1 = Table('table1', metadata, autoload=True, schema=schema)
         table2 = Table('table2', metadata, autoload=True, schema=schema)
+        assert table1.schema == table2.schema == schema
+        assert len(metadata.tables) == 2
         metadata.drop_all()
     
         
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.