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)
