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')