def perm_info(): result = [] q_l = Permission.query.all() for perm in q_l: res = model_serializable(perm) result.append(res) return data_return(result=result)
def change_user_info(): uid = request.args.get("id") user = User.query.filter_by(id=uid).first_or_404() if user: res = model_serializable(user) r_id = [r["id"] for r in res["role"]] res["role"] = Role.select_list(r_id) return data_return(result=res) return data_return(code=1, errmsg="用户不存在")
def get_jigui(): res = [] server_list = Server.query.all() for item in server_list: server_item = model_serializable(item) server_item["cabinet_name"] = server_item["cabinet"]["name"] server_item["idc_name"] = server_item["cabinet"]["idc"]["name"] res.append(server_item) return data_return(result=res)
def role_info(): result = [] r_l = Role.query.all() for role in r_l: res = model_serializable(role) res["permission"] = ",".join([p["name"] for p in res["permission"]]) result.append(res) return data_return(result=result)
def user_info(): result = [] user_l = User.query.filter_by().all() for u in user_l: res = model_serializable(u) res["role"] = ",".join([r["name"] for r in res["role"]]) result.append(res) return data_return(result=result)
def update_switch(): if request.method == "GET": id = request.args.get("id") get_sw = Switch.query.filter(Switch.id == id).first_or_404() return data_return(result=model_serializable(get_sw)) update_s = UpdateSwitchForm(request.form) if update_s.validate(): id = update_s.id.data update_sw = Switch.query.filter(Switch.id == id).first_or_404() with db.auto_commit(): update_sw.set_attrs(update_s.data) return data_return()
def update_idc(): if request.method == "GET": id = request.args.get("id") idc_item = Idc.query.filter(Idc.id == id).first_or_404() return data_return(result=model_serializable(idc_item)) id = request.form.get("id") idc_item = Idc.query.filter(Idc.id == id).first_or_404() res_idc = UpdateIdcForm(request.form) if res_idc.validate(): with db.auto_commit(): idc_item.set_attrs(res_idc.data) return data_return() else: return data_return(code=1,errmsg= err_list(res_idc))
def update_server(): if request.method == "GET": id = request.args.get("id") s_item = Server.query.filter(Server.id == id).first_or_404() res = model_serializable(s_item) return data_return(result=res) res_s = UpdateServerForm(request.form) if res_s.validate(): id = res_s.id.data update_s = Server.query.filter(Server.id==id).first_or_404() with db.auto_commit(): update_s.set_attrs(res_s.data) return data_return() else: return data_return(code=1,errmsg=err_list(res_s))
def add_cabinet(): if request.method == "GET": res = [] res_list = Idc.query.all() for item in res_list: res.append(model_serializable(item)) return data_return(result=res) r_cab = AddCabinetForm(request.form) if r_cab.validate(): cab = Cabinet() with db.auto_commit(): cab.set_attrs(r_cab.data) db.session.add(cab) return data_return() else: return data_return(code=1, errmsg=err_list(r_cab))
def update_cabinet(): if request.method == "GET": id = request.args.get("id") update_cab = Cabinet.query.filter(Cabinet.id == id).first_or_404() res = model_serializable(update_cab) return data_return(result=res) r_cab = UpdateCabinetForm(request.form) id = r_cab.id.data if r_cab.validate(): cab = Cabinet.query.filter(Cabinet.id == id).first_or_404() with db.auto_commit(): cab.set_attrs(r_cab.data) db.session.add(cab) return data_return() else: return data_return(code=1, errmsg=err_list(r_cab))
def add_switch(): if request.method == "GET": """ 获取所有机柜信息 """ all_cab = Cabinet.query.all() res = [model_serializable(c) for c in all_cab] return data_return(result=res) res_switch = AddSwitchForm(request.form) if res_switch.validate(): with db.auto_commit(): sw = Switch() sw.set_attrs(res_switch.data) db.session.add(sw) return data_return() else: return data_return(code=1, errmsg=err_list(res_switch))
def add_server(): if request.method == "GET": """ 获取所有机柜信息 """ all_cab = Cabinet.query.all() res = [model_serializable(c) for c in all_cab] return data_return(result=res) add_server_form = AddServerForm(request.form) if add_server_form.validate(): serv = Server() with db.auto_commit(): serv.set_attrs(add_server_form.data) db.session.add(serv) return data_return() else: return data_return(code=1,errmsg=err_list(add_server_form))
def get_idc(): res = [] idc_list = Idc.query.all() for item in idc_list: res.append(model_serializable(item)) return data_return(result=res)
def get_cabinet(): res = [] cab_list = Cabinet.query.all() for item in cab_list: res.append(model_serializable(item)) return data_return(result=res)
def get_server(): get_s = Server.query.all() res_s = [model_serializable(s) for s in get_s] return data_return(result=res_s)
def get_role(): uid = int(request.args.get("id")) role_item = Role.query.filter(Role.id==uid).first_or_404() e = model_serializable(role_item) return data_return(result=e)
def got_perm(): uid = int(request.args.get("id")) perm_item = Permission.query.filter(Permission.id == uid).first_or_404() e = model_serializable(perm_item) return data_return(result=e)
def get_switch(): all_switch_item = Switch.query.all() result = [model_serializable(s) for s in all_switch_item] return data_return(result=result)