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)