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