def test__approx_percentile(self):
q = Q.from_("abc").select(fn.ApproximatePercentile(F("foo"), 0.5))
self.assertEqual(
'SELECT APPROXIMATE_PERCENTILE("foo" USING PARAMETERS percentile=0.5) FROM "abc"',
str(q),
)
def test__approx_percentile(self):
q = Q.from_('abc').select(fn.ApproximatePercentile(F('foo'), 0.5))
self.assertEqual(
'SELECT APPROXIMATE_PERCENTILE(\"foo\" USING PARAMETERS percentile=0.5) FROM \"abc\"',
str(q))