def create_post_history(raw_data): uid = tools.get_uuid() TabPostHist.create( uid=uid, title=raw_data.title, post_id=raw_data.uid, user_name=raw_data.user_name, cnt_md=raw_data.cnt_md, time_update=tools.timestamp(), logo=raw_data.logo, ) return True
def create_post_history(raw_data, user_info): ''' Create the history of certain post. ''' uid = tools.get_uuid() TabPostHist.create( uid=uid, title=raw_data.title, post_id=raw_data.uid, user_name=user_info.user_name, cnt_md=raw_data.cnt_md, time_update=tools.timestamp(), logo=raw_data.logo, ) return True
def delete(uid): ''' Delete by uid :param uid: :return: ''' q_u1 = TabPostHist.delete().where(TabPostHist.post_id == uid) q_u1.execute() q_u2 = TabRel.delete().where(TabRel.post_f_id == uid or TabRel.post_t_id == uid) q_u2.execute() q_u3 = TabCollect.delete().where(TabCollect.post_id == uid) q_u3.execute() q_u4 = TabPost2Tag.delete().where(TabPost2Tag.post_id == uid) q_u4.execute() q_u5 = TabUsage.delete().where(TabUsage.post_id == uid) q_u5.execute() reply_arr = [] for reply in TabUser2Reply.select().where( TabUser2Reply.reply_id == uid): reply_arr.append(reply.reply_id.uid) q_u6 = TabUser2Reply.delete().where(TabUser2Reply.reply_id == uid) q_u6.execute() for replyid in reply_arr: TabReply.delete().where(TabReply.uid == replyid).execute() q_u7 = TabEvaluation.delete().where(TabEvaluation.post_id == uid) q_u7.execute() q_u8 = TabRating.delete().where(TabRating.post_id == uid) q_u8.execute() return MHelper.delete(TabPost, uid)
def update_cnt(uid, post_data): entry = TabPostHist.update( user_name=post_data['user_name'], cnt_md=tornado.escape.xhtml_escape(post_data['cnt_md']), time_update=tools.timestamp(), ).where(TabPostHist.uid == uid) entry.execute()
def query_by_postid(postid, limit=5): recs = TabPostHist.select().where( TabPostHist.post_id == postid ).order_by( TabPostHist.time_update.desc() ).limit(limit) return recs
def query_by_postid(postid, limit=5): ''' Query history of certian records. ''' recs = TabPostHist.select().where( TabPostHist.post_id == postid).order_by( TabPostHist.time_update.desc()).limit(limit) return recs
def get_last(postid, limit=10): recs = TabPostHist.select().where( TabPostHist.post_id == postid ).order_by(TabPostHist.time_update.desc()).limit(limit) if recs.count() == 0: return None else: return recs.get()
def get_last(postid, limit=10): ''' Get the last one of the records. ''' recs = TabPostHist.select().where( TabPostHist.post_id == postid).order_by( TabPostHist.time_update.desc()).limit(limit) if recs.count(): return recs.get() return None
def delete(uid): ''' Delete by uid ''' del_count = TabPostHist.delete().where(TabPostHist.uid == uid) try: del_count.execute() return False except: return True
def delete(uid): ''' Delete by uid ''' del_count = TabPostHist.delete().where(TabPostHist.uid == uid) try: del_count.execute() return False except Exception as err: print(repr(err)) return True