def test__complex_op_floor_parentheses(self):
q1 = Q.from_("abc").select(F("a") / (fn.Floor(F("b")) / 2))
q2 = Q.from_("abc").select(self.t.a / (fn.Floor(self.t.b) / 2))
q3 = Q.from_("abc").select(fn.Floor(F("a") / (F("b") / 2)))
q4 = Q.from_("abc").select(fn.Floor(self.t.a / (self.t.b / 2)))
self.assertEqual('SELECT "a"/(FLOOR("b")/2) FROM "abc"', str(q1))
self.assertEqual('SELECT "a"/(FLOOR("b")/2) FROM "abc"', str(q2))
self.assertEqual('SELECT FLOOR("a"/("b"/2)) FROM "abc"', str(q3))
self.assertEqual('SELECT FLOOR("a"/("b"/2)) FROM "abc"', str(q4))
def test__floor(self):
q1 = Q.from_('abc').select(fn.Floor(F('foo')))
q2 = Q.from_(self.t).select(fn.Floor(self.t.foo))
self.assertEqual('SELECT FLOOR(\"foo\") FROM \"abc\"', str(q1))
self.assertEqual('SELECT FLOOR(\"foo\") FROM \"abc\"', str(q2))
def test__floor(self):
q1 = Q.from_("abc").select(fn.Floor(F("foo")))
q2 = Q.from_(self.t).select(fn.Floor(self.t.foo))
self.assertEqual('SELECT FLOOR("foo") FROM "abc"', str(q1))
self.assertEqual('SELECT FLOOR("foo") FROM "abc"', str(q2))
