def test_not_ilike(self):
flavor = Flavor(ilike=True)
Flavor.set(flavor)
try:
for like in [NotILike(self.table.c1, 'foo'),
~self.table.c1.ilike('foo')]:
self.assertEqual(str(like), '("c1" NOT ILIKE %s)')
self.assertEqual(like.params, ('foo',))
finally:
Flavor.set(Flavor())
flavor = Flavor(ilike=False)
Flavor.set(flavor)
try:
like = NotILike(self.table.c1, 'foo')
self.assertEqual(str(like), '(UPPER("c1") NOT LIKE UPPER(%s))')
self.assertEqual(like.params, ('foo',))
finally:
Flavor.set(Flavor())
def test_ilike(self):
flavor = Flavor(ilike=True)
Flavor.set(flavor)
try:
for like in [
ILike(self.table.c1, 'foo'),
self.table.c1.ilike('foo'),
~NotILike(self.table.c1, 'foo')
]:
self.assertEqual(str(like), '("c1" ILIKE %s)')
self.assertEqual(like.params, ('foo', ))
finally:
Flavor.set(Flavor())
flavor = Flavor(ilike=False)
Flavor.set(flavor)
try:
like = ILike(self.table.c1, 'foo')
self.assertEqual(str(like), '("c1" LIKE %s)')
self.assertEqual(like.params, ('foo', ))
finally:
Flavor.set(Flavor())