summaryrefslogtreecommitdiffstats
path: root/tests/test_sqlcompletion.py
diff options
context:
space:
mode:
authorDarik Gamble <darik.gamble.spam@gmail.com>2015-11-23 16:48:27 -0500
committerDarik Gamble <darik.gamble.spam@gmail.com>2015-11-23 16:48:27 -0500
commit2c4f4e689dec10983999e4c0d6708951ccbec159 (patch)
treef6009bcf78eba52b44479851a3730daae149b497 /tests/test_sqlcompletion.py
parent8e9cdce6fd26a5862dc2da67bb4e18007e981535 (diff)
Add more tests for qualified table names with or without quotes
Diffstat (limited to 'tests/test_sqlcompletion.py')
-rw-r--r--tests/test_sqlcompletion.py5
1 files changed, 5 insertions, 0 deletions
diff --git a/tests/test_sqlcompletion.py b/tests/test_sqlcompletion.py
index ff1e059d..c58e2472 100644
--- a/tests/test_sqlcompletion.py
+++ b/tests/test_sqlcompletion.py
@@ -24,6 +24,7 @@ def test_select_suggests_cols_with_qualified_table_scope():
@pytest.mark.parametrize('expression', [
'SELECT * FROM tabl WHERE ',
+ 'SELECT * FROM "tabl" WHERE ',
'SELECT * FROM tabl WHERE (',
'SELECT * FROM tabl WHERE foo = ',
'SELECT * FROM tabl WHERE bar OR ',
@@ -126,6 +127,10 @@ def test_suggest_qualified_tables_and_views(expression):
@pytest.mark.parametrize('expression', [
'SELECT * FROM sch.',
+ 'SELECT * FROM sch."',
+ 'SELECT * FROM sch."foo',
+ 'SELECT * FROM "sch".',
+ 'SELECT * FROM "sch"."',
'SELECT * FROM foo JOIN sch.',
])
def test_suggest_qualified_tables_views_and_set_returning_functions(expression):