Пример #1
0
 def test_having(self):
     Dummy.create(name='foo0', age=1)
     Dummy.create(name='foo2', age=2)
     Dummy.create(name='foo2', age=2)
     Dummy.create(name='foo3', age=3)
     Dummy.create(name='foo4', age=3)
     Dummy.create(name='foo5', age=3)
     c = COUNT(1).alias('c')
     rv = Dummy.cq('age', c).group_by('age').having(c > 2).all()
     self.assertEqual(rv, [(3, 3)])
Пример #2
0
 def count(self):
     from olo.funcs import COUNT
     return COUNT(self).first()  # pylint: disable=E1101