注意1、需要用到第三方库 pandas 、requests
注意2、test_http.xlsx文件和当前目录保持在同一目录,如果不同目录使用//文件名
import pandas as pd
from http_request.http_request import HttpRequest
#打开Excel
df = pd.read_excel('test_http.xlsx')
data = df.values
print('打印第一个sheet')
for i in data:
print('目前的测试的用例{}:{}'.format(i[0],i[1]))
# res = HttpRequest.http_request(i[2],eval(i[3]),i[4]).text
try :
res = HttpRequest.http_request(i[2],eval(i[3]),i[4]).json()
print('json格式')
except :
print('不是json格式')
res = HttpRequest.http_request(i[2], eval(i[3]), i[4]).text
# print('执行结果:{}'.format(res))
if res == i[5] :
print('执行案例成功')
else :
print('执行案例失败')
print()
类调用
import requests
class HttpRequest:
'''访问http借接口,返回数据'''
@classmethod
def http_request(cal,url, data, http_method='POST'):
if http_method.upper() == 'GET':
res = requests.get(url, data)
else:
res = requests.post(url, data)
return res