class TestRecharge(unittest.TestCase):
@classmethod
def setUpClass(cls):
do_logger.info('\n{:=^40s}\n'.format('开始执行用例'))
@classmethod
def tearDownClass(cls):
do_logger.info('\n{:=^40s}\n'.format('用例执行结束'))
def setUp(self):
pass
def tearDown(self):
wb, ws = self.my_HandleExcel.load_excel()
wb.save(DATA_COMMON_FILE_PATH)
wb.close()
do_request.request_close()
@data(*cases_suite)
def test_recharge(self, case_list):
self.my_HandleExcel = HandleExcel(DATA_COMMON_FILE_PATH, 'recharge')
if case_list['check_sql']:
before_sql_data = do_mysql.sql_search(
case_list['check_sql'],
virtue=eval(case_list['data'])['mobilephone'])
self.before_leaveamount = float(before_sql_data['LeaveAmount'])
request_result = do_request.send_request(
case_list['method'],
do_config.get_value('request', 'default_address') +
case_list['url_path'], case_list['data'])
actual = int(request_result.json().get('code'))
result = case_list['expected']
msg = case_list['title']
try:
self.assertEqual(result, actual, msg)
if case_list['check_sql']:
after_sql_data = do_mysql.sql_search(
case_list['check_sql'],
virtue=eval(case_list['data'])['mobilephone'])
after_leaveamount = float(after_sql_data['LeaveAmount'])
true_results = after_leaveamount - self.before_leaveamount
self.assertEqual(
eval(case_list['data'])['amount'], round(true_results, 2),
msg)
print('{},执行结果为:{}'.format(msg, true_result))
self.my_HandleExcel.write_result(case_list['case_id'] + 1, actual,
true_result)
do_logger.error("{}, 执行结果为: {}".format(msg, true_result))
except AssertionError as e:
print('具体异常为{}'.format(e))
self.my_HandleExcel.write_result(case_list['case_id'] + 1, actual,
fail_result)
do_logger.error("{}, 执行结果为: {},具体异常为{}".format(
msg, fail_result, e))
raise e
class TestRegister(unittest.TestCase):
@classmethod
def setUpClass(cls):
do_logger.info('\n{:=^40s}\n'.format('开始执行用例'))
@classmethod
def tearDownClass(cls):
do_logger.info('\n{:=^40s}\n'.format('用例执行结束'))
def setUp(self):
pass
def tearDown(self):
wb, ws = self.my_HandleExcel.load_excel()
wb.save(DATA_COMMON_FILE_PATH)
wb.close()
@data(*cases_suite)
def test_register(self, case_list):
self.my_HandleExcel = HandleExcel(DATA_COMMON_FILE_PATH, 'register')
request_result = do_request.send_request(
case_list['method'],
do_config.get_value('request', 'default_address') +
case_list['url_path'], case_list['data'])
actual_text = request_result.text
actual_value = json.loads(actual_text)['code']
actual = 'code: "{}",'.format(actual_value)
result = case_list['expected']
msg = case_list['title']
try:
self.assertEqual(result, actual, msg)
print('{},执行结果为:{}'.format(msg, true_result))
self.my_HandleExcel.write_result(case_list['case_id'] + 1, actual,
true_result)
do_logger.error("{}, 执行结果为: {}".format(msg, true_result))
except AssertionError as e:
print('具体异常为{}'.format(e))
self.my_HandleExcel.write_result(case_list['case_id'] + 1, actual,
fail_result)
do_logger.error("{}, 执行结果为: {},具体异常为{}".format(
msg, fail_result, e))
raise e