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 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_extra_fields(self):
da = DataAccess(database=TEST_DB)
da.insert(**TEST_ROW_3)
self.assertEqual(_get_row_count(), 1)
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)