我正在做一个项目,ping局域网设备并将ping所花费的平均时间写入MySQL数据库。在
# Python script to update contents of MySQL database
import MySQLdb
import subprocess
import re
#Connecting to MySQL database
db = MySQLdb.connect("localhost","tempLocal","thunderbolt","dbavgspeed")
#initializing cursor
cur = db.cursor()
error = "Request"
while 1:
# 0.1 is the interval between pings and 4 is the number of times ping operation is performed and -t 1 sets the timeout to 1 sec
command1 = ['ping','-n','-i','0.1','-t','1','-c','400','192.168.1.1']
p1 = subprocess.Popen(command1,stdout=subprocess.PIPE)
#text is the string which stores the output from the terminal
text1 = p1.stdout.read()
if error in text1:
status1 = 0
cur.execute("""UPDATE tbavgspeed SET status = %s WHERE id = %s""",(status1,1))
db.commit()
else:
status1 = 1
find11 = re.search("stddev(.+?)ms", text1)
allValues1 = find11.group(1)
find12 = re.search("/(.+?)/", allValues1)
avgTime1 = find12.group(1)
cur.execute("""UPDATE tbavgspeed SET avg_time = %s, status = %s WHERE id = %s""",(avgTime1,status1,1))
db.commit()
#terminates the connection
db.close()
您可以使用
sudo
运行Python脚本。例如:没有
^{pr2}$sudo
:使用
sudo
:相关问题 更多 >
编程相关推荐