summaryrefslogtreecommitdiff
path: root/test/dialect/postgresql/test_reflection.py
diff options
context:
space:
mode:
authorSebastian Bank <sebastian.bank@uni-leipzig.de>2016-04-11 23:16:39 -0400
committerMike Bayer <mike_mp@zzzcomputing.com>2016-06-06 18:57:10 -0400
commit824c8664ed18f115fc109c46cec0c25d223f8aad (patch)
treedf918426223781a53331974b8c2422e138e57bc7 /test/dialect/postgresql/test_reflection.py
parenta90b0101aaf616cddb8bc675f4a221fe7de6c420 (diff)
downloadsqlalchemy-824c8664ed18f115fc109c46cec0c25d223f8aad.tar.gz
Support normal /materialized views in PG separately
Fixes: #3588 Change-Id: Ifbfcab67375f289ddb5c4522f4b803cb8b7c34de Pull-request: https://github.com/zzzeek/sqlalchemy/pull/250
Diffstat (limited to 'test/dialect/postgresql/test_reflection.py')
-rw-r--r--test/dialect/postgresql/test_reflection.py22
1 files changed, 21 insertions, 1 deletions
diff --git a/test/dialect/postgresql/test_reflection.py b/test/dialect/postgresql/test_reflection.py
index a0f9dcd49..84aeef130 100644
--- a/test/dialect/postgresql/test_reflection.py
+++ b/test/dialect/postgresql/test_reflection.py
@@ -130,7 +130,27 @@ class MaterializedViewReflectionTest(
def test_get_view_names(self):
insp = inspect(testing.db)
- eq_(set(insp.get_view_names()), set(['test_mview', 'test_regview']))
+ eq_(set(insp.get_view_names()), set(['test_regview', 'test_mview']))
+
+ def test_get_view_names_plain(self):
+ insp = inspect(testing.db)
+ eq_(
+ set(insp.get_view_names(include=('plain',))),
+ set(['test_regview']))
+
+ def test_get_view_names_plain_string(self):
+ insp = inspect(testing.db)
+ eq_(set(insp.get_view_names(include='plain')), set(['test_regview']))
+
+ def test_get_view_names_materialized(self):
+ insp = inspect(testing.db)
+ eq_(
+ set(insp.get_view_names(include=('materialized',))),
+ set(['test_mview']))
+
+ def test_get_view_names_empty(self):
+ insp = inspect(testing.db)
+ assert_raises(ValueError, insp.get_view_names, include=())
def test_get_view_definition(self):
insp = inspect(testing.db)