def query_recent_by_cat(user_id, cat_id, num):
return TabUsage.select().where(
(TabUsage.tag_id == cat_id) &
(TabUsage.user_id == user_id)
).order_by(
TabUsage.timestamp.desc()
).limit(num)
def query_by_post(postid):
'''
Query records by post.
'''
return TabUsage.select().where(
TabUsage.post_id == postid
)
def query_most(user_id, kind, num):
return TabUsage.select(
TabUsage, TabPost.title.alias('post_title')).join(
TabPost, on=(TabUsage.post_id == TabPost.uid
)).where((TabUsage.user_id == user_id)
& (TabUsage.kind == kind)).order_by(
TabUsage.count.desc()).limit(num)
def query_recent(user_id, kind, num=10):
return TabUsage.select(
TabUsage, TabPost.title.alias('post_title')).join(
TabPost, on=(TabUsage.post_id == TabPost.uid
)).where((TabUsage.user_id == user_id)
& (TabUsage.kind == kind)
& (TabPost.valid == 1)).order_by(
TabUsage.timestamp.desc()).limit(num)
def query_by_signature(user_id, sig):
return TabUsage.select().where(
(TabUsage.post_id == sig) &
(TabUsage.user_id == user_id)
)
def query_random(limit=6):
return TabUsage.select().order_by(peewee.fn.Random()).limit(limit)
def get_all():
return TabUsage.select().order_by('count')
