plomlompom.com Git - plomtask/blob - tests/test_days.py

   1 """Test days module."""
   2 from unittest import TestCase
   3 from datetime import datetime
   4 from os import remove as remove_file
   5 from plomtask.days import Day
   6 from plomtask.misc import HandledException
   7 from plomtask.db import DatabaseFile, DatabaseConnection
   8
   9
  10 class TestsSansDB(TestCase):
  11     """Days module tests not requiring DB setup."""
  12
  13     def test_Day_dates(self):
  14         """Test Day's date format."""
  15         with self.assertRaises(HandledException):
  16             Day('foo')
  17         with self.assertRaises(HandledException):
  18             Day(None)
  19         with self.assertRaises(HandledException):
  20             Day(3)
  21         with self.assertRaises(HandledException):
  22             Day('2024-02-30')
  23         with self.assertRaises(HandledException):
  24             Day('2024-02-01 23:00:00')
  25         self.assertEqual(datetime(2024, 1, 1), Day('2024-01-01').datetime)
  26
  27     def test_Day_sorting(self):
  28         """Test Day.__lt__."""
  29         day1 = Day('2024-01-01')
  30         day2 = Day('2024-01-02')
  31         day3 = Day('2024-01-03')
  32         days = [day3, day1, day2]
  33         self.assertEqual(sorted(days), [day1, day2, day3])
  34
  35     def test_Day_weekday(self):
  36         """Test Day.weekday."""
  37         self.assertEqual(Day('2024-03-17').weekday, 'Sunday')
  38
  39
  40 class TestsWithDB(TestCase):
  41     """Days module tests not requiring DB setup."""
  42
  43     def setUp(self):
  44         timestamp = datetime.now().timestamp()
  45         self.db_file = DatabaseFile(f'test_db:{timestamp}')
  46         self.db_file.remake()
  47         self.db_conn = DatabaseConnection(self.db_file)
  48
  49     def tearDown(self):
  50         self.db_conn.close()
  51         remove_file(self.db_file.path)
  52
  53     def test_Day_by_date(self):
  54         """Test Day.by_date()."""
  55         self.assertEqual(None, Day.by_date(self.db_conn, '2024-01-01'))
  56         Day('2024-01-01').save(self.db_conn)
  57         self.assertEqual(Day('2024-01-01'),
  58                          Day.by_date(self.db_conn, '2024-01-01'))
  59         self.assertEqual(None,
  60                          Day.by_date(self.db_conn, '2024-01-02'))
  61         self.assertEqual(Day('2024-01-02'),
  62                          Day.by_date(self.db_conn, '2024-01-02', create=True))
  63
  64     def test_Day_all(self):
  65         """Test Day.all(), especially in regards to date range filtering."""
  66         day1 = Day('2024-01-01')
  67         day2 = Day('2024-01-02')
  68         day3 = Day('2024-01-03')
  69         day1.save(self.db_conn)
  70         day2.save(self.db_conn)
  71         day3.save(self.db_conn)
  72         self.assertEqual(Day.all(self.db_conn),
  73                          [day1, day2, day3])
  74         self.assertEqual(Day.all(self.db_conn, ('', '')),
  75                          [day1, day2, day3])
  76         self.assertEqual(Day.all(self.db_conn, ('2024-01-01', '2024-01-03')),
  77                          [day1, day2, day3])
  78         self.assertEqual(Day.all(self.db_conn, ('2024-01-02', '2024-01-03')),
  79                          [day2, day3])
  80         self.assertEqual(Day.all(self.db_conn, ('2024-01-03', '')),
  81                          [day3])
  82         self.assertEqual(Day.all(self.db_conn, ('2024-01-01', '')),
  83                          [day1, day2, day3])
  84         self.assertEqual(Day.all(self.db_conn, ('', '2024-01-02')),
  85                          [day1, day2])
  86         self.assertEqual(Day.all(self.db_conn, ('2024-01-03, 2024-01-01')),
  87                          [])
  88
  89     def test_Day_comment(self):
  90         """Test Day.by_date()."""
  91         self.assertEqual(None, Day.by_date(self.db_conn, '2024-01-01'))
  92         d1 = Day('2024-01-01')
  93         d1.save(self.db_conn)
  94         day_retrieved = Day.by_date(self.db_conn, d1.date)
  95         self.assertEqual(day_retrieved.comment, '')
  96         d2 = Day('2024-01-02', 'foo')
  97         d2.save(self.db_conn)
  98         day_retrieved = Day.by_date(self.db_conn, d2.date)
  99         self.assertEqual(day_retrieved.comment, 'foo')