def test_sum_expeneses_two_rows(self): da = DataAccess(database=TEST_DB) da.insert(**TEST_ROW_1) da.insert(**TEST_ROW_2) sum_result = da.sum_expenses() da.close() self.assertAlmostEqual(sum_result, 26.99)
def get_sum(): sum_data_access = DataAccess() sum_result = sum_data_access.sum_expenses() sum_data_access.close() return sum_result
def test_sum_expenses_one_row(self): da = DataAccess(database=TEST_DB) da.insert(**TEST_ROW_1) sum_result = da.sum_expenses() da.close() self.assertEqual(sum_result, 12.75)
def test_sum_expenses_missing_table_is_zero(self): da = DataAccess(database=TEST_DB) sum_result = da.sum_expenses() da.close() self.assertEqual(sum_result, 0)
def test_sum_expenses_no_rows_is_zero(self): da = DataAccess(database=TEST_DB) da.create() sum_result = da.sum_expenses() da.close() self.assertEqual(sum_result, 0)