def query_pager_by_kind(kind, current_page_num=1):
'''
Query pager
'''
return TabWiki.select().where(TabWiki.kind == kind).order_by(
TabWiki.time_create.desc()).paginate(current_page_num,
CMS_CFG['list_num'])
def count_of_certain_kind(kind):
'''
Get the count of certain kind.
'''
recs = TabWiki.select().where(TabWiki.kind == kind)
return recs.count()
def query_all(**kwargs):
'''
Qeury recent wiki.
'''
kind = kwargs.get('kind', '1')
limit = kwargs.get('limit', 50)
return TabWiki.select().where(TabWiki.kind == kind).limit(limit)
def query_random(num=6, kind='1'):
'''
Query wikis randomly.
'''
return TabWiki.select().where(
TabWiki.kind == kind
).order_by(
peewee.fn.Random()
).limit(num)
def query_most(num=8, kind='1'):
'''
List the most viewed wiki.
'''
return TabWiki.select().where(
TabWiki.kind == kind
).order_by(
TabWiki.view_count.desc()
).limit(num)
def query_dated(num=10, kind='1'):
'''
List the wiki of dated.
'''
return TabWiki.select().where(
TabWiki.kind == kind
).order_by(
TabWiki.time_update.desc()
).limit(num)
def query_all(**kwargs):
if 'kind' in kwargs:
kind = kwargs['kind']
else:
kind = '1'
if 'limit' in kwargs:
limit = kwargs['limit']
else:
limit = 999999
return TabWiki.select().where(TabWiki.kind == kind).limit(limit)
def get_by_wiki(citiao):
'''
Get the wiki record by title.
'''
q_res = TabWiki.select().where(TabWiki.title == citiao)
the_count = q_res.count()
if the_count == 0 or the_count > 1:
return None
else:
MWiki.update_view_count(citiao)
return q_res.get()
def query_recent_edited(timstamp, kind='1'):
return TabWiki.select().where((TabWiki.kind == kind) & (
TabWiki.time_update > timstamp)).order_by(
TabWiki.time_update.desc())
def total_number(kind):
'''
Return the number of certian slug.
'''
return TabWiki.select().where(TabWiki.kind == kind).count()
def query_recent(num=8, kind='1'):
return TabWiki.select().where(TabWiki.kind == kind).order_by(
TabWiki.time_update.desc()).limit(num)
def get_counts():
'''
The count in table.
'''
# adding ``None`` to hide ``No value for argument 'database' in method call``
return TabWiki.select().count(None)
def get_counts():
'''
The count in table.
'''
return TabWiki.select().count()
