X-Git-Url: https://plomlompom.com/repos/%7B%7Bprefix%7D%7D/static/gitweb.css?a=blobdiff_plain;f=tests%2Ftest_days.py;h=8f5f2678c002034f02a1f036c28b976dd1b589b6;hb=a8a7b5d0a5007274539e528968c68fe9f25e422e;hp=ba627e98cfbfb2c010510f828e965678ba8e783f;hpb=96b8f35df2ed6f7db0c7c8ffa8234e2925e8756c;p=plomtask

diff --git a/tests/test_days.py b/tests/test_days.py
index ba627e9..8f5f267 100644
--- a/tests/test_days.py
+++ b/tests/test_days.py
@@ -1,20 +1,61 @@
 """Test days module."""
 from unittest import TestCase
+from datetime import datetime
+from os import remove as remove_file
 from plomtask.days import Day
 from plomtask.misc import HandledException
+from plomtask.db import DatabaseFile, DatabaseConnection
 
 
 class DayTests(TestCase):
     """Tests for testing the days module."""
 
     def test_Day_dates(self):
-        """Test Day's date format.."""
+        """Test Day's date format."""
         with self.assertRaises(HandledException):
             Day('foo')
+        with self.assertRaises(HandledException):
             Day(None)
+        with self.assertRaises(HandledException):
             Day(3)
+        with self.assertRaises(HandledException):
             Day('2024-02-30')
+        with self.assertRaises(HandledException):
+            Day('2024-02-01 23:00:00')
+        self.assertEqual(datetime(2024, 1, 1), Day('2024-01-01').datetime)
+
+    def test_Day_sorting(self):
+        """Test Day.__lt__."""
+        day1 = Day('2024-01-01')
+        day2 = Day('2024-01-02')
+        day3 = Day('2024-01-03')
+        days = [day3, day1, day2]
+        self.assertEqual(sorted(days), [day1, day2, day3])
 
     def test_Day_weekday(self):
         """Test Day.weekday."""
         self.assertEqual(Day('2024-03-17').weekday, 'Sunday')
+
+    def test_Day_all(self):
+        """Test Day.all(), especially in regards to date range filtering."""
+        timestamp = datetime.now().timestamp()
+        db_file = DatabaseFile(f'test_db:{timestamp}')
+        db_file.remake()
+        conn = DatabaseConnection(db_file)
+        day1 = Day('2024-01-01')
+        day2 = Day('2024-01-02')
+        day3 = Day('2024-01-03')
+        day1.save(conn)
+        day2.save(conn)
+        day3.save(conn)
+        self.assertEqual(Day.all(conn), [day1, day2, day3])
+        self.assertEqual(Day.all(conn, ('2024-01-01', '2024-01-03')),
+                         [day1, day2, day3])
+        self.assertEqual(Day.all(conn, ('2024-01-02', '2024-01-03')),
+                         [day2, day3])
+        self.assertEqual(Day.all(conn, ('2024-01-03', '')), [day3])
+        self.assertEqual(Day.all(conn, ('2024-01-01', '')), [day1, day2, day3])
+        self.assertEqual(Day.all(conn, ('', '2024-01-02')), [day1, day2])
+        self.assertEqual(Day.all(conn, ('2024-01-03, 2024-01-01')), [])
+        conn.close()
+        remove_file(db_file.path)