def write_report(self, url, params, expect, actual, flag):
open_file = Tool.read_excel("report")
table = open_file.sheets()[0]
n = table.nrows
wb = copy(open_file)
write_sheet = wb.get_sheet(0)
params = json.dumps(params, ensure_ascii=False) # 默认不将中文编码
# print("写报告测试参数", params)
expect = json.dumps(expect, ensure_ascii=False)
expect = Tool.json_converted_str(expect)
# print("写报告期望结果", expect)
actual = json.dumps(actual, ensure_ascii=False)
actual = Tool.json_converted_str(actual)
# print("写报告实际结果", actual)
style = xlwt.easyxf('align: wrap on') # 数据写入excel自动换行
write_sheet.col(2).width = (30 * 367)
write_sheet.col(3).width = (30 * 367)
write_sheet.write(n, 0, url)
write_sheet.write(n, 1, params)
write_sheet.write(n, 2, expect, style)
write_sheet.write(n, 3, actual, style)
# result_sheet.write(0, 1, txt1.decode('utf-8'))
if flag == 1:
write_sheet.write(n, 4, u"测试通过")
print("测试通过")
else:
write_sheet.write(n, 4, u"测试失败")
print("测试失败")
wb.save(r"../test_report/report.xls")
def write_report(self,url, interface_name,interface_description,params, expect, actual, flag):
open_file = Tool.read_excel("report")
table = open_file.sheets()[0]
n = table.nrows
wb = copy(open_file)
write_sheet = wb.get_sheet(0)
params = json.dumps(params, ensure_ascii=False) # 默认不将中文编码
expect = json.dumps(expect, ensure_ascii=False)
expect = Tool.json_converted_str(expect)
actual = json.dumps(actual, ensure_ascii=False)
actual = Tool.json_converted_str(actual)
style = xlwt.easyxf('align: wrap on') # 数据写入excel自动换行
write_sheet.col(2).width = (30 * 367)
write_sheet.col(3).width = (30 * 367)
write_sheet.write(n, 0, url)
write_sheet.write(n, 1, interface_name)
write_sheet.write(n, 2, interface_description)
write_sheet.write(n, 3, params)
write_sheet.write(n, 4, expect, style)
write_sheet.write(n, 5, actual, style)
Tool.log('URL:' + str(url), 'test')
Tool.log('接口名字：' + str(interface_name), 'test')
Tool.log('期望结果：'+str(expect),'test')
Tool.log('实际结果：' + str(actual), 'test')
if flag == 1:
write_sheet.write(n, 6, u"测试通过")
Tool.log("测试通过",'test')
print("测试通过")
else:
write_sheet.write(n, 6, u"测试失败")
Tool.log("测试失败", 'test')
print("测试失败")
wb.save(r"../test_report/report.xls")