def test_register(self, case): headers = eval(conf.get("header", "headers")) url = conf.get("address", "url") + case['url'] phone = self.random_phone() if "$phone$" in case['params']: case['params'] = case['params'].replace("$phone$", phone) params = eval(case['params']) expected = eval(case['expected']) methods = case['methods'] rows = case['case_id'] + 1 response = requests.request(url=url, json=params, method=methods, headers=headers) result = response.json() try: self.assertEqual(expected['code'], result['code']) self.assertEqual(expected['msg'], result['msg']) sql = case['mysql_data'] if sql: response = db.find_data(sql.format(params['mobile_phone'])) self.assertTrue(response) except Exception as E: self.excel.write_excel(row=rows, column=7, value="失败") log.error(f"{case['title']}执行失败") log.exception(E) raise E else: self.excel.write_excel(row=rows, column=7, value='通过') log.info(f"{case['title']}执行通过")
def test_withdraw02(self, case): url = conf.get("address", "url") + case['url'] # if "#mobile_phone#" in case['params']: # case['params']=case['params'].replace("#mobile_phone#",conf.get("user","mobile_phone")) # if "#pwd#" in case['params']: # case['params']=case['params'].replace("#pwd#",conf.get("user","pwd")) # if "#member_id#" in case['params']: # case['params']=case['params'].replace("#member_id#",str(self.member_id)) case['params'] = handle_regular_class.replace_data( case['params'], test_withdraw02_class) params = eval(case['params']) # print(params) methods = case['methods'] headers = eval(conf.get("headerv2", "headers")) if case['interface'] == 'withdraw': headers['Authorization'] = self.token expected = eval(case["expected"]) rows = case['case_id'] + 1 sql = case['check_data'] # print(params['amount']) if sql: s_result = db.find_data(sql.format(self.member_id)) s_amount = s_result[0]['leave_amount'] # print(s_amount) response = requests.request(url=url, json=params, headers=headers, method=methods) res = response.json() print("预期结果:", expected) print("实际结果:", res) # print(res) if case['interface'] == "login": test_withdraw02_class.token = "Bearer" + " " + jsonpath( res, "$..token")[0] test_withdraw02_class.member_id = jsonpath(res, "$..id")[0] if sql: e_result = db.find_data(sql.format(self.member_id)) e_amount = e_result[0]['leave_amount'] # print(e_amount) try: self.assertEqual(expected['code'], res['code']) self.assertEqual(expected['msg'], res['msg']) if sql: self.assertEqual(float(s_amount - e_amount), float(params['amount'])) except AssertionError as e: self.excel.write_excel(row=rows, column=8, value='失败') # self.excel.write_excel(row=rows,column=10,value=res['msg']) log.error(f"用例{case['title']}执行失败") log.exception(e) raise e else: self.excel.write_excel(row=rows, column=8, value='通过')
def test_withdraw(self, case): url = conf.get("address", "url") + case['url'] # print(url) # if "#member_id#" in case['params']: # case['params']=case['params'].replace("#member_id#",str(self.member_id)) # print(self.member_id) case['params'] = handle_regular_class.replace_data( case['params'], test_withdraw_class) params = eval(case['params']) methods = case['methods'] headers = eval(conf.get("headerv2", "headers")) headers['Authorization'] = self.token expected = eval(case["expected"]) rows = case['case_id'] + 1 sql = case['check_data'] # print(params['amount']) if sql: s_result = db.find_data(sql.format(self.member_id)) s_amount = s_result[0]['leave_amount'] # print(s_amount) response = requests.request(url=url, json=params, headers=headers, method=methods) res = response.json() try: self.assertEqual(expected['code'], res['code']) self.assertEqual(expected['msg'], res['msg']) if sql: e_result = db.find_data(sql.format(self.member_id)) e_amount = e_result[0]['leave_amount'] self.assertEqual(float(s_amount - e_amount), params['amount']) except AssertionError as e: self.excel.write_excel(row=rows, column=8, value='失败') self.excel.write_excel(row=rows, column=10, value=res['msg']) log.error(f"用例{case['title']}执行失败") log.exception(e) raise e else: self.excel.write_excel(row=rows, column=8, value='通过')
def test_register(self,case): headers = eval(conf.get("header", "headers")) url=conf.get("address","url")+case['url'] params=eval(case['params']) expected=eval(case['expected']) methods=case['methods'] rows=case['case_id']+1 response=requests.request(url=url,json=params,method=methods,headers=headers) result=response.json() try: self.assertEqual(expected['code'],result['code']) self.assertEqual(expected['msg'],result['msg']) except Exception as E: self.excel.write_excel(row=rows,column=7,value="失败") log.error(f"{case['title']}执行失败") log.exception(E) raise E else: self.excel.write_excel(row=rows,column=7,value='通过') log.info(f"{case['title']}执行通过")
def test_recharge(self, case): base_url = conf.get("address", 'url') url = base_url + case['url'] if "#member_id#" in case['params']: case['params'] = case['params'].replace("#member_id#", str(self.member_id)) params = eval(case['params']) methods = case['methods'] headers = eval(conf.get("headerv2", "headers")) headers['Authorization'] = self.token expected = eval(case['expected']) rows = case['case_id'] + 1 sql = case['check_data'] if sql: s_result = db.find_data(sql.format(self.member_id)) s_amout = s_result[0]["leave_amount"] # print(s_amout) response = requests.request(url=url, json=params, method=methods, headers=headers) res = response.json() print("预期结果:", expected) print("实际结果:", res) try: self.assertEqual(expected['code'], res['code']) self.assertEqual(expected['msg'], res['msg']) if sql: e_result = db.find_data(sql.format(self.member_id)) e_amout = e_result[0]["leave_amount"] self.assertEqual(float(e_amout - s_amout), params['amount']) except AssertionError as e: self.excel.write_excel(row=rows, column=7, value="失败") # self.excel.write_excel(row=rows,column=8,value=str(res['msg'])) log.error(f"测试用例{case['title']}执行失败") log.exception(e) raise e else: self.excel.write_excel(row=rows, column=7, value="通过") log.info(f"测试用例{case['title']}执行通过")