如何构建Python3 Requests结合Excel的自动化接口测试框架？

本文共计381个文字，预计阅读时间需要2分钟。

框架整体使用Python3+Requests+Excel：- 包含对实时token的获取- base/runmethod.py：runmethod.py- 对不同的请求方式进行封装- 导入json- 导入requests- requests.packages.urllib3.disable_warnings()

框架整体使用Python3+Requests+Excel：包含对实时token的获取

1、------base

　　-------runmethond.py

　runmethond：对不同的请求方式进行封装

import json import requests requests.packages.urllib3.disable_warnings() class RunMethod: def post_main(self, url, data, header=None): res = None if header != None: res = requests.post(url=url, data=data, headers=header,verify=False) else: res = requests.post(url=url, data=data,verify=False) return res.json() def get_main(self, url, data=None, header=None): res = None if header != None: res = requests.get(url=url, params=data, headers=header, verify=False) else: res = requests.get(url=url, params=data, verify=False) return res.json() def run_main(self, method, url, data=None, header=None): res = None if method == ‘Post‘: res = self.post_main(url, data, header) else: res = self.get_main(url, data, header) return json.dumps(res, indent=2, sort_keys=True, ensure_ascii=False) if __name__ == ‘__main__‘: url = ‘xxxxx" data = { "username": "1111", "password": "123456" } run_method=RunMethod() # res = json.dumps(requests.post(url, data).json()) res=run_method.run_main(‘Post‘, url, data) op = OperationHeader(res) op.write_token()

12、-----util

　　-----operation_json.py

　　operation_json：操作json文件

import json class OperationJson: """操作json文件""" def __init__(self,file_path=None): if file_path==None: self.file_path="../dataconfig/data.json" else: self.file_path=file_path self.data = self.read_data() def read_data(self): """ 读取json文件 :param file_name:文件路径 :return: """ with open(self.file_path) as fp: data = json.load(fp) return data def get_data(self, id): """根据关键字获取对应数据""" return self.data[id] # 写入json def write_data(self, data): with open("../dataconfig/token.json", ‘w‘) as fp: fp.write(json.dumps(data)) if __name__ == ‘__main__‘: # file_path = "../dataconfig/data.json" opejson = OperationJson() print(opejson.read_data()) print(opejson.get_data(‘filtrate‘))