def request_token(self):
try:
result = self.req.get(self.baseUrl + '/login',
headers=self.headers)
page_info = result.text
token = re.findall(r'name="csrf-token" content="(.*?)">',
str(page_info))[0] # 正则表达式只能匹配str
self.headers["X-CSRF-TOKEN"] = token
return token
except Exception as e:
print(e)
Tool.log(e, 'debug.log')
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")