From d99d235123d43825f35cdc4c8cb49339d9651056 Mon Sep 17 00:00:00 2001
From: zmc <zmc_li@foxmail.com>
Date: 星期五, 22 十二月 2023 11:56:13 +0800
Subject: [PATCH] 1.修改了创建连接数据库引擎时的方言类型 2.修改了爬取数据的逻辑以及相关的异常分析代码
---
src/write_to_minute_table.py | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/src/write_to_minute_table.py b/src/write_to_minute_table.py
index 42a0f9d..a5d9b69 100644
--- a/src/write_to_minute_table.py
+++ b/src/write_to_minute_table.py
@@ -16,7 +16,7 @@
temp.append(list[7]) #鍑�鍖栧櫒鐢垫祦 7
temp.append(list[4]) #杩涙补鐑熸祿搴﹀��
temp.append(list[5]) #鎺掓补鐑熸祿搴﹀��
- temp.append(list[14]) #閲嶅鐨勬鏁�
+ temp.append(list[13]) #閲嶅鐨勬鏁�
print(temp)
return temp
@@ -51,12 +51,12 @@
fd_t_minbute(has_remove_duplicates,con) #灏嗘寚瀹氶〉鏁版暟鎹啓鍏ユ暟鎹簱鍒嗛挓鏁版嵁琛ㄤ腑
-engine = create_engine("mysql+mysqlconnector://root:1234@localhost:3306/fume?charset=utf8")
+engine = create_engine("mysql+pymysql://fumeRemote:feiyu2023@114.215.109.124:3306/fume?charset=utf8")
# 涓撻棬璇诲彇璁惧淇℃伅琛�
con_read = engine.connect()
def write(data):
- engine = create_engine("mysql+mysqlconnector://root:1234@localhost:3306/fume?charset=utf8")
+ engine = create_engine("mysql+pymysql://fumeRemote:feiyu2023@114.215.109.124:3306/fume?charset=utf8")
con = engine.connect()
write_all(data,con)
con.close()
--
Gitblit v1.9.3