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)
