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()