def get_essay_by_title(self, title=None): with session_scope() as session: if not title: essay_list = session.query(Essay) else: essay_list = session.query(Essay).filter(Essay.title.like("%{}%".format(title))) return [essay.to_dict(wanted_list=["id", "user_id", "title", "abstract", "content", "status"]) for essay in essay_list]
def get_impression_by_title_page(self, title=None, page_size=10, page_now=1): with session_scope() as session: if not title: impression_list = session.query(Impression).filter(Impression.is_delete == False).offset((page_now - 1) * page_size).limit(page_size) else: impression_list = session.query(Impression).filter(Impression.title.like("%{}%".format(title)), Impression.is_delete == False).offset((page_now - 1) * page_size).limit(page_size) return [impression.to_dict(wanted_list=["id", "user_id", "title", "abstract", "content", "status", "zan_times", "cover", "create_time"]) for impression in impression_list]
def get_all_essay(self, user_id=None): with session_scope() as session: if not user_id: essay_list = session.query(Essay) else: essay_list = session.query(Essay).filter(Essay.user_id == user_id) return [essay.to_dict(wanted_list=["id", "user_id", "title", "abstract", "content", "status"]) for essay in essay_list]
def get_capriccio_by_title_page(self, title=None, page_size=10, page_now=1): with session_scope() as session: if not title: capriccio_list = session.query(Capriccio).filter(Capriccio.is_delete == False).offset((page_now - 1) * page_size).limit(page_size) else: capriccio_list = session.query(Capriccio).filter(Capriccio.title.like("%{}%".format(title)), Capriccio.is_delete == False).offset((page_now - 1) * page_size).limit(page_size) return [capriccio.to_dict(wanted_list=["id", "user_id", "extract", "content", "status", "zan_times", "cover", "create_time"]) for capriccio in capriccio_list]
def get_address_by_title_page(self, link_name=None, page_size=10, page_now=1): with session_scope() as session: if not link_name: address_list = session.query(Address).filter(Address.is_delete == False).offset((page_now - 1) * page_size).limit(page_size) else: address_list = session.query(Address).filter(Address.link_name.like("%{}%".format(link_name)), Address.is_delete == False).offset((page_now - 1) * page_size).limit(page_size) return [address.to_dict(wanted_list=["id", "user_id", "link_name", "link_phone", "link_email", "link_address", "create_time"]) for address in address_list]
def update_essay(self, essay_id, title, abstract, content, status): with session_scope() as session: essay = session.query(Essay).filter(Essay.id == essay_id).first() essay.title = title essay.abstract = abstract essay.content = content essay.status = status session.add(essay)
def update_capriccio(self, capriccio_id, extract, content, status, cover): with session_scope() as session: capriccio = session.query(Capriccio).filter(Capriccio.id == capriccio_id).first() capriccio.extract = extract capriccio.content = content capriccio.status = status capriccio.cover = cover session.add(capriccio)
def update_address(self, address_id, link_name, link_phone, link_email, link_address): with session_scope() as session: address = session.query(Address).filter(Address.id == address_id).first() address.link_name = link_name address.link_phone = link_phone address.link_email = link_email address.link_address = link_address session.add(address)
def get_diary_by_id(self, diary_id): with session_scope() as session: diary = session.query(Diary).filter(Diary.id == diary_id).first() if not diary: return None return diary.to_dict(wanted_list=[ "id", "user_id", "week", "weather", "mood", "content", "status", "zan_times", "cover", "create_time" ])
def get_essay_by_id(self, essay_id): with session_scope() as session: essay = session.query(Essay).filter(Essay.id == essay_id).first() if not essay: return None return essay.to_dict(wanted_list=[ "id", "user_id", "title", "abstract", "content", "status", "zan_times", "cover", "create_time" ])
def get_all_address_by_page(self, user_id=None, page_size=10, page_now=1): with session_scope() as session: if not user_id: raise Exception("用户ID不能为空") elif not check_param_format(param_name=user_id, pattern_list=[r'^[1-9][0-9]*']): raise Exception("用户ID格式错误") else: address_list = session.query(Address).filter(Address.user_id == user_id, Address.is_delete == False).offset((page_now - 1) * page_size).limit(page_size) return [address.to_dict(wanted_list=["id", "user_id", "link_name", "link_phone", "link_email", "link_address", "create_time"]) for address in address_list]
def get_all_impression_by_page(self, user_id=None, page_size=10, page_now=1): with session_scope() as session: if not user_id: impression_list = session.query(Impression).filter(Impression.is_delete == False).offset((page_now - 1) * page_size).limit(page_size) elif not check_param_format(param_name=user_id, pattern_list=[r'^[1-9][0-9]*']): raise Exception("用户ID格式错误") else: impression_list = session.query(Impression).filter(Impression.user_id == user_id, Impression.is_delete == False).offset((page_now - 1) * page_size).limit(page_size) return [impression.to_dict(wanted_list=["id", "user_id", "title", "abstract", "content", "status", "zan_times", "cover", "create_time"]) for impression in impression_list]
def get_all_capriccio_by_page(self, user_id=None, page_size=10, page_now=1): with session_scope() as session: if not user_id: capriccio_list = session.query(Capriccio).filter(Capriccio.is_delete == False).offset((page_now - 1) * page_size).limit(page_size) elif not check_param_format(param_name=user_id, pattern_list=[r'^[1-9][0-9]*']): raise Exception("用户ID格式错误") else: capriccio_list = session.query(Capriccio).filter(Capriccio.user_id == user_id, Capriccio.is_delete == False).offset((page_now - 1) * page_size).limit(page_size) return [capriccio.to_dict(wanted_list=["id", "user_id", "extract", "content", "status", "zan_times", "cover", "create_time"]) for capriccio in capriccio_list]
def update_impression(self, impression_id, title, abstract, content, status, cover): with session_scope() as session: impression = session.query(Impression).filter(Impression.id == impression_id).first() impression.title = title impression.abstract = abstract impression.content = content impression.status = status impression.cover = cover session.add(impression)
def create_capriccio(self, user_id, extract, content, status, cover): capriccio = Capriccio({ "user_id": user_id, "extract": extract, "content": content, "status": status, "cover": cover, }) with session_scope() as session: session.add(capriccio)
def delete_essay(self, essay_id_list=None): if not essay_id_list: raise Exception("随笔id列表不能为None") if not isinstance(essay_id_list, list): raise Exception("随笔id参数不是一个列表") with session_scope() as session: essay_list = session.query(Essay).filter(Essay.id.in_(essay_id_list)) for essay in essay_list: essay.is_delete = True session.add(essay)
def create_address(self, user_id, link_name, link_phone, link_email, link_address): address = Address({ "user_id": user_id, "link_name": link_name, "link_phone": link_phone, "link_email": link_email, "link_address": link_address, }) with session_scope() as session: session.add(address)
def delete_address(self, address_id_list=None): if not address_id_list: raise Exception("联系人id列表不能为None") if not isinstance(address_id_list, list): raise Exception("联系人id参数不是一个列表") with session_scope() as session: address_list = session.query(Address).filter(Address.id.in_(address_id_list)) for address in address_list: address.is_delete = True session.add(address)
def delete_capriccio(self, capriccio_id_list=None): if not capriccio_id_list: raise Exception("随笔id列表不能为None") if not isinstance(capriccio_id_list, list): raise Exception("随笔id参数不是一个列表") with session_scope() as session: capriccio_list = session.query(Capriccio).filter(Capriccio.id.in_(capriccio_id_list)) for capriccio in capriccio_list: capriccio.is_delete = True session.add(capriccio)
def get_comment_by_id(self, comment_id): with session_scope() as session: comment = session.query(Comment).filter( Comment.id == comment_id).first() if not comment: return None return comment.to_dict(wanted_list=[ "id", "comment_con", "comment_id", "comment_user", "create_time" ])
def delete_impression(self, impression_id_list=None): if not impression_id_list: raise Exception("随笔id列表不能为None") if not isinstance(impression_id_list, list): raise Exception("随笔id参数不是一个列表") with session_scope() as session: impression_list = session.query(Impression).filter(Impression.id.in_(impression_id_list)) for impression in impression_list: impression.is_delete = True session.add(impression)
def create_essay(self, user_id, title, abstract, content, status): essay = Essay({ "user_id": user_id, "title": title, "abstract": abstract, "content": content, "status": status, }) with session_scope() as session: session.add(essay)
def create_impression(self, user_id, title, abstract, content, status, cover): impression = Impression({ "user_id": user_id, "title": title, "abstract": abstract, "content": content, "status": status, "cover": cover, }) with session_scope() as session: session.add(impression)
def update_diary(self, diary_id, week, weather, mood, content, status, cover): with session_scope() as session: diary = session.query(Diary).filter(Diary.id == diary_id).first() diary.week = week diary.weather = weather diary.mood = mood diary.content = content diary.status = status diary.cover = cover session.add(diary)
def delete_comment(self, comment_id_list=None): if not comment_id_list: raise Exception("评论id列表不能为None") if not isinstance(comment_id_list, list): raise Exception("评论id参数不是一个列表") with session_scope() as session: comment_list = session.query(Comment).filter( Comment.id.in_(comment_id_list)) for comment in comment_list: comment.is_delete = True session.add(comment)
def delete_diary(self, diary_id_list=None): if not diary_id_list: raise Exception("随笔id列表不能为None") if not isinstance(diary_id_list, list): raise Exception("随笔id参数不是一个列表") with session_scope() as session: diary_list = session.query(Diary).filter( Diary.id.in_(diary_id_list)) for diary in diary_list: diary.is_delete = True session.add(diary)
def get_reply_by_comment(self, comment_id): with session_scope() as session: comment_list = session.query(Comment).filter( Comment.comment_id == comment_id) if not list(comment_list): return None return [ comment.to_dict(wanted_list=[ "id", "comment_con", "comment_id", "comment_user", "create_time" ]) for comment in comment_list ]
def get_comment_by_article(self, article_id, page_size=10, page_now=1): with session_scope() as session: comment_list = session.query(Comment).filter( Comment.article_id == article_id).offset( (page_now - 1) * page_size).limit(page_size) if not list(comment_list): return None return [ comment.to_dict(wanted_list=[ "id", "comment_con", "comment_id", "comment_user", "create_time" ]) for comment in comment_list ]
def create_diary(self, user_id, week, weather, mood, content, status, cover): diary = Diary({ "user_id": user_id, "week": week, "weather": weather, "mood": mood, "content": content, "status": status, "cover": cover, }) with session_scope() as session: session.add(diary)
def create_comment(self, article_id, article_type, comment_con, comment_user, comment_id=None): comment = Comment({ "article_id": article_id, "article_type": article_type, "comment_con": comment_con, "comment_user": comment_user, "comment_id": comment_id }) with session_scope() as session: session.add(comment)