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))