ourdaidai · October 13, 2020 07:03 · Oct 13, 2020 · Aug 28, 2020 · Aug 28, 2020
diff --git a/config_logging_mysql.py b/config_logging_mysql.py
@@ -30,7 +30,7 @@
             logging.error(res)
 
 config_path = os.path.dirname(os.path.abspath(__file__))+'/config.json'
-# config_file = json.load(open(config_path))
+# config_file = json.load(open(config_path, 'r', encoding='utf-8'))
 config_file = {
             "graph_host": "",
             "graph_port": "8182",

diff --git a/config_logging_mysql.py b/config_logging_mysql.py
@@ -0,0 +1,57 @@
+# -*- coding: utf-8 -*-
+"""
+Created on Fri Aug 28 10:06:04 2020
+
+@author: tangliang
+"""
+
+import pymysql
+import pandas as pd
+from tqdm import tqdm
+import time
+import datetime
+import os
+import json
+import logging
+import re
+
+
+LOG_FORMAT = "%(asctime)s %(name)s %(levelname)s %(pathname)s %(message)s "  # 配置输出日志格式
+DATE_FORMAT = '%Y-%m-%d  %H:%M:%S %a '  # 配置输出时间的格式，注意月份和天数不要搞乱了
+logging.basicConfig(level=logging.DEBUG,
+                    format=LOG_FORMAT,
+                    datefmt=DATE_FORMAT,
+                    )
+
+        try:
+            res = self.__parse_json(res['result']['data'])
+        except Exception as e:
+            logging.error('__parse_json 出错: {}'.format(e))
+            logging.error(res)
+
+config_path = os.path.dirname(os.path.abspath(__file__))+'/config.json'
+# config_file = json.load(open(config_path))
+config_file = {
+            "graph_host": "",
+            "graph_port": "8182",
+            "mysql_host": "",
+            "mysql_user": "",
+            "mysql_password": ""
+            }
+configs = {"mysql_port":3306}
+configs.update(config_file)
+
+
+def mysql_connect(database: str):
+    IP = configs["mysql_host"]
+    # IP = '127.0.0.1'
+    # user = ''
+    # password = ''
+    user = configs["mysql_user"]
+    password = configs["mysql_password"]
+    database = database
+    port = int(configs["mysql_port"])
+    conn = pymysql.connect(host=IP, user=user, password=password, db=database, port=port)
+    return conn
+
+