def test_or_clause(self):
where = Where(MockColumn(column_name='col1'), Where.EQUAL,
'value').OR(MockColumn(column_name='col2'),
Where.LESS_THAN, 1)
expected = "((table.col1 = 'value') OR (table.col2 < 1))"
self.assertEqual(expected, where.build())
def test_value_str(self):
where = Where(MockColumn(), Where.EQUAL, 'value')
expected = "table.column = 'value'"
self.assertEqual(expected, where.build())
def test_value_num(self):
where = Where(MockColumn(), Where.EQUAL, 1)
expected = "table.column = 1"
self.assertEqual(expected, where.build())
def test_in(self):
where = Where(MockColumn(), Where.IN, [1, 2, 3])
expected = "table.column IN (1, 2, 3)"
self.assertEqual(expected, where.build())
def test_lt(self):
where = Where(MockColumn(), Where.LT, 'value')
expected = "table.column < 'value'"
self.assertEqual(expected, where.build())
def test_less_than(self):
where = Where(MockColumn(), Where.LESS_THAN, 'value')
expected = "table.column < 'value'"
self.assertEqual(expected, where.build())
def test_greater_than(self):
where = Where(MockColumn(), Where.GREATER_THAN, 'value')
expected = "table.column > 'value'"
self.assertEqual(expected, where.build())
def test_not_equal(self):
where = Where(MockColumn(), Where.NOT_EQUAL, 'value')
expected = "table.column <> 'value'"
self.assertEqual(expected, where.build())
