import requests
# noinspection PyUnresolvedReferences
import json
# noinspection PyUnresolvedReferences
import openpyxl
from openpyxl import load_workbook
wb = load_workbook("D:/test/interface.xlsx")
sh = wb["Sheet1"]
row = sh.max_row
column = sh.max_column
for row in range(2,row+1):
url = sh.cell(row=row,column=5).value
data = sh.cell(row=row,column=6).value
qiwang=sh.cell(row=row ,column=7).value
data = json.loads(data)
method = sh.cell(row=row,column=4).value
if method == "get":
reponse =requests.get(url,data)
reponse=reponse.json()
# print(reponse.text)
elif method=="post":
data=json.dumps(data)
header = {"Content-type": "application/json"}
reponse=requests.post(url=url,data=data,headers=header)
reponse=reponse.json()
try:
assert eval(qiwang)==reponse
print(row,"测试通过")
print("预期结果:",qiwang)
except:
print("期望结果:",qiwang)
print("实际结果:",reponse)
sh.cell(row=row, column=8).value = "测试不通过"
wb.save("D:/test/interface.xlsx")
print(row,"测试不通过")
简单的接口自动化脚本
最新推荐文章于 2024-05-27 19:31:11 发布