python-读取yaml配置文件
1. python-读取yaml配置文件
- yaml配置文件
-
- 目前主流的配置文件格式采用yml的
- pip3 install pyyaml, python3读取yml的配置需要安装pyyaml
- 一般来说,在linux上安装完一个模块后,pycharm要重启一下
-
编写yaml的config.yml文件
mysql: host: 127.0.0.1 port: 3306 user: test password: Test@963852 db: test
-
编写读取文件的pymysql程序
#!/usr/bin/env python3 # _*_ coding: utf-8 _*_ # Author:shichao # File: .py import pymysql import yaml with open('config.yml',mode='r') as f: result = yaml.load(f, Loader=yaml.FullLoader) mysqlresult = result['mysql'] conn = pymysql.connect(host=mysqlresult['host'], port=mysqlresult['port'], user=mysqlresult['user'], password=mysqlresult['password'], db=mysqlresult['db'], charset='utf8', cursorclass=pymysql.cursors.DictCursor) try: with conn.cursor() as cursor: # 读取一条记录 sql = "select id,username,password from user" cursor.execute(sql) result = cursor.fetchone() print(result) finally: conn.close()