Python ExcelDriverDummy 예제들

예제 #1

파일: test_excel_model_evaluator.py 프로젝트: jhajagos/ExcelBlackBox

class TestExcelDriverDummy(unittest.TestCase):
    def setUp(self):
        self.excel_driver_obj = ExcelDriverDummy()

    def test_basic_read_write(self):
        self.excel_driver_obj.set_cell_value("A1", 1.0, "Sheet1")
        self.excel_driver_obj.set_cell_value("A2", 2.0, "Sheet1")
        self.excel_driver_obj.set_cell_value("A3", 2.0, "Sheet1")

        a = self.excel_driver_obj.read_cell_value("A1", "Sheet1")
        self.assertEquals(1.0, a)

        b = self.excel_driver_obj.read_cell_value("A2", "Sheet1")
        self.assertEquals(2.0, b)

    def test_function_evaluation(self):

        self.excel_driver_obj.set_cell_value("B1", 1.5, "Sheet1")
        self.excel_driver_obj.set_cell_value("B2", 2.0, "Sheet1")
        self.excel_driver_obj.set_cell_value("B3", 2.0, "Sheet1")

        result = self.excel_driver_obj.read_cell_value("C2")
        self.assertIsNone(result)
        self.excel_driver_obj.set_cell_value("B4", math.pi, "Sheet1")
        result2 = self.excel_driver_obj.read_cell_value("C2")
        self.assertIsNotNone(result2)

        expected_result2 = 2.0 * math.sin( (1/2.0) * math.pi)

        self.assertEquals(expected_result2, result2)

예제 #2

파일: test_excel_model_evaluator.py 프로젝트: hoadu/ExcelBlackBox

class TestExcelDriverDummy(unittest.TestCase):
    def setUp(self):
        self.excel_driver_obj = ExcelDriverDummy()

    def test_basic_read_write(self):
        self.excel_driver_obj.set_cell_value("A1", 1.0, "Sheet1")
        self.excel_driver_obj.set_cell_value("A2", 2.0, "Sheet1")
        self.excel_driver_obj.set_cell_value("A3", 2.0, "Sheet1")

        a = self.excel_driver_obj.read_cell_value("A1", "Sheet1")
        self.assertEquals(1.0, a)

        b = self.excel_driver_obj.read_cell_value("A2", "Sheet1")
        self.assertEquals(2.0, b)

    def test_function_evaluation(self):

        self.excel_driver_obj.set_cell_value("B1", 1.5, "Sheet1")
        self.excel_driver_obj.set_cell_value("B2", 2.0, "Sheet1")
        self.excel_driver_obj.set_cell_value("B3", 2.0, "Sheet1")

        result = self.excel_driver_obj.read_cell_value("C2")
        self.assertIsNone(result)
        self.excel_driver_obj.set_cell_value("B4", math.pi, "Sheet1")
        result2 = self.excel_driver_obj.read_cell_value("C2")
        self.assertIsNotNone(result2)

        expected_result2 = 2.0 * math.sin((1 / 2.0) * math.pi)

        self.assertEquals(expected_result2, result2)

예제 #3

파일: test_excel_model_evaluator.py 프로젝트: jhajagos/ExcelBlackBox

 def setUp(self):
     self.excel_driver_obj = ExcelDriverDummy()

예제 #4

파일: test_excel_model_evaluator.py 프로젝트: hoadu/ExcelBlackBox

 def setUp(self):
     self.excel_driver_obj = ExcelDriverDummy()