def get_by_wiki(self, citiao): tt = CabWiki.select().where(CabWiki.title == citiao).count() if tt == 0: return None else: self.update_view_count(citiao) return CabWiki.get(CabWiki.title == citiao)
def insert_data(self, post_data): title = post_data['title'][0] uu = self.get_by_wiki(title) if uu is None: pass else: return (False) if 'id_spec' in post_data: id_spec = post_data['id_spec'][0] else: id_spec = 0 if post_data['src_type'][0] == '1': cnt_html = tools.rst2html(post_data['cnt_md'][0]) else: cnt_html = tools.markdown2html(post_data['cnt_md'][0]) entry = CabWiki.create(title=post_data['title'][0], date=datetime.datetime.now(), cnt_html=cnt_html, uid=tools.get_uu8d(), time_create=time.time(), user_name=post_data['user_name'], cnt_md=tornado.escape.xhtml_escape( post_data['cnt_md'][0]), time_update=time.time(), view_count=1, src_type=post_data['src_type'][0]) return (entry.uid)
def insert_data(self, post_data): title = post_data['title'][0] uu = self.get_by_wiki(title) if uu is None: pass else: return (False) if 'id_spec' in post_data: id_spec = post_data['id_spec'][0] else: id_spec = 0 if post_data['src_type'][0] == '1': cnt_html = tools.rst2html(post_data['cnt_md'][0]) else: cnt_html = tools.markdown2html(post_data['cnt_md'][0]) entry = CabWiki.create( title=post_data['title'][0], date=datetime.datetime.now(), cnt_html=cnt_html, uid=tools.get_uu8d(), time_create=time.time(), user_name=post_data['user_name'], cnt_md=tornado.escape.xhtml_escape(post_data['cnt_md'][0]), time_update=time.time(), view_count=1, src_type=post_data['src_type'][0] ) return (entry.uid)
def get_previous_record(self, in_uid): current_rec = self.get_by_id(in_uid) query = CabWiki.select().where(CabWiki.time_update > current_rec.time_update).order_by(CabWiki.time_update) if query.count() == 0: return None else: return query.get()
def insert_data(self, post_data): title = post_data["title"][0] uu = self.get_by_wiki(title) if uu is None: pass else: return False if post_data["src_type"][0] == "1": cnt_html = tools.rst2html(post_data["cnt_md"][0]) else: cnt_html = tools.markdown2html(post_data["cnt_md"][0]) entry = CabWiki.create( title=post_data["title"][0], date=datetime.datetime.now(), cnt_html=cnt_html, uid=tools.get_uu8d(), time_create=tools.timestamp(), user_name=post_data["user_name"], cnt_md=tornado.escape.xhtml_escape(post_data["cnt_md"][0]), time_update=tools.timestamp(), view_count=1, src_type=post_data["src_type"][0], ) return entry.uid
def query_cat_by_pager(self, cat_str, cureent): tt = ( CabWiki.select() .where(CabWiki.id_cats.contains(str(cat_str))) .order_by(CabWiki.time_update.desc()) .paginate(cureent, config.page_num) ) return tt
def get_next_record(self, in_uid): current_rec = self.get_by_id(in_uid) query = ( CabWiki.select().where(CabWiki.time_update < current_rec.time_update).order_by(CabWiki.time_update.desc()) ) if query.count() == 0: return None else: return query.get()
def get_previous_record(self, in_uid): current_rec = self.get_by_id(in_uid) query = CabWiki.select().where( CabWiki.time_update > current_rec.time_update).order_by( CabWiki.time_update) if query.count() == 0: return None else: return query.get()
def update(self, uid, post_data): cnt_html = tools.markdown2html(post_data['cnt_md'][0]) entry = CabWiki.update( title=post_data['title'][0], date=datetime.datetime.now(), cnt_html=cnt_html, user_name=post_data['user_name'], cnt_md=tornado.escape.xhtml_escape(post_data['cnt_md'][0]), time_update=tools.timestamp(), ).where(CabWiki.uid == uid) entry.execute()
def update(self, uid, post_data): print(post_data["src_type"][0]) if post_data["src_type"][0] == "1": cnt_html = tools.rst2html(post_data["cnt_md"][0]) else: cnt_html = tools.markdown2html(post_data["cnt_md"][0]) entry = CabWiki.update( title=post_data["title"][0], date=datetime.datetime.now(), cnt_html=cnt_html, user_name=post_data["user_name"], cnt_md=tornado.escape.xhtml_escape(post_data["cnt_md"][0]), time_update=tools.timestamp(), src_type=post_data["src_type"][0], ).where(CabWiki.uid == uid) entry.execute()
def update(self, uid, post_data): print(post_data['src_type'][0]) if post_data['src_type'][0] == '1': cnt_html = tools.rst2html(post_data['cnt_md'][0]) else: cnt_html = tools.markdown2html(post_data['cnt_md'][0]) entry = CabWiki.update( title=post_data['title'][0], date=datetime.datetime.now(), cnt_html=cnt_html, user_name=post_data['user_name'], cnt_md=tornado.escape.xhtml_escape(post_data['cnt_md'][0]), time_update=time.time(), src_type=post_data['src_type'][0] ).where(CabWiki.uid == uid) entry.execute()
def update(self, uid, post_data): print(post_data['src_type'][0]) if post_data['src_type'][0] == '1': cnt_html = tools.rst2html(post_data['cnt_md'][0]) else: cnt_html = tools.markdown2html(post_data['cnt_md'][0]) entry = CabWiki.update( title=post_data['title'][0], date=datetime.datetime.now(), cnt_html=cnt_html, user_name=post_data['user_name'], cnt_md=tornado.escape.xhtml_escape(post_data['cnt_md'][0]), time_update=time.time(), # id_spec=id_spec, # logo=post_data['logo'][0], src_type=post_data['src_type'][0]).where(CabWiki.uid == uid) entry.execute()
def insert_data(self, post_data): title = post_data['title'][0] uu = self.get_by_wiki(title) if uu is None: pass else: return (False) cnt_html = tools.markdown2html(post_data['cnt_md'][0]) entry = CabWiki.create( title=post_data['title'][0], date=datetime.datetime.now(), cnt_html=cnt_html, uid=tools.get_uu8d(), time_create=tools.timestamp(), user_name=post_data['user_name'], cnt_md=tornado.escape.xhtml_escape(post_data['cnt_md'][0]), time_update=tools.timestamp(), view_count=1, ) return (entry.uid)
def get_by_title(self, in_title): try: return CabWiki.get(CabWiki.title == in_title) except: return None
def get_num_by_cat(self, cat_str): return CabWiki.select().where( CabWiki.id_cats.contains(',{0},'.format(cat_str))).count()
def query_most(self, num=8): return CabWiki.select().order_by(CabWiki.view_count.desc()).limit(num)
def get_by_id(self, in_uid): tt = CabWiki.select().where(CabWiki.uid == in_uid).count() if tt == 0: return None else: return CabWiki.get(CabWiki.uid == in_uid)
def get_num_by_cat(self, cat_str): return CabWiki.select().where(CabWiki.id_cats.contains(',{0},'.format(cat_str))).count()
def query_dated(self, num = 10): return CabWiki.select().order_by(CabWiki.time_update.desc()).limit(num)
def update_view_count(self, citiao): entry = CabWiki.update(view_count=CabWiki.view_count + 1).where(CabWiki.title == citiao) entry.execute()
def query_recent_most(self, num=8, recent=30): time_that = int(time.time()) - 30 * 24 * 3600 return CabWiki.select().where( CabWiki.time_update > time_that).order_by( CabWiki.view_count.desc()).limit(num)
def query_random(self, num=6): if config.dbtype == 1 or config.dbtype == 3: return CabWiki.select().order_by(peewee.fn.Random()).limit(num) elif config.dbtype == 2: return CabWiki.select().order_by(peewee.fn.Rand()).limit(num)
def query_recent(self, num=8): return CabWiki.select().order_by(CabWiki.time_update.desc()).limit(num)
def update_view_count_by_uid(self, uid): entry = CabWiki.update(view_count=CabWiki.view_count + 1).where(CabWiki.uid == uid) entry.execute()
def query_recent_most(self, num=8, recent=30): time_that = int(time.time()) - 30 * 24 * 3600 return CabWiki.select().where(CabWiki.time_update > time_that).order_by(CabWiki.view_count.desc()).limit(num)
def __init__(self): try: CabWiki.create_table() except: pass
def query_cat_by_pager(self, cat_str, cureent): tt = CabWiki.select().where(CabWiki.id_cats.contains( str(cat_str))).order_by(CabWiki.time_update.desc()).paginate( cureent, config.page_num) return tt
def get_by_keyword(self, par2): return CabWiki.select().where(CabWiki.title.contains(par2)).order_by(CabWiki.time_update.desc()).limit(20)
def query_old(self): return CabWiki.select().order_by('time_update').limit(10)
def query_dated(self, num=8): return CabWiki.select().order_by(CabWiki.time_update).limit(num)
def query_by_spec(self, spec_id): tt = CabWiki.select().where(CabWiki.id_spec == spec_id).order_by( CabWiki.time_update.desc()) return tt
def query_by_spec(self, spec_id): tt = CabWiki.select().where(CabWiki.id_spec == spec_id).order_by(CabWiki.time_update.desc()) return tt
def get_by_keyword(self, par2): return CabWiki.select().where(CabWiki.title.contains(par2)).order_by( CabWiki.time_update.desc()).limit(20)