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)
