def room_list(): db = MysqlServer(settings.DATABASES) sql = "select `rid`,`idcname`,`contact`,`phone`,`comments` from zc_idc" sql_count = "select zc_idc.rid,count(zc_machine.serverip) from zc_machine right join zc_idc on zc_idc.rid = zc_machine.rid group by zc_idc.rid" result = db.run_sql(sql) result_count = db.run_sql(sql_count) db.close() return result, result_count
def room_list(): db = MysqlServer(settings.DATABASES) sql = "select `rid`,`idcname`,`contact`,`phone`,`comments` from zc_idc" sql_count = "select zc_idc.rid,count(zc_machine.serverip) from zc_machine right join zc_idc on zc_idc.rid = zc_machine.rid group by zc_idc.rid" result = db.run_sql(sql) result_count = db.run_sql(sql_count) db.close() return result, result_count
def distribute_host(self): db = MysqlServer(settings.DATABASES) sql = "select zc_service.`sid`, zc_service.`sname`, count(*) from zc_machine left join zc_service on \ zc_machine.service = zc_service.sid group by service" sql_count = "select count(*) from zc_machine" result = db.run_sql(sql) result_count = db.run_sql(sql_count) db.close() return result, result_count
def distribute_host(self): db = MysqlServer(settings.DATABASES) sql = "select zc_service.`sid`, zc_service.`sname`, count(*) from zc_machine left join zc_service on \ zc_machine.service = zc_service.sid group by service" sql_count = "select count(*) from zc_machine" result = db.run_sql(sql) result_count = db.run_sql(sql_count) db.close() return result, result_count
def add_host_select(self): db = MysqlServer(settings.DATABASES) sql_idc = "select `rid`,`idcname` from zc_idc" sql_project = "select `sid`,`sname` from zc_service" sql_contact = "select `ccid`,`cname` from zc_contact" sql_status = "select `mstatus` from zc_machine group by `mstatus`" result_idc = db.run_sql(sql_idc) result_project = db.run_sql(sql_project) result_contact = db.run_sql(sql_contact) result_status = db.run_sql(sql_status) db.close() return result_idc, result_project, result_contact, result_status
def add_host_select(self): db = MysqlServer(settings.DATABASES) sql_idc = "select `rid`,`idcname` from zc_idc" sql_project = "select `sid`,`sname` from zc_service" sql_contact = "select `ccid`,`cname` from zc_contact" sql_status = "select `mstatus` from zc_machine group by `mstatus`" result_idc = db.run_sql(sql_idc) result_project = db.run_sql(sql_project) result_contact = db.run_sql(sql_contact) result_status = db.run_sql(sql_status) db.close() return result_idc, result_project, result_contact, result_status
def search_hosts(result): db = MysqlServer(settings.DATABASES) sql = ( "select `serverip`,`publicip`,`idcname`,`memsize`,`cpunum`,`disksize`,`serverrack`,`sn`, \ `stype`,`os`,`sname`,`mstatus`,`cname`,`cinfo`,`comment`,zc_machine.`mid` from zc_machine left join \ zc_idc on zc_machine.rid = zc_idc.rid left join zc_service on zc_machine.service = zc_service.sid \ left join zc_contact on zc_machine.ccid = zc_contact.ccid where serverip like '%%%s%%' and publicip like \ '%%%s%%' and zc_machine.rid like '%%%s%%' and memsize like '%%%s%%' and cpunum \ like '%%%s%%' and disksize like '%%%s%%' and serverrack like '%%%s%%' and sn like '%%%s%%' and stype like \ '%%%s%%' and os like '%%%s%%' and service like '%%%s%%' and mstatus like '%%%s%%' and zc_machine.ccid like '%%%s%%' and \ comment like '%%%s%%'" % ( result["server_ip"], result["public_ip"], result["idc_name"], result["mem_size"], result["cpu_num"], result["disk_size"], result["server_rack"], result["sn"], result["server_type"], result["os"], result["project_name"], result["server_status"], result["server_contact"], result["comment"], ) ) result = db.run_sql(sql) db.close() return result
def get_room_modify(result): db = MysqlServer(settings.DATABASES) sql = "select `idcname`,`contact`,`phone`,`comments` from zc_idc where rid=%d" % int( result) result = db.run_sql(sql) db.close() return result
def user_modify(result): db = MysqlServer(settings.DATABASES) sql = "select `uid`,`username`,`userpassword`,`rolename` from zc_user left join zc_role on \ zc_user.rid = zc_role.id where uid='%d'" % int(result) result = db.run_sql(sql) db.close() return result
def user_modify(result): db = MysqlServer(settings.DATABASES) sql = "select `uid`,`username`,`userpassword`,`rolename` from zc_user left join zc_role on \ zc_user.rid = zc_role.id where uid='%d'" % int(result) result = db.run_sql(sql) db.close() return result
def user_list(self): db = MysqlServer(settings.DATABASES) sql = "select `uid`,`username`,`userpassword`,`rolename` from zc_user left join zc_role on \ zc_user.rid = zc_role.id" result = db.run_sql(sql) db.close() return result
def user_list(self): db = MysqlServer(settings.DATABASES) sql = "select `uid`,`username`,`userpassword`,`rolename` from zc_user left join zc_role on \ zc_user.rid = zc_role.id" result = db.run_sql(sql) db.close() return result
def machine_list(self): db = MysqlServer(settings.DATABASES) sql = "select `serverip`,`publicip`,`idcname`,`memsize`,`cpunum`,`disksize`,`serverrack`,`sn`, \ `stype`,`os`,`sname`,`mstatus`,`cname`,`cinfo`,`comment`,zc_machine.`mid` from zc_machine left join zc_idc on zc_machine.rid = zc_idc.rid \ left join zc_service on zc_machine.service = zc_service.sid left join zc_contact on \ zc_machine.ccid = zc_contact.ccid" result = db.run_sql(sql) db.close() return result
def modify_host(result): db = MysqlServer(settings.DATABASES) sql = "select `serverip`,`publicip`,`idcname`,`memsize`,`cpunum`,`disksize`,`serverrack`,`sn`, \ `stype`,`os`,`sname`,`mstatus`,`cname`,`cinfo`,`comment`,zc_machine.`mid` from zc_machine left join zc_idc on zc_machine.rid = zc_idc.rid \ left join zc_service on zc_machine.service = zc_service.sid left join zc_contact on \ zc_machine.ccid = zc_contact.ccid where mid='%s'" % result result = db.run_sql(sql) db.close() return result
def search_hosts_quick(result): db = MysqlServer(settings.DATABASES) sql = ( "select `serverip`,`publicip`,`idcname`,`memsize`,`cpunum`,`disksize`,`serverrack`,`sn`, \ `stype`,`os`,`sname`,`mstatus`,`cname`,`cinfo`,`comment`,zc_machine.`mid` from zc_machine left join \ zc_idc on zc_machine.rid = zc_idc.rid left join zc_service on zc_machine.service = zc_service.sid \ left join zc_contact on zc_machine.ccid = zc_contact.ccid where serverip like '%%%s%%'" % result ) result = db.run_sql(sql) db.close() return result
def search_hosts(result): db = MysqlServer(settings.DATABASES) sql = "select `serverip`,`publicip`,`idcname`,`memsize`,`cpunum`,`disksize`,`serverrack`,`sn`, \ `stype`,`os`,`sname`,`mstatus`,`cname`,`cinfo`,`comment`,zc_machine.`mid` from zc_machine left join \ zc_idc on zc_machine.rid = zc_idc.rid left join zc_service on zc_machine.service = zc_service.sid \ left join zc_contact on zc_machine.ccid = zc_contact.ccid where serverip like '%%%s%%' and publicip like \ '%%%s%%' and zc_machine.rid like '%%%s%%' and memsize like '%%%s%%' and cpunum \ like '%%%s%%' and disksize like '%%%s%%' and serverrack like '%%%s%%' and sn like '%%%s%%' and stype like \ '%%%s%%' and os like '%%%s%%' and service like '%%%s%%' and mstatus like '%%%s%%' and zc_machine.ccid like '%%%s%%' and \ comment like '%%%s%%'" % ( result["server_ip"], result["public_ip"], result["idc_name"], result["mem_size"], result["cpu_num"], result["disk_size"], result["server_rack"], result["sn"], result["server_type"], result["os"], result["project_name"], result["server_status"], result["server_contact"], result['comment']) result = db.run_sql(sql) db.close() return result
def add_contact_check(result): db = MysqlServer(settings.DATABASES) sql = "select `cname` from zc_contact where cname='%s'" % result result = db.run_sql(sql) db.close() return result
def add_host_check(result): db = MysqlServer(settings.DATABASES) sql = "select `serverip` from zc_machine where serverip='%s'" % result result = db.run_sql(sql) db.close() return result
def get_contact_list(): db = MysqlServer(settings.DATABASES) sql = "select `ccid`,`cname`,`cinfo` from zc_contact" result = db.run_sql(sql) db.close() return result
def add_project_check(result): db = MysqlServer(settings.DATABASES) sql = "select `sname` from zc_service where sname='%s'" % result result = db.run_sql(sql) db.close() return result
def get_project_list(): db = MysqlServer(settings.DATABASES) sql = "select zc_service.sid,zc_service.sname from `zc_service`" result = db.run_sql(sql) db.close() return result
def check_user_login(result): db = MysqlServer(settings.DATABASES) sql = "select `username`,`userpassword` from zc_user where username='******'" % result result = db.run_sql(sql) db.close() return result
def user_modify_check(result): db = MysqlServer(settings.DATABASES) sql = "select `username` from zc_user where username='******'" % result result = db.run_sql(sql) db.close() return result
def add_project_check(result): db = MysqlServer(settings.DATABASES) sql = "select `sname` from zc_service where sname='%s'" % result result = db.run_sql(sql) db.close() return result
def get_room_modify(result): db = MysqlServer(settings.DATABASES) sql = "select `idcname`,`contact`,`phone`,`comments` from zc_idc where rid=%d" % int(result) result = db.run_sql(sql) db.close() return result
def check_user_login(result): db = MysqlServer(settings.DATABASES) sql = "select `username`,`userpassword` from zc_user where username='******'" % result result = db.run_sql(sql) db.close() return result
def add_room_check(result): db = MysqlServer(settings.DATABASES) sql = "select `idcname` from zc_idc where idcname='%s'" % result result = db.run_sql(sql) db.close() return result
def add_host_check(result): db = MysqlServer(settings.DATABASES) sql = "select `serverip` from zc_machine where serverip='%s'" % result result = db.run_sql(sql) db.close() return result
def add_contact_check(result): db = MysqlServer(settings.DATABASES) sql = "select `cname` from zc_contact where cname='%s'" % result result = db.run_sql(sql) db.close() return result
def user_modify_check(result): db = MysqlServer(settings.DATABASES) sql = "select `username` from zc_user where username='******'" % result result = db.run_sql(sql) db.close() return result
def add_room_check(result): db = MysqlServer(settings.DATABASES) sql = "select `idcname` from zc_idc where idcname='%s'" % result result = db.run_sql(sql) db.close() return result
def get_contact_list(): db = MysqlServer(settings.DATABASES) sql = "select `ccid`,`cname`,`cinfo` from zc_contact" result = db.run_sql(sql) db.close() return result
def get_project_list(): db = MysqlServer(settings.DATABASES) sql = "select zc_service.sid,zc_service.sname from `zc_service`" result = db.run_sql(sql) db.close() return result