刘一辰的软件工程随笔
import time
import datetime
import traceback
from selenium.webdriver import Chrome,ChromeOptions
import pymysql
def update_daily():
cursor = None
conn = None
try:
context = get_daily()
print(f'{datetime.datetime.now()} 开始更新当日数据')
conn,cursor = get_conn()
sql = 'insert into daily_data(time,now_confirm,confirm,dead,heal) values(%s,%s,%s,%s,%s)'
cursor.execute(sql,[context[0],context[1],context[2],context[3],context[4]])
conn.commit()
print(f'{datetime.datetime.now()} 数据更新完毕')
except:
traceback.print_exc()
finally:
close_conn(conn,cursor)
浙公网安备 33010602011771号