- 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)
+ self.assertEqual(Day.all(self.db_conn, ('2024-01-03', '')),
+ [day3])
+ self.assertEqual(Day.all(self.db_conn, ('2024-01-01', '')),
+ [day1, day2, day3])
+ self.assertEqual(Day.all(self.db_conn, ('', '2024-01-02')),
+ [day1, day2])
+ self.assertEqual(Day.all(self.db_conn, ('2024-01-03, 2024-01-01')),
+ [])
+
+ def test_Day_comment(self):
+ """Test Day.by_date()."""
+ self.assertEqual(None, Day.by_date(self.db_conn, '2024-01-01'))
+ d1 = Day('2024-01-01')
+ d1.save(self.db_conn)
+ day_retrieved = Day.by_date(self.db_conn, d1.date)
+ self.assertEqual(day_retrieved.comment, '')
+ d2 = Day('2024-01-02', 'foo')
+ d2.save(self.db_conn)
+ day_retrieved = Day.by_date(self.db_conn, d2.date)
+ self.assertEqual(day_retrieved.comment, 'foo')