def cbtenlist():
if not session:
return redirect("/login/")
cab = list("cbten", filed_cbt)["msg"]
idcs = list("machine", filed_idc)["msg"]
idc = {"%s" % idc["id"]: idc["username"] for idc in idcs}
for i in cab:
if i["address"] in idc:
i["address"] = idc[i["address"]]
return render_template("cbtenlist.html", result=cab, idc=idcs)
def serverlist():
if not session:
return redirect("/login/")
idcs = list("machine", filed_idc)
cabinets = list("cbten", cabinet_fields)
servers = list("server", fileds_server)
for cab in servers["msg"]:
for items in cabinets['msg']:
if cab["cabinet"] == items["id"]:
cab["cabinet"] = items["username"]
for cac in idcs["msg"]:
if cab["idc"] == cac["id"]:
cab["idc"] = cac["username"]
return render_template("serverlist.html", result=servers["msg"])
def userlist():
if not session or session["role"] != 0:
return redirect("/login/")
result = list("mylist", filed)
if result["code"] == 1:
result = result["msg"]
return render_template("new-userlist.html", result=result, info=session)
def addserver():
if request.method == "POST":
fileds = [
'hostname', 'ip', 'mac', 'username', 'password', 'port', 'idc',
'brand', 'cpu', 'memory', 'disk', 'system_type', 'number',
"cabinet"
]
data = {k: v[0] for k, v in dict(request.form).items()}
result = insert("server", fileds, data)
if result["code"] == 0:
return json.dumps(result)
if request.method == 'GET':
idc = list('machine', filed_idc)
cabinet = list('cbten', cabinet_fields)
result = {'code': 0, 'idc': idc['msg'], 'cabinet': cabinet['msg']}
return json.dumps(result)
def severlist():
if not session:
return redirect("/login/")
#result=list("server",fileds_server)["msg"]
idcs = list("machine", filed_idc)
cabinets = list('cbten', cabinet_fields)
servers = list('server', fileds_server)
#idcs={"%s" %idc["id"]:idc["username"] for idc in idcs}
for cab in servers['msg']:
for items in cabinets['msg']:
if cab['cabinet'] == items['id']:
cab['cabinet'] = items['username']
for cac in idcs['msg']:
if cab['idc'] == cac['id']:
cab['idc'] = cac['username']
return render_template('severlist.html', result=servers['msg'])
def ansilbe():
if "username" not in session:
return redirect("/login/")
if request.method == "GET":
server = list("server", server_fields)
return render_template('ansible.html', server=server['msg'])
if request.method == "POST":
cmdmsg = {k: v[0] for k, v in dict(request.args).items()}
#记录日志写入文件
cmd_time = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
cmd_history = "Time:%s User:%s Host:%s Cmd :%s \n" % (
cmd_time, session["username"], cmdmsg['pattern'], cmdmsg['cmd'])
with open("/tmp/ansible.log", 'a') as ansible_log:
ansible_log.write(cmd_history)
ansible_log.close
ansiblecmd = ansiblecommand(cmdmsg["cmd"], cmdmsg["pattern"])
pattern = cmdmsg["pattern"]
result = ansiblecmd["contacted"][pattern]["stdout"]
if result:
ansible_cmd = "host: %s | CMD: %s | success>> \n" % (
cmdmsg["pattern"], cmdmsg["cmd"])
ansible_msg = ansible_cmd + result
results = ansible_msg.replace("\n,<br>")
return json.dumps(results)
def idclist():
if not session:
return redirect("/login/")
result=list("machine",filed_idc)
if result["code"]==0:
result=result["msg"]
return render_template("idc.html",result=result)
def joblist():
if not session:
return redirect("/login/")
file = ['id','apply_name','handle_name','apply_type','apply_desc','handle_desc','status','created','modified']
result=list("job",file)
if result["code"]==0:
result = result["msg"]
return render_template("joblist.html",result=result)
def severlist():
if not session:
return redirect("/login/")
fileds = ['id','hostname', 'ip', 'mac', 'username', 'password', 'port', 'idc', 'brand', 'cpu', 'memory', 'disk', 'system_type', 'number']
result=list("server",fileds)
if result["code"]==0:
result = result["msg"]
return render_template("severlist.html",result=result)
def cbtenlist():
if not session:
return redirect("/login/")
filed=["id","username","address","U","power"]
result=list("cbten",filed)
if result["code"]==0:
result = result["msg"]
return render_template("cbtenlist.html",result=result)
def machinlist():
if not session:
return redirect("/login/")
filed=["id","username","address","phone"]
result=list("machine",filed)
if result["code"]==0:
result = result["msg"]
return render_template("machine.html",result=result)
def updataserver():
if not session:
return redirect("/login/")
if request.method == "GET":
uid = request.args.get("id")
data = {"id": uid}
server = getone("server", fileds_server, data)
idc = list('machine', filed_idc)
cabinet = list('cbten', cabinet_fields)
result = {
"code": 0,
"idc": idc["msg"],
'cabinet': cabinet["msg"],
'server': server["msg"]
}
return json.dumps(result)
if request.method == "POST":
data = {k: v[0] for k, v in dict(request.form).items()}
result = update("server", fileds_server, data)
if result["code"] == 0:
return json.dumps(result)
def updatesever():
if 'username' not in session:
return redirect("/login/")
if request.method == "GET":
id = request.args.get("id")
data = {"id": id}
server = getone("server", fileds_server, data)
idc = list('machine', filed_idc)
cabinet = list('cbten', cabinet_fields)
result = {
'code': 0,
'idc': idc['msg'],
'cabinet': cabinet['msg'],
'server': server['msg']
}
return json.dumps(result)
else:
user = {k: v[0] for k, v in dict(request.form).items()}
result = update("server", fileds_server, user)
if result["code"] == 0:
return json.dumps(result)
def updatacbt():
if not session:
return redirect("/login/")
if request.method == "GET":
uid = request.args.get("id")
data = {"id": uid}
result = getone("cbten", filed_cbt, data)
idc = list("machine", filed_idc)["msg"]
return render_template("updatacbt.html", result=result["msg"], idc=idc)
if request.method == "POST":
data = {k: v[0] for k, v in dict(request.form).items()}
result = update("cbten", filed_cbt, data)
return json.dumps(result)
def cbtenupdate():
if not session:
return redirect("/login/")
if request.method == 'POST':
data = {k: v[0] for k, v in dict(request.form).items()}
result = update("cbten", filed_cbt, data)
return json.dumps(result)
else:
uid = request.args.get("id", "")
data = {"id": uid}
result = getone("cbten", filed_cbt, data)
idc = list("machine", filed_idc)["msg"]
if result["code"] == 0:
result = result["msg"]
#return json.dumps(result)
return render_template("cbtenupdate.html", result=result, idc=idc)
def ansible():
if not session:
return redirect("/login/")
if request.method=="GET":
server=list("server",server_fields)
return render_template("ansible.html",server=server["msg"])
if request.method=="POST":
cmdmsg={k:v[0] for k,v in dict(request.form).items()}
cmd_time=datetime.now().strftime("Y-%m-%d %H:%M:%S")
cmd_history="Time:%s User:%s Host:%s Cmd:%s /n" %(cmd_time,session["username"],cmdmsg['pattern'],cmdmsg['cmd'])
with open("C://Users//xxx//PycharmProjects//honework10//ansible.log",'a') as ansible_log:
ansible_log.write(cmd_history)
ansible_log.close
ansiblecmd=ansiblecommand(cmdmsg["msg"],cmdmsg["pattern"])
pattern=cmdmsg["pattern"]
result=ansiblecmd["contacter"][pattern]["stdout"]
if result:
ansible_cmd="host:%s | CMD :%s | success>> \n" %(cmdmsg["pattern"],cmdmsg["cmd"])
anssble_msg=ansible_cmd+result
result=anssble_msg.replace('\n','<br>')
return json.dumps(result)
def moneylist():
if not session:
return redirect("/login/")
if request.method == "GET":
result = list("money", file)
return render_template("moneylist.html", result=result["msg"])
