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