FilesExpand file tree

 master

/

dodb.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

39 lines (34 loc) · 1.05 KB

 master

/

dodb.py

Copy path

Top

File metadata and controls

• Code
• Blame

39 lines (34 loc) · 1.05 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

#!/usr/bin/env python

#_*_ coding:utf-8 _*_

import MySQLdb

with open('/var/logs/install.log') as f:

a = f.read().strip().split('\n')

hostl = []

for i in a:

b = i.split('\t')

if b[3] == 'stop':

hostl.append(b[1])

else:

pass

for host in list(set(hostl)):

conn= MySQLdb.connect(

host='localhost',

port = 3306,

user='root',

passwd='111111',

db ='pj_install',

)

try:

#select

sql = "select * from automsg where HostName='{0}'".format(host)

cur = conn.cursor()

cur.execute(sql)

ret = cur.fetchone()

#update

update_sql = "update installretmsg set status=2, msg=u'安装成功!' where id={0}".format(int(ret[0]))

cur.execute(update_sql)

cur.close()

conn.commit()

conn.close()

except:

pass