def test_mod(self):
for mod in [
Mod(self.table.c1, self.table.c2),
self.table.c1 % self.table.c2
]:
self.assertEqual(str(mod), '("c1" % "c2")')
self.assertEqual(mod.params, ())
def test_mod_paramstyle(self):
flavor = Flavor(paramstyle='format')
Flavor.set(flavor)
try:
mod = Mod(self.table.c1, self.table.c2)
self.assertEqual(str(mod), '("c1" %% "c2")')
self.assertEqual(mod.params, ())
finally:
Flavor.set(Flavor())
flavor = Flavor(paramstyle='qmark')
Flavor.set(flavor)
try:
mod = Mod(self.table.c1, self.table.c2)
self.assertEqual(str(mod), '("c1" % "c2")')
self.assertEqual(mod.params, ())
finally:
Flavor.set(Flavor())
def __mod__(self, other):
from sql.operators import Mod
return Mod(self, other)