import os
import json
import pymysql


class MysqlConnect:

    def __new__(cls, *args, **kwargs):
        # 获取配置文件路径
        dir_path = os.path.split(os.path.split(__file__)[0])[0]
        config_path = os.path.join(dir_path, f"config{os.sep}config.json")
        with open(config_path, "r") as config_file:
            # 反序列化配置文件
            config = json.load(config_file)
        mysql_address = config.get("mysql", None)
        if not mysql_address:
            raise Exception("连接地址不存在或为空")
        return pymysql.connect(**mysql_address)