def test_two_expr_columns(self):
col_a = sql_builder.Greater(1)
col_b = sql_builder.Less(2)
sql, bind_vars = sql_builder.build_where_clause(
column_value_pairs=[('col_a', col_a), ('col_b', col_b)])
self.assertEqual(sql, 'col_a > %(col_a_1)s AND col_b < %(col_b_2)s')
self.assertEqual(bind_vars, dict(col_a_1=1, col_b_2=2))
def test_greater_than(self):
self._check_build_where_sql(
sql_builder.Greater(5),
'col_a > %(col_a_3)s', dict(col_a_3=5))