diff options
author | Mariusz Felisiak <felisiak.mariusz@gmail.com> | 2021-05-07 08:46:22 +0200 |
---|---|---|
committer | Carlton Gibson <carlton@noumenal.es> | 2021-05-11 09:19:25 +0200 |
commit | b1a4b1f0bdf05adbd3dc4dde14228e68da54c1a3 (patch) | |
tree | b940d09f1b6d4e8070821f475b72488daf48a3f5 /tests/db_functions | |
parent | 205c36b58fed5a1a0ff462593fc61b58189027d8 (diff) | |
download | django-b1a4b1f0bdf05adbd3dc4dde14228e68da54c1a3.tar.gz |
Fixed #32722 -- Fixed comparing to TruncTime() on Oracle.
Diffstat (limited to 'tests/db_functions')
-rw-r--r-- | tests/db_functions/datetime/test_extract_trunc.py | 21 |
1 files changed, 15 insertions, 6 deletions
diff --git a/tests/db_functions/datetime/test_extract_trunc.py b/tests/db_functions/datetime/test_extract_trunc.py index 75b8a4f0f9..fe80904330 100644 --- a/tests/db_functions/datetime/test_extract_trunc.py +++ b/tests/db_functions/datetime/test_extract_trunc.py @@ -923,19 +923,28 @@ class DateFunctionTests(TestCase): self.create_model(None, None) self.assertIsNone(DTModel.objects.annotate(truncated=TruncTime('start_datetime')).first().truncated) - def test_trunc_time_no_microseconds(self): - start_datetime = datetime(2015, 6, 15, 14, 30, 26) + def test_trunc_time_comparison(self): + start_datetime = datetime(2015, 6, 15, 14, 30, 26) # 0 microseconds. + end_datetime = datetime(2015, 6, 15, 14, 30, 26, 321) if settings.USE_TZ: start_datetime = timezone.make_aware(start_datetime, is_dst=False) - self.create_model(start_datetime, None) + end_datetime = timezone.make_aware(end_datetime, is_dst=False) + self.create_model(start_datetime, end_datetime) self.assertIs( - DTModel.objects.filter(start_datetime__time=start_datetime.time()).exists(), + DTModel.objects.filter( + start_datetime__time=start_datetime.time(), + end_datetime__time=end_datetime.time(), + ).exists(), True, ) self.assertIs( DTModel.objects.annotate( - extracted=TruncTime('start_datetime'), - ).filter(extracted=start_datetime.time()).exists(), + extracted_start=TruncTime('start_datetime'), + extracted_end=TruncTime('end_datetime'), + ).filter( + extracted_start=start_datetime.time(), + extracted_end=end_datetime.time(), + ).exists(), True, ) |