使用Python将采集到的数据实现批量入库到MySQL中

业务需求以及表格式请参考上一篇文章shell批量入库

使用shell将采集到的数据实现批量入到MySQL数据库中

实现程序如下

import  MySQLdb

db = MySQLdb.connect(host='dbhost',user='user',passwd='passwd',db='db',charset='utf8')
cursor = db.cursor()

with open("E:/mysqltest.txt",'r') as f:
    line = f.readline().strip()
    while line:
        linestr = line.split(",")
        #print(linestr[0])
        line = f.readline().strip()
        sql="insert into ccp_mon_rm_secdata(date_time,server_ip,caps_num,dea_time,que_num,cms_num) values (%s,%s,%s,%s,%s,%s)"
        row_count=cursor.execute(sql,[linestr[0],linestr[1],linestr[2],linestr[3],linestr[4],linestr[5]])
db.commit()
cursor.close()
db.close()