python脚本读取文件数据写入mysql

import json
import codecs
import pymysql
import os
from datetime import datetime, date, timedelta
yesterday = (date.today() + timedelta(days = -1)).strftime("%Y%m%d")
filename = "visualplat_ecology_day."
fileName = filename + yesterday
#fileName = "visualplat_ecology_day.20200726"
db = pymysql.connect(
      host='127.0.0.1',
      port=3306,
      user='root',
      passwd='xxxxxxxxxxx',
      db='xxxxxxxxxx',
     charset='utf8'
 )
 if os.path.exists(fileName):
     with open(fileName,"r")as f:
         line = f.readlines()
     for lines in line:
         a = lines.split()
         c = a[0:1]
        d = a[1:2]
        b = a[2:3]
        e = a[3:4]
        f = a[4:5]
         cur = db.cursor()
         sql = "insert into pv (user,product,status,pv,date) values(%s,%s,%s,%s,%s)"
         try:
            cur.execute(sql,(d,b,e,f,c))
             print(sql)
             db.commit()
        except BaseException as e:
             print('error', e)
 else:
     print('文件不存在')
 db.close()

测试代码，具体根据实际类型区分更改