"""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):
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, ('', '')), [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)