-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathidc_util.py
81 lines (69 loc) · 3.3 KB
/
idc_util.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
#import MySQLdb as mysql
import mysqlUtil
#def mysql_util(sql):
# conn = mysql.connect(user='cmdb',passwd='ming',host='192.168.31.2',db='cmdb',charset='utf8')
# cur = conn.cursor()
# cur.execute(sql)
# fetch_all = cur.fetchall()
# cur.close()
# conn.commit()
# return fetch_all
def get_idclist():
mysql = mysqlUtil.DB(user='cmdb',password='ming',host='192.168.31.2',db='cmdb')
sql = 'select * from idc'
idc_list = mysql.execute(sql)
return idc_list
def add_idc(name='default',address='default',contacts='default'):
mysql = mysqlUtil.DB(user='cmdb',password='ming',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 del_idc(idc_id):
mysql = mysqlUtil.DB(user='cmdb',password='ming',host='192.168.31.2',db='cmdb')
sql = 'delete from idc where id=%s' %(idc_id)
mysql.execute(sql)
return 'ok'
def select_idc_by_id(idc_id):
#print '---------------------------------------'
#print idc_id
mysql = mysqlUtil.DB(user='cmdb',password='ming',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_idc_by_id(idc_id,idc_name,idc_address,idc_contacts):
mysql = mysqlUtil.DB(user='cmdb',password='ming',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 get_srvlist():
#sql = 'select * from servers'
mysql = mysqlUtil.DB(user='cmdb',password='ming',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 add_srv(srv_ip,srv_hostname,srv_username,srv_password,srv_idcid,srv_remarks,srv_ctime):
mysql = mysqlUtil.DB(user='cmdb',password='ming',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 del_srv(srv_id):
mysql = mysqlUtil.DB(user='cmdb',password='ming',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 select_srv_by_id(srv_id):
mysql = mysqlUtil.DB(user='cmdb',password='ming',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 update_srv_by_id(srv_id,srv_ip,srv_hostname,srv_username,srv_password,srv_idcid,srv_remarks,srv_ctime):
mysql = mysqlUtil.DB(user='cmdb',password='ming',host='192.168.31.2',db='cmdb')
sql = 'update servers set ip="%s",hostname="%s",username="%s",password="%s",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'