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 insert_expense(self):
insert_data_access = DataAccess()
insert_dict = {
'description': self.description.get(),
'amount': self.amount.get(),
'file_path': self.receipt.get(),
'date': self.date.get(),
}
insert_data_access.insert(**insert_dict)
insert_data_access.close()
self.sum += float(self.amount.get())
self.sum_label.set(format_sum_string(self.sum))
self.add_window.destroy()
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_insert_adding_two_rows(self):
da = DataAccess(database=TEST_DB)
da.insert(**TEST_ROW_1)
da.insert(**TEST_ROW_2)
da.close()
self.assertEqual(_get_row_count(), 2)
def test_create_when_table_already_exists(self):
da = DataAccess(database=TEST_DB)
da.create()
da.create()
da.close()
self.assertEqual(_table_exists(), 1)
def test_constructor_with_default_params(self):
da = DataAccess()
self.assertEqual(da.database, 'expenses.db')
self.assertEqual(da.table_name, 'expenses')
da.close()
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)
