def delete_file(self, db: Session, response: Response, *, id: int):
"""
通过 文件id 删除文件信息
:param id: 用户id
:return: 文件信息, 提示信息
"""
db_file = crud_file.get_file_by_id(db, id=id)
if not db_file:
message = f"id为 {id} 的文件不存在"
response.status_code = status.HTTP_404_NOT_FOUND
return None, message
db_status = 1 # 状态(逻辑删除) 0:未删除, 1:已删除
serialize_db_file = tools_func.serialize_sqlalchemy_obj(db_file)
db_file_obj = crud_file.update_status(db,
id=serialize_db_file["id"],
status=db_status)
if not db_file_obj:
message = "文件删除失败"
response.status_code = status.HTTP_500_INTERNAL_SERVER_ERROR
logger.error(message)
else:
message = "文件删除成功"
response.status_code = status.HTTP_200_OK
return db_file_obj, message
async def getBaseApi(
*,
db: Session = Depends(dependency=deps.get_db),
) -> Any:
# 获取分页数据模型
BaseApiList = curd_base_api.get_multi(db=db)
# 将数据模型序列化输出
data_response = serialize_sqlalchemy_obj(BaseApiList)
return response_code.resp_200(data=data_response)
async def get_project_info(
*,
db: Session = Depends(deps.get_db),
) -> AutoProject:
# 获取分页数据模型
auto_project_list = curd_project.get_multi(db=db)
# 将数据模型序列化输出
data_response = serialize_sqlalchemy_obj(auto_project_list)
return response_code.resp_200(data=data_response)
def get_follow_by_id(self, db: Session, response: Response, *, id: int):
"""
通过 关注id 查询信息
:param id: 关注id
:return: 关注信息, 提示信息
"""
db_follow = crud_follow.get_follow_by_id(db, id=id)
if not db_follow:
message = f"id 为 {id} 的关注信息不存在"
else:
message = f"id 为 {id} 的关注信息查询成功"
serialize_db_follow = tools_func.serialize_sqlalchemy_obj(db_follow)
return serialize_db_follow, message
def get_like_by_id(self, db: Session, response: Response, *, id: int):
"""
通过 点赞id 查询信息
:param id: 点赞id
:return: 点赞信息, 提示信息
"""
db_like = crud_like.get_like_by_id(db, id=id)
if not db_like:
message = f"id 为 {id} 的点赞信息不存在"
response.status_code = status.HTTP_404_NOT_FOUND
else:
message = f"id 为 {id} 的点赞信息查询成功"
response.status_code = status.HTTP_200_OK
serialize_db_obj = tools_func.serialize_sqlalchemy_obj(db_like)
return serialize_db_obj, message
def get_topic_by_id(self, db: Session, response: Response, *, id: int):
"""
通过 主贴id 查询信息
:param id: 主贴id
:return: 主贴信息, 提示信息
"""
db_topic = crud_topic.get_topic_by_id(db, id=id)
if not db_topic:
message = f"id 为 {id} 的主贴信息不存在"
response.status_code = status.HTTP_404_NOT_FOUND
else:
message = f"id 为 {id} 的主贴信息查询成功"
response.status_code = status.HTTP_200_OK
serialize_db_topic = tools_func.serialize_sqlalchemy_obj(db_topic)
return serialize_db_topic, message
def get_collect_by_id(self, db: Session, response: Response, *, id: int):
"""
通过 收藏id 查询信息
:param id: 收藏id
:return: 收藏信息, 提示信息
"""
db_collect = crud_collect.get_collect_by_id(db, id=id)
if not db_collect:
message = f"id 为 {id} 的收藏信息不存在"
response.status_code = status.HTTP_404_NOT_FOUND
else:
message = f"id 为 {id} 的收藏信息查询成功"
response.status_code = status.HTTP_200_OK
serialize_db_collect = tools_func.serialize_sqlalchemy_obj(db_collect)
return serialize_db_collect, message
def get_reply_by_id(self, db: Session, response: Response, *, id: int):
"""
通过 回帖id 查询信息
:param id: 回帖id
:return: 回帖信息, 提示信息
"""
db_reply = crud_reply.get_reply_by_id(db, id=id)
if not db_reply:
message = f"id 为 {id} 的回帖信息不存在"
response.status_code = status.HTTP_404_NOT_FOUND
else:
message = f"id 为 {id} 的回帖信息查询成功"
response.status_code = status.HTTP_200_OK
serialize_db_reply = tools_func.serialize_sqlalchemy_obj(db_reply)
return serialize_db_reply, message
def get_file_by_id(self, db: Session, response: Response, *, id: int):
"""
通过 文件id 查询文件信息
:param id: 用户id
:return: 文件信息, 提示信息
"""
db_file = crud_file.get_file_by_id(db, id=id)
if not db_file:
message = f"id 为 {id} 的文件信息不存在"
response.status_code = status.HTTP_404_NOT_FOUND
else:
message = f"id 为 {id} 的文件信息查询成功"
response.status_code = status.HTTP_200_OK
serialize_db_file = tools_func.serialize_sqlalchemy_obj(db_file)
return serialize_db_file, message
def get_forwarding_by_id(self, db: Session, response: Response, *,
id: int):
"""
通过 转发id 查询信息
:param id: 转发id
:return: 转发信息, 提示信息
"""
db_forwarding = crud_forwarding.get_forwarding_by_id(db, id=id)
if not db_forwarding:
message = f"id 为 {id} 的转发信息不存在"
response.status_code = status.HTTP_404_NOT_FOUND
else:
message = f"id 为 {id} 的转发信息查询成功"
response.status_code = status.HTTP_200_OK
serialize_db_forwarding = tools_func.serialize_sqlalchemy_obj(
db_forwarding)
return serialize_db_forwarding, message
def get_topics(self, db: Session, response: Response, *, filter_spec: str, paginate: str, sort_spec: str):
"""
查询所有主贴信息
:param filter_spec: 过滤查询的条件
:param sort_spec: 排序（field: 字段名，direction: 排序方式）
:param paginate: page: 当前页数，limit: 每页显示的条数
:return: 主贴信息列表, 总记录数, 总页数, 提示信息
"""
db_topics, total, number_page = crud_topic.get_topics(
db, filter_spec=json.loads(filter_spec), paginate=json.loads(paginate), sort_spec=json.loads(sort_spec))
if not db_topics:
message = "主贴列表信息为空"
response.status_code = status.HTTP_200_OK
return None, None, None, message
message = "查询主贴列表信息成功"
response.status_code = status.HTTP_200_OK
serialize_db_topics = tools_func.serialize_sqlalchemy_obj(db_topics)
return serialize_db_topics, total, number_page, message
def get_project_case(self, *, db: Session, project_api_id: int) -> Dict:
project_case_list = db.query(self.model).filter(
self.model.project_api_id == project_api_id).all()
data_response = tools_func.serialize_sqlalchemy_obj(project_case_list)
return data_response