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