python-读取yaml配置文件

python-读取yaml配置文件

1. python-读取yaml配置文件

• yaml配置文件

1. • 目前主流的配置文件格式采用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()