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_info(self, api_no, module_no, api_title, api_path, api_method, api_desc): if len(api_no) != 32: return False, "Bad api_no" if type(module_no) != int: return False , "Bad module_no" if check_path(api_path) is False: return False, "Bad api_path" if api_path.endswith("/") is False: return False, u"api path should end with /" if check_http_method(api_method) is False: return False, "Bad api_method" api_title = check_sql_character(api_title) api_desc = check_sql_character(api_desc) if len(api_desc) < 1: return False, "Bad api_desc" # 更新 api_info update_time = datetime.now().strftime(TIME_FORMAT) update_sql = "UPDATE %s SET module_no=%s,api_title='%s',api_path='%s',api_method='%s',api_desc='%s',update_time='%s' " \ "WHERE api_no='%s'; " \ % (self.api_info, module_no, api_title, api_path, api_method, api_desc, update_time, api_no) result = self.db.execute(update_sql) return True, "success"
def new_api_info(self, module_no, api_title, api_path, api_method, api_desc): if type(module_no) != int: return False , "Bad module_no" if check_path(api_path) is False: return False, "Bad api_path" if api_path.endswith("/") is False: return False, u"api path should end with /" if check_http_method(api_method) is False: return False, "Bad api_method" api_title = check_sql_character(api_title) api_desc = check_sql_character(api_desc) if len(api_desc) < 1: return False, "Bad api_desc" api_no = uuid.uuid1().hex # 新建 api_info add_time = datetime.now().strftime(TIME_FORMAT) insert_sql = "INSERT INTO %s (api_no,module_no,api_title,api_path,api_method,api_desc,add_time,update_time) " \ "VALUES('%s',%s,'%s','%s','%s','%s','%s','%s')" \ % (self.api_info, api_no, module_no, api_title, api_path, api_method, api_desc, add_time, add_time) result = self.db.execute(insert_sql) if result != 1: return False, "sql execute result is %s " % result return True, {"api_no": api_no}
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"