"""
Try to use iterable but non-list or int params in query parameters.
"""
- cr = registry().cursor()
- try:
+ with registry().cursor() as cr:
with self.assertRaises(ValueError):
cr.execute("SELECT id FROM res_users WHERE login=%s", 'admin')
with self.assertRaises(ValueError):
cr.execute("SELECT id FROM res_users WHERE id=%s", 1)
with self.assertRaises(ValueError):
cr.execute("SELECT id FROM res_users WHERE id=%s", '1')
- finally:
- cr.close()
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: