yaml

    """实例化连接一个数据库"""
    db_conf = yaml.load(open(ROOT_PATH + '/News/config/db.yaml', 'rb'), Loader=yaml.FullLoader).get(KIS_ENV)
    host = db_conf.get('host')
    user = db_conf.get('user')
    password = db_conf.get('password')
    port = db_conf.get('port')
    database = db_conf.get('database')
    try:
        self.db = pymysql.connect(host=host, user=user, password=password, database=database, port=port,
                                  cursorclass=pymysql.cursors.DictCursor)
    except Exception as e:
        print('数据库连接异常: ', e)
    self.cursor = self.db.cursor()