# -*- 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, 'r', encoding='utf-8'))
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