def new_status_code(self, service_id, fun_id, type_id, error_id, error_desc, adder):
if check_int(service_id) is False:
return False, "Bad service_id"
if check_int(fun_id) is False:
return False, "Bad fun_id"
if check_int(type_id) is False:
return False, "Bad type_id"
if check_int(error_id) is False:
return False, "Bad error_id"
status_code = fill_zero(service_id, 2) + fill_zero(fun_id, 2) + fill_zero(type_id, 2) + fill_zero(error_id, 2)
self._insert_status_code(status_code, error_desc, adder)
return True, status_code
def get_function_info(self):
select_sql = "SELECT service_id,service_title,service_desc FROM %s;" % self.service_module
self.db.execute(select_sql)
module_info = {}
for item in self.db.fetchall():
service_id_s = fill_zero(item[0], 2)
module_info[service_id_s] = {"title": item[1], "desc": item[2], "fun_info": {}}
select_sql = "SELECT service_id,function_id,function_title,function_desc FROM %s;" % self.function_module
self.db.execute(select_sql)
for item in self.db.fetchall():
service_id_s = fill_zero(item[0], 2)
if service_id_s in module_info:
fun_id_s = fill_zero(item[1], 2)
module_info[service_id_s]["fun_info"][fun_id_s] = {"title": item[2], "desc": item[3]}
return True, module_info
def new_mul_status_code(self, service_id, fun_id, error_info, adder):
if check_int(service_id) is False:
return False, "Bad service_id"
if check_int(fun_id) is False:
return False, "Bad fun_id"
basic_code = service_id * 1000000 + fun_id * 10000
success_new = []
for item in error_info:
if "type_id" not in item:
continue
if "error_desc" not in item:
continue
type_id = item["type_id"]
error_desc = item["error_desc"]
if check_int(type_id) is False:
continue
error_code = basic_code + type_id * 100
# 查询该模块下此类错误最大的状态码
select_sql = "SELECT status_code FROM %s WHERE status_code>=%s AND status_code<%s " \
"ORDER BY status_code DESC LIMIT 1;" % (self.status_code, error_code, error_code + 100)
result = self.db.execute(select_sql)
if result > 0:
error_code = self.db.fetchone()[0] + 1
result = self._insert_status_code(error_code, error_desc, adder)
if result == 1:
success_new.append({"status_code": fill_zero(error_code, 8), "error_desc": error_desc})
return True, success_new
def get_error_type(self):
select_sql = "SELECT type_id,type_title,type_desc FROM %s;" % self.error_type
self.db.execute(select_sql)
type_info = {}
for item in self.db.fetchall():
type_id_s = fill_zero(item[0], 2)
type_info[type_id_s] = {"title": item[1], "desc": item[2]}
return True, type_info
def get_status_code(self, status_code=None):
select_sql = "SELECT status_code,code_desc,add_time,adder FROM %s" % self.status_code
args = []
if status_code is not None:
select_sql += " WHERE status_code=%s"
args.append(status_code)
select_sql += ";"
self.db.execute(select_sql, args=args)
status_info = []
for item in self.db.fetchall():
status_info.append({"status_code": fill_zero(item[0], 8), "code_desc": item[1],
"add_time": item[2].strftime(TIME_FORMAT), "adder": item[3]})
return True, status_info
def insert_function_module(self, service_id, function_title, function_desc):
if check_chinese_en(function_title) is False:
return False, "Bad function_title"
if check_special_character(function_desc) is False:
return False, "Bad function_desc"
select_sql = "SELECT MAX(function_id) FROM %s WHERE service_id=%s;" % (self.function_module, service_id)
result = self.db.execute(select_sql)
if result == 0:
function_id = 0
else:
db_result = self.db.fetchone()[0]
if db_result is None:
function_id = 0
else:
function_id = db_result + 1
insert_sql = "INSERT INTO %s (service_id,function_id,function_title,function_desc) VALUES (%s,%s,'%s','%s');" \
% (self.function_module, service_id, function_id, function_title, function_desc)
self.db.execute(insert_sql)
return True, {"function_id": fill_zero(function_id, 2), "function_title": function_title, "function_desc": function_desc}
