示例#1
0
 def test_division(self, case_list):
     self.my_HandleExcel = HandleExcel(file, 'division')
     case_id, title, l_data, r_data, expected = case_list['case_id'], case_list['title'], case_list['l_data'], \
                                                case_list['r_data'], case_list['expected']
     actual = Arithmetic(l_data, r_data).division()
     result = expected
     msg = title
     try:
         self.assertEqual(result, actual, msg)
         print('{},执行结果为:{}'.format(msg, true_result))
         self.my_HandleExcel.write_result(case_id + 1, actual, true_result)
     except AssertionError as e:
         print('具体异常为{}'.format(e))
         self.my_HandleExcel.write_result(case_id + 1, actual, fail_result)
         raise e
示例#2
0
class TestArithmetic(unittest.TestCase):
    @classmethod
    def setUpClass(cls):
        pass

    @classmethod
    def tearDownClass(cls):
        pass

    def setUp(self):
        pass

    def tearDown(self):
        wb, ws = self.my_HandleExcel.load_excel()
        wb.save(file)
        wb.close()

    @data(*HandleExcel(file, 'add').get_case())
    def test_add(self, case_list):
        self.my_HandleExcel = HandleExcel(file, 'add')
        case_id, title, l_data, r_data, expected = case_list['case_id'], case_list['title'], case_list['l_data'], \
                                                   case_list['r_data'], case_list['expected']
        actual = Arithmetic(l_data, r_data).add()
        result = expected
        msg = title
        try:
            self.assertEqual(result, actual, msg)
            print('{},执行结果为:{}'.format(msg, true_result))
            self.my_HandleExcel.write_result(case_id + 1, actual, true_result)
        except AssertionError as e:
            print('具体异常为{}'.format(e))
            self.my_HandleExcel.write_result(case_id + 1, actual, fail_result)
            raise e

    @data(*HandleExcel(file, 'minus').get_case())
    def test_minus(self, case_list):
        self.my_HandleExcel = HandleExcel(file, 'minus')
        case_id, title, l_data, r_data, expected = case_list['case_id'], case_list['title'], case_list['l_data'], \
                                                   case_list['r_data'], case_list['expected']
        actual = Arithmetic(l_data, r_data).minus()
        result = expected
        msg = title
        try:
            self.assertEqual(result, actual, msg)
            print('{},执行结果为:{}'.format(msg, true_result))
            self.my_HandleExcel.write_result(case_id + 1, actual, true_result)
        except AssertionError as e:
            print('具体异常为{}'.format(e))
            self.my_HandleExcel.write_result(case_id + 1, actual, fail_result)
            raise e

    @data(*HandleExcel(file, 'multiply').get_case())
    def test_multiply(self, case_list):
        self.my_HandleExcel = HandleExcel(file, 'multiply')
        case_id, title, l_data, r_data, expected = case_list['case_id'], case_list['title'], case_list['l_data'], \
                                                   case_list['r_data'], case_list['expected']
        actual = Arithmetic(l_data, r_data).multiply()
        result = expected
        msg = title
        try:
            self.assertEqual(result, actual, msg)
            print('{},执行结果为:{}'.format(msg, true_result))
            self.my_HandleExcel.write_result(case_id + 1, actual, true_result)
        except AssertionError as e:
            print('具体异常为{}'.format(e))
            self.my_HandleExcel.write_result(case_id + 1, actual, fail_result)
            raise e

    @data(*HandleExcel(file, 'division').get_case())
    def test_division(self, case_list):
        self.my_HandleExcel = HandleExcel(file, 'division')
        case_id, title, l_data, r_data, expected = case_list['case_id'], case_list['title'], case_list['l_data'], \
                                                   case_list['r_data'], case_list['expected']
        actual = Arithmetic(l_data, r_data).division()
        result = expected
        msg = title
        try:
            self.assertEqual(result, actual, msg)
            print('{},执行结果为:{}'.format(msg, true_result))
            self.my_HandleExcel.write_result(case_id + 1, actual, true_result)
        except AssertionError as e:
            print('具体异常为{}'.format(e))
            self.my_HandleExcel.write_result(case_id + 1, actual, fail_result)
            raise e