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 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 insert_login_server(self, server_ip, server_name, user_ip, user_name, login_time):
if check_int(server_ip, 1, sys.maxint) is False:
return False, "Bad server ip"
if check_int(user_ip, 1, sys.maxint) is False:
return False, "Bad user ip"
now_time = int(time())
if check_int(login_time, now_time - 100, now_time + 100) is False:
return False, "Bad login time"
user_name = check_sql_character(user_name)[:50]
server_name = check_sql_character(server_name)[:20]
insert_sql = "INSERT INTO %s (server_ip,server_name,user_ip,user_name,login_time) VALUES (%s,'%s',%s,'%s',%s);" \
% (self.login_server, server_ip, server_name, user_ip, user_name, login_time)
self.local_db.execute(insert_sql)
return True, "success"
def new_api_module(self, module_name, module_prefix, module_desc, module_part, module_env):
module_name = module_name.strip(" ")
if check_chinese_en(module_name, 1, 35) is False:
return False, "Bad module_name."
if check_path(module_prefix, 1, 35) is False:
return False, "Bad module_prefix"
if check_int(module_part, max_v=9999) is False:
return False, "Bad module_part"
if type(module_env) != list:
return False, "Bad module_env"
if len(module_env) not in range(1, 6):
print(module_env)
return False, "Bad module_env."
module_desc = check_sql_character(module_desc)[:240]
module_env_s = ""
for env_no in module_env:
if type(env_no) != int:
return False, "Bad env_no"
module_env_s += "%s|" % env_no
insert_sql = "INSERT INTO %s (module_name,module_prefix,module_desc,module_part,module_env) " \
"VALUES ('%s','%s','%s',%s,'%s');" \
% (self.api_module, module_name, module_prefix, module_desc, module_part, module_env_s[:-1])
result = self.db.execute(insert_sql)
if result != 1:
return False, "sql execute result is %s " % result
return True, "success"
def update_api_module(self, module_no, module_name, module_prefix, module_desc, module_part, module_env):
if check_chinese_en(module_name, 0, 35) is False:
return False, "Bad module_name."
if check_path(module_prefix, 0, 35) is False:
return False, "Bad module_prefix"
if check_int(module_part, max_v=9999) is False:
return False, "Bad module_part"
if type(module_env) != list:
return False, "Bad module_env"
if len(module_env) not in range(1, 6):
print(module_env)
return False, "Bad module_env."
module_desc = check_sql_character(module_desc)[:240]
module_env_s = ""
for env_no in module_env:
if type(env_no) != int:
return False, "Bad env_no"
module_env_s += "%s|" % env_no
update_sql = "UPDATE %s SET module_name='%s',module_prefix='%s',module_desc='%s',module_part=%s,module_env='%s' " \
"WHERE module_no=%s;" \
% (self.api_module, module_name, module_prefix, module_desc, module_part, module_env_s[:-1], module_no)
result = self.db.execute(update_sql)
return True, "success"
