def test_or_exprs(self): self.assertRaises(ValueError, sql_builder.OrExprs, 7) self._check_build_where_sql( sql_builder.OrExprs(sql_builder.Between(11, 20), 30), '((col_a BETWEEN %(col_a_3)s AND %(col_a_4)s) OR ' '(col_a = %(col_a_5)s))', dict(col_a_3=11, col_a_4=20, col_a_5=30))
def test_between(self): self._check_build_where_sql( sql_builder.Between(11, 20), 'col_a BETWEEN %(col_a_3)s AND %(col_a_4)s', dict(col_a_3=11, col_a_4=20))