Author: cito
Date: Sat Jan 5 10:34:40 2013
New Revision: 489
Log:
Add test for boolean parameters.
Modified:
trunk/module/test_pg.py
Modified: trunk/module/test_pg.py
==============================================================================
--- trunk/module/test_pg.py Sat Jan 5 10:24:15 2013 (r488)
+++ trunk/module/test_pg.py Sat Jan 5 10:34:40 2013 (r489)
@@ -716,6 +716,27 @@
self.assertEqual(self.c.query("select $1::text", [None]
).getresult(), [(None,)])
+ def testQueryWithBoolParams(self):
+ query = self.c.query
+ self.assertEqual(query("select false").getresult(), [('f',)])
+ self.assertEqual(query("select true").getresult(), [('t',)])
+ self.assertEqual(query("select $1::bool", (None,)).getresult(),
+ [(None,)])
+ self.assertEqual(query("select $1::bool", ('f',)).getresult(),
[('f',)])
+ self.assertEqual(query("select $1::bool", ('t',)).getresult(),
[('t',)])
+ self.assertEqual(query("select $1::bool", ('false',)).getresult(),
+ [('f',)])
+ self.assertEqual(query("select $1::bool", ('true',)).getresult(),
+ [('t',)])
+ self.assertEqual(query("select $1::bool", ('n',)).getresult(),
[('f',)])
+ self.assertEqual(query("select $1::bool", ('y',)).getresult(),
[('t',)])
+ self.assertEqual(query("select $1::bool", (0,)).getresult(), [('f',)])
+ self.assertEqual(query("select $1::bool", (1,)).getresult(), [('t',)])
+ self.assertEqual(query("select $1::bool", (False,)).getresult(),
+ [('f',)])
+ self.assertEqual(query("select $1::bool", (True,)).getresult(),
+ [('t',)])
+
def testQueryWithIntParams(self):
query = self.c.query
self.assertEqual(query("select 1+1").getresult(), [(2,)])
_______________________________________________
PyGreSQL mailing list
[email protected]
https://mail.vex.net/mailman/listinfo.cgi/pygresql
