from datetime import datetime
from tests.utils import TestCaseWithDB, TestCaseWithServer
from plomtask.days import Day, todays_date
-from plomtask.exceptions import BadFormatException, NotFoundException
+from plomtask.exceptions import BadFormatException
class TestsSansDB(TestCase):
class TestsWithDB(TestCaseWithDB):
"""Tests requiring DB, but not server setup."""
+ 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.assertEqual({}, Day.get_cache())
- self.assertEqual([], Day.all(self.db_conn))
- # check saving stores in cache and DB
- day.save(self.db_conn)
- assert isinstance(day.id_, str)
- for row in self.db_conn.row_where(Day.table_name, 'id', day.id_):
- self.assertEqual(day, Day.from_table_row(self.db_conn, row))
- self.assertEqual({day.id_: day}, Day.get_cache())
- # check attributes set properly (and not unset by saving)
- self.assertEqual(day.id_, date)
- self.assertEqual(day.comment, comment)
+ kwargs = {'date': self.default_ids[0], '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"""
+ self.check_from_table_row()
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.assertEqual({day1.id_: day1}, Day.get_cache())
- self.assertEqual([day1], Day.all(self.db_conn))
+ 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)
- day1.save(self.db_conn)
- day3.save(self.db_conn)
- # check that all() shows all saved, but no unsaved items
- 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 open interval
+ # check date range is a closed interval
self.assertEqual(Day.all(self.db_conn, (date1, date3)),
[day1, day2, day3])
# check first date range value excludes what's earlier
self.assertEqual(Day.all(self.db_conn, (date2, '2024-01-07'),
fill_gaps=True),
[day2, day3, day4, day5, day6])
- self.assertEqual(Day.get_cache().keys(),
- {date1, date2, date3, day6.date})
- assert isinstance(day4.id_, str)
- assert isinstance(day5.id_, str)
- self.assertEqual(self.db_conn.row_where(Day.table_name,
- 'id', day4.id_), [])
- self.assertEqual(self.db_conn.row_where(Day.table_name,
- 'id', day5.id_), [])
+ self.check_storage([day1, day2, day3, day6])
# check 'today' is interpreted as today's date
today = Day(todays_date())
today.save(self.db_conn)
def test_Day_remove(self) -> None:
"""Test .remove() effects on DB and cache."""
- date = '2024-01-01'
- day = Day(date)
- day.save(self.db_conn)
- day.remove(self.db_conn)
- assert isinstance(day.id_, str)
- self.assertEqual(self.db_conn.row_where(Day.table_name,
- 'id', day.id_), [])
- self.assertEqual(Day.get_cache(), {})
+ 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):