python读取测试数据的多种方式

[api]
url = www.taobao.com
method = get
[mysql]
db=hello
port=3306

from configparser import ConfigParser
import os
conn=ConfigParser()
#获取ini文件的路径
file_path = os.path.join(os.path.abspath('.'),'config.ini')
conn.read(file_path)
url=conn.get('api','url')
method=conn.get('api','method')
port=conn.get('mysql','port')
print(url,method,port)

-
  caseid: 1
  method: post
  title: 正常登录
  url: api/v1/login
  data:
 username: test
 password: 123456
  headers:
 Content-Type: application/json
 User-Agent: Mozilla/5.0
  expected: 0

import yaml
def read_file(file_path):
 with open(file_path, 'r', encoding='utf-8') as f:
 res = yaml.load(f,Loader=yaml.FullLoader)
 return res
if __name__ == '__main__':
 d = read_file(r'..\test_data\login\login_data.yml')
 print(d)

import pandas
def excel_to_dic(filename):
 df = pandas.read_excel(filename)
 data_list = []
 for i in df.index.values:
  data = df.iloc[i, [j for j in range(len(df.keys()))]].to_dict()
  data_list.append(data)
 return data_list
if __name__ == '__main__':
 file = r'C:\aaa.xlsx'#之前创建的文件地址
 data = excel_to_dic(file)
 print(data)