def setUpClass(cls):
cls.s = requests.session()
# 如果有登录的话，就在这里先登录了
writeexcel.copy_excel(testxlsx, reportxlsx) # 复制xlsx
res['msg'] = ''
if testdata['checkpoint'] in res['text']:
res['result'] = 'pass'
print('用例测试结果：%s--->%s' % (test_nub, res['result']))
else:
res['result'] = 'fail'
return res
except Exception as e:
res['msg'] = str(e)
return res
def write_result(result, filename='result.xlsx'):
row_nub = result['rowNum']
wt = Write_excel(filename)
wt.write(row_nub, 8, result['statuscode'])
wt.write(row_nub, 9, result['times'])
wt.write(row_nub, 10, result['error'])
wt.write(row_nub, 12, result['result'])
wt.write(row_nub, 13, result['msg'])
if __name__ == '__main__':
data = ExcelUtil('debug_api.xlsx').dict_data()
print(data[0])
s = requests.session()
res = send_requests(s, data[0])
print(res['statuscode'])
copy_excel('debug_api.xlsx', 'result.xlsx')
write_result(res, filename='result.xlsx')
def setUpClass(self):
self.s = requests.session()
# 如果有登录的话，就在这里先登录了
Login().login()
writeexcel.copy_excel(testxlsx, reportxlsx) # 复制xlsx
if testdata["checkpoint"] in res["text"]:
res["result"] = "pass"
print("用例测试结果: %s---->%s" % (test_nub, res["result"]))
else:
res["result"] = "fail"
return res
except Exception as msg:
res["msg"] = str(msg)
return res
def wirte_result(result, filename="result.xlsx"):
# 返回结果的行数row_nub
row_nub = result['rowNum']
# 写入statuscode
wt = Write_excel(filename)
wt.write(row_nub, 8, result['statuscode']) # 写入返回状态码statuscode,第8列
wt.write(row_nub, 9, result['times']) # 耗时
wt.write(row_nub, 10, result['error']) # 状态码非200时的返回信息
wt.write(row_nub, 12, result['result'])
wt.write(row_nub, 13, result['msg']) # 抛异常
if __name__ == "__main__":
data = ExcelUtil("debug_api.xlsx").dict_data()
print(data[0])
s = requests.session()
res = send_requests(s, data[0])
copy_excel("debug_api.xlsx", "result.xlsx")
wirte_result(res, filename="result.xlsx")
def setUpClass(cls):
writeexcel.copy_excel(testxlsx, reportxlsx) # 复制xlsx
def setUpClass(cls):
cls.s = requests.session()
writeexcel.copy_excel(textxlsx, reportxlsx)
def setUpClass(cls):
cls.s = requests.session()
new_login.add_cookies(s=cls.s)
# pandarola_login()
writeexcel.copy_excel(testxlsx, reportxlsx) # 复制xlsx
return res
def write_result(result,filename="result.xlsx"):
"""返回结果行数：row_nub"""
print (result)
row_nub = result["rowNum"]
# #写入statuscode
wt = Write_excel(filename)
wt.write(row_nub,8,result["statuscode"]) #第八列写入返回状态码
wt.write(row_nub,9,result["times"]) #耗时
wt.write(row_nub,10,result["error"]) #状态码非200时候返回结果
wt.write(row_nub,11,result["result"]) #返回结果是fail还是pass
wt.write(row_nub,12,result["msg"]) #抛异常
if __name__=="__main__":
data = ExcelUtil("debug_api.xlsx","Sheet1").dict_data()
print (data[0])
s = requests.session()
res = send_requests(s,data[0])
copy_excel("debug_api.xlsx","debug_api2.xlsx")
write_result(res,filename="debug_api2.xlsx")
print("用例测试结果： %s---->%s" % (test_nub, res["result"]))
else:
res["result"] = "fail"
return res
except Exception as msg:
#print(u'断点2')
res["msg"] = str(msg)
return res
def wirte_result(result, filename="result.xlsx"):
row_nub = result['rowNum']
wt = Write_excel(filename)
wt.write(row_nub, 8, result['statuscode'])
wt.write(row_nub, 9, result['times'])
wt.write(row_nub, 10, result['error'])
wt.write(row_nub, 12, result['result'])
wt.write(row_nub, 13, result['msg'])
if __name__ == "__main__":
data = ExcelUtil("C:\\Users\Administrator\\PycharmProjects\\PostTest\\Testcase\\demo_api.xlsx",
sheetName="Sheet1").dict_data()
print(data[0])
s = requests.session()
res = send_requests(s,data[0])
print(res)
copy_excel("C:\\Users\Administrator\\PycharmProjects\\PostTest\\Testcase\\demo_api.xlsx",
"C:\\Users\Administrator\\PycharmProjects\\PostTest\\report\\result.xlsx")
wirte_result(res, filename="C:\\Users\Administrator\\PycharmProjects\\PostTest\\report\\result.xlsx")
res["error"] = ""
res["msg"] = ""
if testdata["checkpoint"] in res["text"]:
res["result"] = "pass"
print("用例测试结果: %s---->%s" % (test_nub, res["result"]))
else:
res["result"] = "fail"
return res
except Exception as msg:
res["msg"] = str(msg)
return res
def wirte_result(result, filename="D:/py_test/new_test/logs/test_result.xlsx"):
# 返回结果的行数row_nub
row_nub = result['rowNum']
# 写入statuscode
wt = Write_excel(filename)
wt.write(row_nub, 9, result['statuscode']) # 写入返回状态码statuscode,第8列
wt.write(row_nub, 10, result['times']) # 耗时
wt.write(row_nub, 11, result['error']) # 状态码非200时的返回信息
wt.write(row_nub, 13, result['result']) # 测试结果 pass 还是fail
wt.write(row_nub, 14, result['msg']) # 抛异常
if __name__ == "__main__":
data = ExcelUtil("debug_api.xlsx").dict_data()
s = requests.session()
res = send_requests(s, data[0])
copy_excel("debug_api.xlsx", "D:/py_test/api_test3/logs/test_result.xlsx")
wirte_result(res, filename="D:/py_test/api_test3/logs/test_result.xlsx")
def setUpClass(cls):
cls.s = requests.session()
#如果有cookie此处添加cookie绕过验证码
writeexcel.copy_excel(testxlsx, reportxlsx) #复制excel
