本文整理汇总了Python中query.Query.limit方法的典型用法代码示例。如果您正苦于以下问题：Python Query.limit方法的具体用法？Python Query.limit怎么用？Python Query.limit使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类query.Query的用法示例。
在下文中一共展示了Query.limit方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: _get
# 需要导入模块: from query import Query [as 别名]
# 或者: from query.Query import limit [as 别名]
def _get(cls, id=None, **kwargs):
if id is None:
if not kwargs:
return
else:
kwargs = {
'id': id
}
q = Query(model=cls, conditions=kwargs)
q.limit = (0, 1)
q = q._execute()
q = q.fetchone()
if q:
obj = cls(*q)
obj.__dict__['_is_new'] = False
return obj示例2: test_select
# 需要导入模块: from query import Query [as 别名]
# 或者: from query.Query import limit [as 别名]
def test_select():
query = Query('peers').select()
assert query.execute().strip() == "SELECT * FROM peers"
query = Query('users').select().compare('first_name', 'jane').compare('last_name', 'smith', '=')
assert query.execute().strip() == "SELECT * FROM users WHERE first_name = 'jane' AND last_name = 'smith'"
query = Query('clicks', 'excelsior').select().ttl('name').compare('url', 'http://apache.org')
assert query.execute().strip() == "SELECT TTL (name) FROM excelsior.clicks WHERE url = 'http://apache.org'"
query = Query('clicks', 'excelsior').select().writetime('name').compare('url', 'http://apache.org')
assert query.execute().strip() == "SELECT WRITETIME (name) FROM excelsior.clicks WHERE url = 'http://apache.org'"
query = Query('clicks', 'excelsior').select().writetime('date').compare('url', 'http://google.org')
assert query.execute().strip() == "SELECT WRITETIME (date) FROM excelsior.clicks WHERE url = 'http://google.org'"
query = Query('users').select().compare('gender', 'f').compare('state', 'TX').compare('birth_year', 1968, '>')
query.allowFiltering()
assert query.execute().strip() == "SELECT * FROM users WHERE gender = 'f' AND state = 'TX' AND birth_year > 1968 " \
"ALLOW FILTERING"
query = Query('test').select().compareToken('k', 42, '>')
assert query.execute().strip() == "SELECT * FROM test WHERE TOKEN (k) > TOKEN (42)"
query = Query('myTable').select().compare('t', "maxTimeuuid('2013-01-01 00:05+0000')", '>', True)
query.compare('t', "minTimeuuid('2013-02-02 10:00+0000')", '<', True)
assert query.execute().strip() == "SELECT * FROM myTable WHERE t > maxTimeuuid('2013-01-01 00:05+0000') " \
"AND t < minTimeuuid('2013-02-02 10:00+0000')"
query = Query('People').select('Name', 'Occupation').compare('empID', (199, 200, 207), 'IN')
assert query.execute().strip() == "SELECT Name, Occupation FROM People WHERE empID IN (199, 200, 207)"
query = Query('users').select('COUNT(*)')
assert query.execute().strip() == "SELECT COUNT(*) FROM users"
query = Query('users').select().count()
assert query.execute().strip() == "SELECT COUNT(*) FROM users"
query = Query('big_table').select().count().limit(50000)
assert query.execute().strip() == "SELECT COUNT(*) FROM big_table LIMIT 50000"
query = Query('Migrations', 'system').select().count()
assert query.execute().strip() == "SELECT COUNT(*) FROM system.Migrations"
query = Query('ruling_stewards').select().compare('king', 'Brego', '=').compare('reign_start', 2450, '>=')
query.compare('reign_start', 2500, '<').allowFiltering()
assert query.execute().strip() == "SELECT * FROM ruling_stewards WHERE king = 'Brego' AND reign_start >= 2450 " \
"AND reign_start < 2500 ALLOW FILTERING"
query = Query('ruling_stewards').select().compare('king', 'none').compare('reign_start', 1500, '>=')
query.compare('reign_start', 3000, '<').allowFiltering().limit(10)
assert query.execute().strip() == "SELECT * FROM ruling_stewards WHERE king = 'none' AND reign_start >= 1500 " \
"AND reign_start < 3000 LIMIT 10 ALLOW FILTERING"
query = Query('periods').select().compareToken('period_name', 'Third Age', '>')
query.compareToken('period_name', 'Fourth Age', '<')
assert query.execute().strip() == "SELECT * FROM periods WHERE TOKEN (period_name) > TOKEN ('Third Age') " \
"AND TOKEN (period_name) < TOKEN ('Fourth Age')"
query = Query('playlists').select().compare('id__uuid', '62c36092-82a1-3a00-93d1-46196ee77204')
query.limit(50).orderBy('song_order', 'desc')
assert query.execute().strip() == "SELECT * FROM playlists WHERE id__uuid = 62c36092-82a1-3a00-93d1-46196ee77204 " \
"ORDER BY song_order DESC LIMIT 50"
query = Query('playlists').select('title').compare( 'artist', 'Fu Manchu')
assert query.execute().strip() == "SELECT title FROM playlists WHERE artist = 'Fu Manchu'"
query = Query('People').select()
assert query.execute().strip() == "SELECT * FROM People"
"""