def test_add(self, add): print("测试的用例是:{}".format(add['description'])) login_data = Parameter.add_parameter(login_success[0]['param']) self.session_request.request(login_success[0]['method'], login_success[0]['url'], eval(login_data)) add_param = eval(Parameter.add_parameter(add['param'])) print("测试的数据是:{}".format(add_param)) res = self.session_request.request(add['method'], add['url'], data=add_param) test_result = None write_res = DoExcel(project_path.CASE_FILE_PATH, 'add') try: # self.assertEqual(str(res.json()['code']), str(add['except_code'])) self.assertIn(str(add['except_code']), res.text) my_logger.info(res.text) test_result = succeed except AssertionError as e: my_logger.error(e) test_result = failed raise e finally: print("测试结果是:", res.text) write_res.write_result(add['id'] + 1, res.json()['code'], test_result)
def test_register(self, register): print("测试的用例是:{}".format(register['description'])) param = Parameter.register_parameter(register['param']) print("测试的数据是:{}".format(param)) res = self.request.http_request(register['url'], register['method'], datas=param) test_result = None write_res = DoExcel(project_path.CASE_FILE_PATH, 'register') try: # self.assertEqual(str(res.json()['code']), str(register['except_code'])) self.assertIn(str(register['except_code']), res.text) my_logger.info(res.text) test_result = succeed except AssertionError as e: my_logger.error(e) test_result = failed raise e finally: print("测试结果是:", res.text) write_res.write_result(register['id'] + 1, res.json()['code'], test_result)
def test_recharge(self, recharge): # 在测试报告中显示测试用例名称 print("测试的用例是:{}".format(recharge['description'])) login_data = eval( Parameter.recharge_parameter(login_success[0]['param'])) self.session_request.request(login_success[0]['method'], login_success[0]['url'], login_data) param = eval(Parameter.recharge_parameter(recharge['param'])) print("测试的数据是:{}".format(param)) # 查询数据库余额数据进行数据校验 seek_sql = recharge['seek_sql'] if seek_sql: seek_sql = Parameter.recharge_parameter(seek_sql) before_seek_res = self.check_sql.run_sql(seek_sql, site=1) # seek_res = json.loads(seek_res) # 将返回数据进行数据转换,数据库查询出数据为decimal.Decimal类型,并保留两位小数 before_amount = round(float(before_seek_res['LeaveAmount']), 2) # 调用充值接口 res = self.session_request.request(recharge['method'], recharge['url'], data=param) test_result = None write_res = DoExcel(project_path.CASE_FILE_PATH, 'recharge') try: # self.assertEqual(str(res.json()['code']), str(recharge['except_code'])) self.assertIn(str(recharge['except_code']), res.text) if seek_sql: # 前一个sql已经完成参数化 # seek_sql = Parameter.recharge_parameter(seek_sql) after_seek_res = self.check_sql.run_sql(seek_sql, site=1) after_amount = round(float(after_seek_res['LeaveAmount']), 2) # 判断充值前后账户金额的变化是否正确 self.assertEqual(after_amount, before_amount + param['amount']) my_logger.info(res.text) test_result = succeed except AssertionError as e: my_logger.error(e) test_result = failed raise e finally: print("测试结果是:", res.text) write_res.write_result(recharge['id'] + 1, res.json()['code'], test_result)
def test_bidloan(self, bidloan): print("测试的用例是:{}".format(bidloan['description'])) # login_data = eval(Parameter.lodn_parameter(login_success[0]['param'])) # self.session_request.request(login_success[0]['method'], login_success[0]['url'], # login_data) loan_param = eval(Parameter.loan_parameter(bidloan['param'])) # self.session_request.request(bidloan['method'], bidloan['url'],bidloan) print("测试的数据是:{}".format(loan_param)) res = self.session_request.request(bidloan['method'], bidloan['url'], loan_param) # 获取成功加标的id if "加标成功" in res.text: check_sql = bidloan['seek_sql'] if check_sql: check_sql = Parameter.loan_parameter(check_sql) check_data = self.do_mysql.run_sql(check_sql, site=1) loan_id = check_data['Id'] # 取出加标ID print(loan_id) # 动态创建属性 setattr(Parameter, "loan_id", loan_id) test_result = None write_res = DoExcel(project_path.CASE_FILE_PATH, 'bidLoan') try: # self.assertEqual(str(res.json()['code']), str(bidloan['except_code'])) self.assertIn(str(bidloan['except_code']), res.text) my_logger.info(res.text) test_result = succeed except AssertionError as e: my_logger.error(e) test_result = failed raise e finally: print("测试结果是:", res.text) write_res.write_result(bidloan['id'] + 1, res.json()['code'], test_result)