# @Time    : 2022/10/31 18:14
# @Author  : 付孟奇
from util.HandleFile import load_yaml_file
from util.HandleDB import db_load
from config.VendorPath import base_path, global_path
import os
import json

ddl_file_path = os.path.join(base_path, 'sql', 'speech_variable.yaml')


class InitLoad:
    def __init__(self):
        print('111')

    # 初始化数据库
    def db_ini(self):
        # 加载数据库建表SQL
        res_yaml = load_yaml_file(ddl_file_path)
        # 执行插入SQL
        db_load.execute_db(res_yaml)
        self.handle_global()

    # 清空公共参数文件内容
    def handle_global(self):
        data = {}
        json.dump(data, open(global_path, 'w'), indent=4)


handle_init = InitLoad()
if __name__ == '__main__':
    handle_init.handle_global()