def test_unused(self):
cond = db.filters_to_condition(FakeModel, [], {'unused': True})
self.assertEqual('fake.pool IS NULL', str(cond))
cond = db.filters_to_condition(FakeModel, [], {'unused': 'True'})
self.assertEqual('fake.pool IS NULL', str(cond))
cond = db.filters_to_condition(FakeModel, [], {'unused': False})
self.assertEqual('fake.pool IS NOT NULL', str(cond))
cond = db.filters_to_condition(FakeModel, [], {'unused': 'False'})
self.assertEqual('fake.pool IS NOT NULL', str(cond))
def test_none(self):
cond = db.filters_to_condition(FakeModel, ['name'], {})
self.assertIsNone(cond)
def test_equal(self):
cond = db.filters_to_condition(FakeModel, ['name'], {'name': 'abc'})
self.assertEqual('fake.name = :name_1', str(cond))
def test_bool(self):
cond = db.filters_to_condition(FakeModel, ['enabled'],
{'enabled': True})
self.assertEqual('fake.enabled = :enabled_1', str(cond))
def test_in(self):
cond = db.filters_to_condition(FakeModel, ['group'], {'group': (1, 2)})
self.assertEqual('fake."group" IN (:group_1, :group_2)', str(cond))
