summaryrefslogtreecommitdiff
path: root/test/dialect/postgresql/test_reflection.py
diff options
context:
space:
mode:
authorRodrigo Menezes <rodrigo.menezes@moat.com>2014-09-03 16:38:43 -0400
committerRodrigo Menezes <rodrigo.menezes@moat.com>2014-09-03 16:38:43 -0400
commitfbd2d70a5cfd7b5c219c51cb5b7866c4ab89cece (patch)
tree996181dbb3fcade0e1dbfad163d01d3cb547580d /test/dialect/postgresql/test_reflection.py
parentd39be884321d0afbae7ef3da556382b53fef8060 (diff)
downloadsqlalchemy-fbd2d70a5cfd7b5c219c51cb5b7866c4ab89cece.tar.gz
Fixing some pep8s and adding get_foreign_tables.
Diffstat (limited to 'test/dialect/postgresql/test_reflection.py')
-rw-r--r--test/dialect/postgresql/test_reflection.py17
1 files changed, 11 insertions, 6 deletions
diff --git a/test/dialect/postgresql/test_reflection.py b/test/dialect/postgresql/test_reflection.py
index 405ac5921..567aec927 100644
--- a/test/dialect/postgresql/test_reflection.py
+++ b/test/dialect/postgresql/test_reflection.py
@@ -13,7 +13,7 @@ import sqlalchemy as sa
from sqlalchemy.dialects.postgresql import base as postgresql
-class AlternateRelkindReflectionTest(fixtures.TestBase, AssertsExecutionResults):
+class AltRelkindReflectionTest(fixtures.TestBase, AssertsExecutionResults):
"""Test reflection on materialized views and foreign tables"""
__requires__ = 'postgresql_test_dblink',
@@ -23,7 +23,8 @@ class AlternateRelkindReflectionTest(fixtures.TestBase, AssertsExecutionResults)
@classmethod
def setup_class(cls):
from sqlalchemy.testing import config
- cls.dblink = config.file_config.get('sqla_testing', 'postgres_test_db_link')
+ cls.dblink = config.file_config.get('sqla_testing',
+ 'postgres_test_db_link')
metadata = MetaData(testing.db)
testtable = Table(
@@ -39,8 +40,10 @@ class AlternateRelkindReflectionTest(fixtures.TestBase, AssertsExecutionResults)
for ddl in \
"CREATE MATERIALIZED VIEW test_mview AS SELECT * FROM testtable;", \
- "CREATE SERVER test_server FOREIGN DATA WRAPPER postgres_fdw OPTIONS (dbname 'test', host '%s');" % cls.dblink, \
- "CREATE USER MAPPING FOR public SERVER test_server options (user 'scott', password 'tiger');", \
+ "CREATE SERVER test_server FOREIGN DATA WRAPPER postgres_fdw \
+ OPTIONS (dbname 'test', host '%s');" % cls.dblink, \
+ "CREATE USER MAPPING FOR public \
+ SERVER test_server options (user 'scott', password 'tiger');", \
"CREATE FOREIGN TABLE test_foreigntable ( \
id INT, \
data VARCHAR(30) \
@@ -63,7 +66,8 @@ class AlternateRelkindReflectionTest(fixtures.TestBase, AssertsExecutionResults)
def test_mview_is_reflected(self):
metadata = MetaData(testing.db)
table = Table('test_mview', metadata, autoload=True)
- eq_(set(table.columns.keys()), set(['id', 'data']), "Columns of reflected mview didn't equal expected columns")
+ eq_(set(table.columns.keys()), set(['id', 'data']),
+ "Columns of reflected mview didn't equal expected columns")
def test_mview_select(self):
metadata = MetaData(testing.db)
@@ -75,7 +79,8 @@ class AlternateRelkindReflectionTest(fixtures.TestBase, AssertsExecutionResults)
def test_foreign_table_is_reflected(self):
metadata = MetaData(testing.db)
table = Table('test_foreigntable', metadata, autoload=True)
- eq_(set(table.columns.keys()), set(['id', 'data']), "Columns of reflected foreign table didn't equal expected columns")
+ eq_(set(table.columns.keys()), set(['id', 'data']),
+ "Columns of reflected foreign table didn't equal expected columns")
def test_foreign_table_select(self):
metadata = MetaData(testing.db)