import xlrd
from xlutils.copy import copy
import requests
import json
import xlwt
# 结果比较
def compareObj(expected, actual):
if expected != None:
if actual != None:
for key in expected:
if key not in actual:
return '预期结果key %s不在实际结果中'%(key)
else:
expected_value = expected[key]
actual_value=actual[key]
if expected_value == actual_value:
continue
else:
return 'key值%s:预期结果%s和实际结果%s不相等'%(key,expected_value,actual_value)
else:
return '实际结果为空'
else:
return '预期结果为空'
return True
url= 'http://localhost:1080/test'
file_name = 'D:\\test.xls'
data = xlrd.open_workbook(file_name)
sheet=data.sheets()[0]
wb=copy(data)
ws=wb.get_sheet(0)
for i in range(1,37):
params = sheet.cell(i,1).value
#print(params)
header = {"Content-Type":"application/json"}
res = requests.post(url = url,headers = header,data = params)
actual = res.json()["obj"]
expected = json.loads(sheet.cell(i,2).value)
result = compareObj(expected,actual)
#print(result)
style = xlwt.easyxf('pattern: pattern solid, fore_colour red')# 设置运行失败的单元格颜色
if result != True:
ws.write(i, 3, result,style)
else:
ws.write(i, 3, result)
for i in range(4):
ws.col(i).width = 256 * 50 #设置单元格宽度
wb.save(file_name)
