X-Git-Url: https://plomlompom.com/repos/?a=blobdiff_plain;f=tests%2Fdays.py;fp=tests%2Fdays.py;h=c143f985b22b7bdd41d65e21409c2016274de54c;hb=f8148a40996d64878431ac59d47650741e1d79c5;hp=ffc2ab2a59e66d4a82a8bc0fd6f0364f4865d79a;hpb=9c68e4b443a695652f2ba3acae126ad02e3f6ffa;p=plomtask

diff --git a/tests/days.py b/tests/days.py
index ffc2ab2..c143f98 100644
--- a/tests/days.py
+++ b/tests/days.py
@@ -3,8 +3,7 @@ from unittest import TestCase
 from datetime import datetime
 from tests.utils import TestCaseWithDB, TestCaseWithServer
 from plomtask.days import Day, todays_date
-from plomtask.exceptions import (BadFormatException, NotFoundException,
-                                 HandledException)
+from plomtask.exceptions import BadFormatException
 
 
 class TestsSansDB(TestCase):
@@ -40,79 +39,26 @@ class TestsSansDB(TestCase):
 
 class TestsWithDB(TestCaseWithDB):
     """Tests requiring DB, but not server setup."""
-
-    def check_storage(self, content: list[Day]) -> None:
-        """Test cache and DB equal content."""
-        expected_cache = {}
-        for item in content:
-            expected_cache[item.id_] = item
-        self.assertEqual(Day.get_cache(), expected_cache)
-        db_found: list[Day] = []
-        for item in content:
-            assert isinstance(item.id_, str)
-            for row in self.db_conn.row_where(Day.table_name, 'id', item.id_):
-                db_found += [Day.from_table_row(self.db_conn, row)]
-        self.assertEqual(sorted(content), sorted(db_found))
+    checked_class = Day
+    default_ids = ('2024-01-01', '2024-01-02', '2024-01-03')
 
     def test_Day_saving_and_caching(self) -> None:
         """Test .save/.save_core."""
-        date = '2024-01-01'
-        comment = 'comment'
-        day = Day(date, comment)
-        # check object init itself doesn't store anything yet
-        self.check_storage([])
-        # check saving stores in cache and DB
-        day.save(self.db_conn)
-        self.check_storage([day])
-        # check attributes set properly (and not unset by saving)
-        self.assertEqual(day.id_, date)
-        self.assertEqual(day.comment, comment)
+        kwargs = {'date': '2024-01-01', 'comment': 'foo'}
+        self.check_saving_and_caching(**kwargs)
 
     def test_Day_from_table_row(self) -> None:
         """Test .from_table_row() properly reads in class from DB"""
-        day = Day('2024-01-01')
-        day.save(self.db_conn)
-        assert isinstance(day.id_, str)
-        for row in self.db_conn.row_where(Day.table_name, 'id', day.id_):
-            retrieved = Day.from_table_row(self.db_conn, row)
-            self.assertEqual(day, retrieved)
-            self.assertEqual({day.id_: day}, Day.get_cache())
+        self.check_from_table_row('2024-01-01')
 
     def test_Day_by_id(self) -> None:
         """Test .by_id()."""
-        date1 = '2024-01-01'
-        date2 = '2024-01-02'
-        # check failure if not yet saved
-        day1 = Day(date1)
-        with self.assertRaises(NotFoundException):
-            Day.by_id(self.db_conn, date1)
-        # check identity of saved and retrieved
-        day1.save(self.db_conn)
-        self.assertEqual(day1, Day.by_id(self.db_conn, date1))
-        # check create=True acts like normal instantiation (sans saving)
-        by_id_created = Day.by_id(self.db_conn, date2, create=True)
-        self.assertEqual(Day(date2), by_id_created)
-        self.check_storage([day1])
+        self.check_by_id()
 
     def test_Day_all(self) -> None:
         """Test Day.all(), especially in regards to date range filtering."""
-        date1 = '2024-01-01'
-        date2 = '2024-01-02'
-        date3 = '2024-01-03'
-        day1 = Day(date1)
-        day2 = Day(date2)
-        day3 = Day(date3)
-        # check pre-save .all() returns empty list
-        self.assertEqual(Day.all(self.db_conn), [])
-        # check that all() shows all saved, but no unsaved items
-        day1.save(self.db_conn)
-        day3.save(self.db_conn)
-        self.assertEqual(Day.all(self.db_conn),
-                         [day1, day3])
-        day2.save(self.db_conn)
-        self.assertEqual(Day.all(self.db_conn),
-                         [day1, day2, day3])
-        # check empty date range values show everything
+        date1, date2, date3 = self.default_ids
+        day1, day2, day3 = self.check_all()
         self.assertEqual(Day.all(self.db_conn, ('', '')),
                          [day1, day2, day3])
         # check date range is a closed interval
@@ -146,21 +92,11 @@ class TestsWithDB(TestCaseWithDB):
 
     def test_Day_remove(self) -> None:
         """Test .remove() effects on DB and cache."""
-        date = '2024-01-01'
-        day = Day(date)
-        with self.assertRaises(HandledException):
-            day.remove(self.db_conn)
-        day.save(self.db_conn)
-        day.remove(self.db_conn)
-        self.check_storage([])
+        self.check_remove()
 
     def test_Day_singularity(self) -> None:
         """Test pointers made for single object keep pointing to it."""
-        day = Day('2024-01-01')
-        day.save(self.db_conn)
-        retrieved_day = Day.by_id(self.db_conn, '2024-01-01')
-        day.comment = 'foo'
-        self.assertEqual(retrieved_day.comment, 'foo')
+        self.check_singularity('comment', 'boo')
 
 
 class TestsWithServer(TestCaseWithServer):