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 get_by_wiki(self, citiao):
q_res = CabWiki.select().where(CabWiki.title == citiao)
tt = q_res.count()
if tt == 0 or tt > 1:
return None
else:
self.update_view_count(citiao)
return q_res.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 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 update_view_count_by_uid(self, uid):
entry = CabWiki.update(view_count=CabWiki.view_count + 1).where(CabWiki.uid == uid)
entry.execute()
def update_view_count(self, citiao):
entry = CabWiki.update(view_count=CabWiki.view_count + 1).where(CabWiki.title == citiao)
entry.execute()
def query_most(self, num=8):
return CabWiki.select().order_by(CabWiki.view_count.desc()).limit(num)
def query_dated(self, num = 10):
return CabWiki.select().order_by(CabWiki.time_update.desc()).limit(num)
def get_by_title(self, in_title):
try:
return CabWiki.get(CabWiki.title == in_title)
except:
return None
def __init__(self):
self.tab = CabWiki
try:
CabWiki.create_table()
except:
pass