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)