本文整理汇总了Python中querybuilder.query.Query.count方法的典型用法代码示例。如果您正苦于以下问题：Python Query.count方法的具体用法？Python Query.count怎么用？Python Query.count使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类querybuilder.query.Query的用法示例。
在下文中一共展示了Query.count方法的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: test_count
# 需要导入模块: from querybuilder.query import Query [as 别名]
# 或者: from querybuilder.query.Query import count [as 别名]
def test_count(self):
query = Query().from_table(
User
)
received = query.count()
expected = len(User.objects.all())
self.assertEqual(
received,
expected,
'Expected {0} but received {1}'.format(
expected,
received
)
)示例2: freeTable
# 需要导入模块: from querybuilder.query import Query [as 别名]
# 或者: from querybuilder.query.Query import count [as 别名]
def freeTable(tableid) :
# Get all client tokens associated to the table (id) and count them
query = Query().from_table('client').where(tableid_id=tableid)
# SELECT * FROM client WEHRE tableid_id = tableid
client = query.select()
clientCount = query.count()
# Count when a payment has been done with the client token
paymentCount = 0
for token in client :
query = Query().from_table('payment').where(token_id=token['id'])
payment = query.select()
if payment:
paymentCount = paymentCount + 1
return clientCount == paymentCount示例3: test_count
# 需要导入模块: from querybuilder.query import Query [as 别名]
# 或者: from querybuilder.query.Query import count [as 别名]
def test_count(self):
query = Query().from_table(
User,
['one', 'two']
).order_by('id')
received = query.count()
expected = len(User.objects.all())
self.assertEqual(
received,
expected,
'Expected {0} but received {1}'.format(
expected,
received
)
)
self.assertEqual(query.get_count_query().get_sql(), 'SELECT COUNT(tests_user.*) AS all_count FROM tests_user')
# Make sure the copy didn't modify the original
self.assertEqual(len(query.tables[0].fields), 2)
self.assertEqual(len(query.sorters), 1)