summaryrefslogtreecommitdiff
path: root/tests/test_sql.py
diff options
context:
space:
mode:
authorDaniele Varrazzo <daniele.varrazzo@gmail.com>2017-01-01 06:26:54 +0100
committerDaniele Varrazzo <daniele.varrazzo@gmail.com>2017-01-01 06:26:54 +0100
commitad2643266fc3868b30cdff4ba70ad606f555d00d (patch)
treed06c38572f95ffb9255307bc7a9ba03970ea22c6 /tests/test_sql.py
parent8c020ca47a50fb021f3af6a0813687ed9daa85d2 (diff)
downloadpsycopg2-ad2643266fc3868b30cdff4ba70ad606f555d00d.tar.gz
Fixed sql.compose with no args and added tests
Diffstat (limited to 'tests/test_sql.py')
-rwxr-xr-xtests/test_sql.py15
1 files changed, 15 insertions, 0 deletions
diff --git a/tests/test_sql.py b/tests/test_sql.py
index c8ec716..f7c0801 100755
--- a/tests/test_sql.py
+++ b/tests/test_sql.py
@@ -55,6 +55,21 @@ class ComposeTests(ConnectingTestCase):
s1 = s.as_string(self.conn)
self.assertEqual(s1, "select '2016-12-31'::date;")
+ def test_compose_empty(self):
+ s = sql.compose("select foo;")
+ s1 = s.as_string(self.conn)
+ self.assertEqual(s1, "select foo;")
+
+ def test_compose_badnargs(self):
+ self.assertRaises(ValueError, sql.compose, "select foo;", [10])
+ self.assertRaises(ValueError, sql.compose, "select %s;")
+ self.assertRaises(ValueError, sql.compose, "select %s;", [])
+ self.assertRaises(ValueError, sql.compose, "select %s;", [10, 20])
+
+ def test_compose_bad_args_type(self):
+ self.assertRaises(TypeError, sql.compose, "select %s;", {'a': 10})
+ self.assertRaises(TypeError, sql.compose, "select %(x)s;", [10])
+
def test_must_be_adaptable(self):
class Foo(object):
pass