def get_srvlist():
#sql = 'select * from servers'
mysql = mysqlUtil.DB(user='******',password='******',host='192.168.31.2',db='cmdb')
sql = 'select s.id,s.ip,s.hostname,s.username,s.password,s.idc_id,s.remarks,s.create_time,i.name from idc i,servers s where s.idc_id = i.id'
srv_list = mysql.execute(sql)
#srv_list = mysql_util(sql)
return srv_list
def select_idc_by_id(idc_id):
#print '---------------------------------------'
#print idc_id
mysql = mysqlUtil.DB(user='******',password='******',host='192.168.31.2',db='cmdb')
sql = 'select * from idc where id=%s' %(idc_id)
# idc_list = mysql_util(sql)
idc_list = mysql.execute(sql)
return idc_list
def update_srv_by_id(srv_id,srv_ip,srv_hostname,srv_username,srv_password,srv_idcid,srv_remarks,srv_ctime):
mysql = mysqlUtil.DB(user='******',password='******',host='192.168.31.2',db='cmdb')
sql = 'update servers set ip="%s",hostname="%s",username="******",password="******",idc_id=%s,remarks="%s",create_time="%s" where id=%s' %(srv_ip,srv_hostname,srv_username,srv_password,srv_idcid,srv_remarks,srv_ctime,srv_id)
#mysql_util(sql)
mysql.execute(sql)
return 'ok'
def select_srv_by_id(srv_id):
mysql = mysqlUtil.DB(user='******',password='******',host='192.168.31.2',db='cmdb')
sql = 'select * from servers where id=%s' %(srv_id)
#srv_list = mysql_util(sql)
srv_list = mysql.execute(sql)
return srv_list
def del_srv(srv_id):
mysql = mysqlUtil.DB(user='******',password='******',host='192.168.31.2',db='cmdb')
sql = 'delete from servers where id=%s' %(srv_id)
#mysql_util(sql)
mysql.execute(sql)
return 'ok'
def add_srv(srv_ip,srv_hostname,srv_username,srv_password,srv_idcid,srv_remarks,srv_ctime):
mysql = mysqlUtil.DB(user='******',password='******',host='192.168.31.2',db='cmdb')
sql = 'insert into servers (ip,hostname,username,password,idc_id,remarks,create_time) values ("%s","%s","%s","%s",%s,"%s","%s")' %(srv_ip,srv_hostname,srv_username,srv_password,srv_idcid,srv_remarks,srv_ctime)
#mysql_util(sql)
mysql.execute(sql)
return 'ok'
def update_idc_by_id(idc_id,idc_name,idc_address,idc_contacts):
mysql = mysqlUtil.DB(user='******',password='******',host='192.168.31.2',db='cmdb')
sql = 'update idc set name="%s",address="%s",contacts="%s" where id=%s' %(idc_name,idc_address,idc_contacts,idc_id)
mysql.execute(sql)
return 'ok'
def del_idc(idc_id):
mysql = mysqlUtil.DB(user='******',password='******',host='192.168.31.2',db='cmdb')
sql = 'delete from idc where id=%s' %(idc_id)
mysql.execute(sql)
return 'ok'
def add_idc(name='default',address='default',contacts='default'):
mysql = mysqlUtil.DB(user='******',password='******',host='192.168.31.2',db='cmdb')
sql = 'insert into idc (name,address,contacts) values ("%s","%s","%s")' %(name,address,contacts)
mysql.execute(sql)
return 'ok'
def get_idclist():
mysql = mysqlUtil.DB(user='******',password='******',host='192.168.31.2',db='cmdb')
sql = 'select * from idc'
idc_list = mysql.execute(sql)
return idc_list