def table_row_add(request):
if request.method == "POST":
host = request.body
hostinfo = json.loads(host)
hostname = hostinfo[0]["hostname"]
hostip = hostinfo[0]["hostip"]
hostport = hostinfo[0]["hostport"]
project_owner = hostinfo[0]["project_owner"]
idc_name = hostinfo[0]["idc_name"]
try:
hosthost = ansible_host.objects.filter(hostip__exact=hostip).values()
print(len(list(hosthost)))
if len(list(hosthost)) == 0:
try:
hosttable = ansible_host.objects.create(hostip=hostip,hostport=hostport,hostname=hostname,
project_owner=project_owner,idc_name=idc_name)
hosttable.save()
hosterror = "主机添加成功"
except BaseException as e:
logger.error(e)
hosterror = "主机添加失败"
else:
hosterror = "主机地址已存在无需重复添加"
except BaseException as e:
logger.error(e)
hosterror = "数据库查询失败"
return HttpResponse(hosterror)
else:
return render_to_response('host-add.html')
def tenginehostadd(request):
if request.method == "POST":
host = request.body
hostinfo = json.loads(host)
hostip = hostinfo[0]["hostip"]
hostport = hostinfo[0]["hostport"]
try:
hosthost = tenginehost.objects.filter(host__exact=hostip).values()
print(len(list(hosthost)))
if len(list(hosthost)) == 0:
try:
hosttable = tenginehost.objects.create(
host=hostip, hostredisport=hostport)
hosttable.save()
hosterror = "主机添加成功"
except BaseException as e:
logger.error(e)
hosterror = "主机添加失败"
else:
hosterror = "主机地址已存在无需重复添加"
except BaseException as e:
logger.error(e)
hosterror = "数据库查询失败"
return HttpResponse(hosterror)
else:
return render_to_response('tengine_add.html')
def tenginehostupdate(request):
if request.method == "POST":
host = request.body
hostinfo = json.loads(host)
hostip = hostinfo[0]["hostip"]
hostport = hostinfo[0]["hostport"]
try:
tenginehost.objects.filter(host__exact=hostip).update(
host=hostip, hostredisport=hostport)
hosterror = "主机信息更新成功"
except BaseException as e:
logger.error(e)
hosterror = "主机信息更新失败"
return HttpResponse(hosterror)
else:
hostinfo = []
hostip = request.GET["hostip"]
hosttable = tenginehost.objects.filter(host__exact=hostip).values()
for host in hosttable:
hostinfo.append(host)
return render_to_response('tengine_edit.html', {"hostinfo": hostinfo})
def graydelphone(self):
try:
grayphone.objects.filter(phone__exact=self.phone).delete()
delstatus = "删除手机号码 %s 成功" % self.phone
except BaseException as e:
logger.error(e)
delstatus = "删除手机号码 %s 失败" % self.phone
return delstatus
def graydelredisphone(self):
try:
self.__conn.delete(self.graymd5value())
delredisphonestatus = 0
except BaseException as e:
logger.error(e)
delredisphonestatus = 1
return delredisphonestatus
def userdel(self,username):
try:
users.objects.filter(username=username).delete()
userdelerror = "用户删除成功"
except BaseException as e:
logger.error(e)
userdelerror = "用户删除失败"
return userdelerror
def vardel(self, varnameid):
try:
compile_conf.objects.filter(varnameid=varnameid).delete()
confdelerror = ("删除变量 %s 成功" % self.var)
except BaseException as e:
logger.error("变量名称 %s 删除不成功" % self.var)
confdelerror = ("删除变量 %s 失败" % self.var)
return confdelerror
def saveecord(self):
try:
coummit = RecordLogTable.objects.create(
username=self.username,
recordclass=self.recordclass,
recordvalue=self.recordvalue)
coummit.save()
except BaseException as e:
logger.error(e)
def varupdate(self, varnameid):
try:
compile_conf.objects.filter(varnameid=varnameid).update(
varname=self.var, varpath=self.varpath)
confuperror = ("更新变量 %s 成功" % self.var)
except BaseException as e:
logger.error("变量名称 %s 更新不成功" % self.var)
confuperror = ("更新变量 %s 失败" % self.var)
return confuperror
def grayaddredisphone(self, duration):
try:
keyvalue = self.graymd5value()
self.__conn.set(keyvalue, keyvalue, duration)
addredisstatus = "添加手机号码 %s 成功" % self.phone
except BaseException as e:
logger.error(e)
addredisstatus = "添加手机号码 %s 失败" % self.phone
return addredisstatus
def update(self):
try:
role.objects.filter(roleid__exact=self.permissionudnum).update(
Rolename=self.rolename)
addroleerror = "角色更新成功"
except BaseException as e:
logger.error(e)
addroleerror = "角色更新失败"
return addroleerror
def roledel(self, permissionid):
try:
role.objects.filter(roleid__exact=permissionid).delete()
permission.objects.filter(roleid__exact=permissionid).delete()
addroleerror = "角色删除成功"
except BaseException as e:
logger.error(e)
addroleerror = "角色删除失败"
return addroleerror
def tenginehostdel(request):
if request.method == "POST":
pass
else:
hostip = request.GET["hostip"]
try:
tenginehost.objects.filter(host=hostip).delete()
hostdelerror = "删除主机成功"
except BaseException as e:
logger.error(e)
hostdelerror = "删除主机失败"
return HttpResponse(hostdelerror)
def varadd(self):
try:
confadd = compile_conf.objects.create(varname=self.var,
varpath=self.varpath,
varnameid=self.randnum)
confadd.save()
conferror = ("保存变量 %s 成功" % self.var)
except BaseException as e:
logger.error("编译环境配置失败，变量名称 %s 保存不成功" % self.var)
conferror = ("保存变量 %s 失败" % self.var)
return conferror
def selectadmminaddr(self):
try:
redistable = RedisHost.objects.filter(redis_ip__exact=self.redisip,redis_port__exact=self.redisport).values(
'admin_addr','admin_port')
redistablevalue = list(redistable)
admin_addr_link = "http://%s:%s/proxy/slots" % (redistablevalue[0]["admin_addr"],redistablevalue[0]["admin_port"])
except BaseException as e:
logger.error(e)
admin_addr_link = False
return admin_addr_link
def matchingdel(self,subnode):
nodeip = subnode.split(":")[0]
nodeport = subnode.split(":")[1]
try:
redisconn = RedisConn(nodeip, nodeport)
delkey = redisconn.matchingdelete(self.key)
except BaseException as e:
logger.error(e)
delkey = 0
delkeysum = dict(node=subnode, delkeysum=delkey)
return json.dumps(delkeysum)
def redisoper_get(self):
redisconn = RedisConn(self.proxyip,self.proxyport)
keyvalue = redisconn.exists(self.key)
if keyvalue is True:
try:
keyvalue = str(redisconn.get(self.key))
if keyvalue == None:
keyvalue = "KEY 不存在"
except BaseException as e:
logger.error("获取key %s ,ERROR:%s" % (self.key,e))
keyvalue = "ERROR:获取key值出错"
return keyvalue
else:
keyvalue = "ERROR:key 不存在"
return keyvalue
def userupdate(self):
try:
usertable = users.objects.filter(username=self.username).update(
mobile=self.mobile,
email=self.email,
password=self.passwd,
roleid=self.roleid
)
usertable.save()
usererror = "用户更新成功"
except BaseException as e:
logger.error(e)
usererror = "用户更新失败"
return HttpResponse(usererror)
def redisadd(request):
Description = "添加缓存地址"
if request.method == "POST":
redis = request.body
redisinfo = json.loads(redis)
proxy_name = redisinfo[0]["proxy_name"]
proxy_ip = redisinfo[0]["proxy_ip"]
proxy_port = redisinfo[0]["proxy_port"]
admin_ip = redisinfo[0]["admin_ip"]
admin_port = redisinfo[0]["admin_port"]
typeid = redisinfo[0]["typeid"]
typename = redisinfo[0]["typename"]
owner = redisinfo[0]["owner"]
principal = redisinfo[0]["principal"]
username = request.session.get('username')
try:
redishost = RedisHost.objects.filter(redis_ip__exact=proxy_ip).filter(redis_port__exact=proxy_port)
if len(list(redishost)) == 0:
try:
redistable = RedisHost.objects.create(redis_ip=proxy_ip,redis_port=proxy_port,proxy_name=proxy_name,admin_addr=admin_ip,admin_port=admin_port,
typeid=typeid,typename=typename,project_owner=owner,project_principal=principal)
redistable.save()
rediserror = "添加缓存 %s:%s 成功" % (proxy_ip,proxy_port)
RecordLog(username=username, recordclass=Description, recordvalue=rediserror).saveecord()
except BaseException as e:
logger.error(e)
rediserror = "添加缓存 %s:%s 失败" % (proxy_ip, proxy_port)
RecordLog(username=username, recordclass=Description, recordvalue=rediserror).saveecord()
else:
rediserror = "缓存地址已存在无需重复添加"
except BaseException as e:
logger.error(e)
rediserror = "数据库查询失败"
return HttpResponse(rediserror)
else:
return render_to_response('codis-add.html')
def grayaddphone(self, username, expirytime, createtime):
try:
addphone = grayphone.objects.create(
phone=self.phone,
phoneencrypt=self.graymd5value(),
online=self.phoneonline(),
expirytime=expirytime,
createuser=username,
createtime=createtime)
addphone.save()
addstatus = "添加手机号码 %s 成功" % self.phone
except BaseException as e:
logger.error(e)
addstatus = "添加手机号码 %s 失败" % self.phone
return addstatus
def useradd(self):
try:
usertable = users.objects.create_user(
username=self.username,
mobile=self.mobile,
email=self.email,
password=self.passwd,
roleid=self.roleid
)
usertable.save()
useradderror = "用户添加成功"
except BaseException as e:
logger.error(e)
useradderror = "用户添加失败"
return useradderror
def redisoper_del(self):
redisconn = RedisConn(self.proxyip, self.proxyport)
keyvalue = redisconn.exists(self.key)
if keyvalue is True:
try:
keyvalue = str(redisconn.delete(self.key))
if keyvalue == "None":
keyvalue = "节点 %s 清除key %s 成功" % (self.proxyip, self.key)
except BaseException as e:
logger.error("删除key %s ,ERROR:%s" % (self.key, e))
keyvalue = "ERROR:删除key值出错"
return keyvalue
else:
keyvalue = "ERROR:key 不存在"
return keyvalue
def addrole(self):
roleidnum = "1" + "".join(
map(lambda x: random.choice(string.digits), range(7)))
try:
roletable = role.objects.create(roleid=roleidnum,
Rolename=self.rolename)
roletable.save()
for permissionid in self.permissionudnum:
permissiontable = permission.objects.create(
permission_id=permissionid, roleid=roleidnum)
permissiontable.save()
addroleerror = "角色添加成功"
except BaseException as e:
logger.error(e)
addroleerror = "角色添加失败"
return addroleerror
def redisupdate(request):
Description = "更新缓存地址"
username = request.session.get('username')
if request.method == "POST":
redis = request.body
redisinfo = json.loads(redis)
rowid = redisinfo[0]["rowid"]
proxy_name = redisinfo[0]["proxy_name"]
ip = redisinfo[0]["ip"]
port = redisinfo[0]["port"]
typeid = redisinfo[0]["typeid"]
typename = redisinfo[0]["typename"]
owner = redisinfo[0]["owner"]
principal = redisinfo[0]["principal"]
try:
RedisHost.objects.filter(id=rowid).update(redis_ip=ip,redis_port=port,proxy_name=proxy_name,
typeid=typeid,typename=typename,project_owner=owner,project_principal=principal)
rediserror = "缓存信息更新成功"
RecordLog(username=username, recordclass=Description, recordvalue=rediserror).saveecord()
except BaseException as e:
logger.error(e)
rediserror = "缓存信息更新失败"
RecordLog(username=username, recordclass=Description, recordvalue=rediserror).saveecord()
return HttpResponse(rediserror)
else:
redisinfo = []
rowid = request.GET["rowid"]
redistable = RedisHost.objects.filter(id=rowid).values()
for redis in redistable:
redisinfo.append(redis)
return render_to_response('codis-edit.html',{"redisinfo":redisinfo})
def hostupdate(request):
if request.method == "POST":
host = request.body
hostinfo = json.loads(host)
hostname = hostinfo[0]["hostname"]
hostip = hostinfo[0]["hostip"]
hostport = hostinfo[0]["hostport"]
project_owner = hostinfo[0]["project_owner"]
idc_name = hostinfo[0]["idc_name"]
try:
ansible_host.objects.filter(hostip__exact=hostip).update(hostip=hostip,hostport=hostport,hostname=hostname,
project_owner=project_owner,idc_name=idc_name)
hosterror = "主机信息更新成功"
except BaseException as e:
logger.error(e)
hosterror = "主机信息更新失败"
return HttpResponse(hosterror)
else:
return render_to_response('host-list.html')
