From ed135d79df12a2466b52dae1a82326941211dcc9 Mon Sep 17 00:00:00 2001
From: zmc <zmc_li@foxmail.com>
Date: 星期四, 12 十月 2023 17:00:18 +0800
Subject: [PATCH] 修改了连接远程数据库的方式
---
src/write_to_MySql.py | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/src/write_to_MySql.py b/src/write_to_MySql.py
index 445a007..3af97c9 100644
--- a/src/write_to_MySql.py
+++ b/src/write_to_MySql.py
@@ -434,12 +434,12 @@
Key_period_night_end = datetime.strptime('21:00',"%H:%M")
-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