def query(self, table: str, columns: list, where=None, params=None, first=False, order_by=None, limit=None) -> list: """ :param table: :param columns: :param where: 'name=%s and age=10' :param params: where条件的值:如: ['1', '2'] :param first: 是否查询单条数据 :param order_by: age desc, name asc,该条件小心sql注入 :param limit: 0,20 :return: None: 表示异常,否则: first为true或False: 分别返回 {}, [] """ try: return self.__query(2, columns, table, where, params, first, order_by, limit) except Exception as err: logger.error('异常:%s ' % str(err)) return None
def redis(self, call): try: return call(self.__redis) except Exception as e: logger.error(str(e.args)) return None
async def all_exception_handler(request: Request, exc: Exception): """ 全局所有异常 :param request: :param exc: :return: """ logger.error( f"全局异常\n{request.method}URL:{request.url}\nHeaders:{request.headers}\n{traceback.format_exc()}" ) return response_code.resp_500(message="服务器内部错误")
async def inner_validation_exception_handler( request: Request, exc: custom_exc.UserTokenError): """ 内部参数验证异常 :param request: :param exc: :return: """ logger.error( f"Token错误\nURL:{request.method}{request.url}\nHeaders:{request.headers}\n{traceback.format_exc()}" ) return response_code.resp_5000(message=exc.err_desc)
async def request_validation_exception_handler( request: Request, exc: RequestValidationError): """ 请求参数验证异常 :param request: :param exc: :return: """ logger.error( f"请求参数格式错误\nURL:{request.method}{request.url}\nHeaders:{request.headers}\n{traceback.format_exc()}" ) return response_code.resp_422(message=exc.errors())
def query_count_sql(self, sql: str, params=None) -> int: """根据条件查询匹配的count数 :param sql: :param params: where条件的值:如: ['1', '2'] :return: -1:表示异常,>-1: 表示正常 """ try: return self.__query(3, None, sql, None, params, True, None, None) except Exception as err: logger.error('异常:%s ' % str(err)) return -1
def delete_sql(self, sql: str, params: list): """ :param sql: :param params: where条件的值:如: ['1', '2'] :return: -1:表示异常,>-1: 表示正常 """ try: return self.__execute_sql(2, sql, params) except Exception as err: logger.error('异常:%s ' % str(err)) return -1
def insert_sql(self, sql: str, params: list): """ :param sql: :param params: where条件的值:如: ['1', '2'] :return: -1:表示异常,>-1:表示当前插入数据的自增ID值 """ try: return self.__execute_sql(0, sql, params) except Exception as err: logger.error('异常:%s ' % str(err)) return -1
def insert(self, table: str, data: object) -> int: """ :param table: sys_user :param data: {'name': 'tom', age: '10'} :return: -1:表示异常,>-1:表示当前插入数据的自增ID值 """ try: return self.__cud(None, 0, table, None, data) except Exception as err: logger.error('异常:%s ' % str(err)) return -1
def query_sql(self, sql: str, params=None, first=False) -> list: """ :param sql: sql语句 :param params: where条件的值:如: ['1', '2'] :param first: 是否查询单条数据 :return: None:表示异常,否则:first 为 True 或 False: 分别返回 {}, [] """ try: return self.__query(1, None, sql, None, params, first, None, None) except Exception as err: logger.error('异常:%s ' % str(err)) return None
def delete(self, table: str, where=None, params=None) -> int: """ :param table: :param where: 'name=%s and age=10' :param params: where条件的值:如: ['1', '2'] :return: -1:表示异常,>-1:表示正常 """ try: return self.__cud(None, 2, table, None, where, params) except Exception as err: logger.error('异常:%s ' % str(err)) return -1
def update(self, table: str, sets: dict, where=None, params=None) -> int: """ :param table: :param sets: {'name': 'tom', age: '10'} :param where: 'name=%s and age=10' :param params: where条件的值:如: ['1', '2'] :return: -1:表示异常,>-1:表示正常 """ try: return self.__cud(None, 1, table, sets, where, params) except Exception as err: logger.error('异常:%s ' % str(err)) return -1