def test_datetime_lookup(self):
past_date = datetime(1999, 1, 1)
future_date = datetime(2999, 2, 2)
for _ in range(0, DBTestCase.NUMBER_OF_RECORDS / 2):
test_model = TestModel()
test_model.save()
test_model.field_5 = past_date
test_model.save()
for _ in range(0, DBTestCase.NUMBER_OF_RECORDS / 2):
test_model = TestModel()
test_model.save()
test_model.field_5 = future_date
test_model.save()
self.assertEqual(
TestModel.objects.filter(field_5__year=past_date.year).count(),
DBTestCase.NUMBER_OF_RECORDS / 2)
self.assertEqual(
TestModel.objects.filter(field_5__month=past_date.month).count(),
DBTestCase.NUMBER_OF_RECORDS / 2)
self.assertEqual(
TestModel.objects.filter(field_5__day=past_date.day).count(),
DBTestCase.NUMBER_OF_RECORDS / 2)
self.assertEqual(
TestModel.objects.filter(field_5__lt=future_date).count(),
DBTestCase.NUMBER_OF_RECORDS / 2)
self.assertEqual(
TestModel.objects.filter(field_5__gt=past_date).count(),
DBTestCase.NUMBER_OF_RECORDS / 2)
self.assertEqual(
TestModel.objects.filter(field_5__range=(past_date,
future_date)).count(),
DBTestCase.NUMBER_OF_RECORDS)
def test_datetime_lookup(self):
past_date = datetime(1999, 1, 1)
future_date = datetime(2999, 2, 2)
for _ in range(0, DBTestCase.NUMBER_OF_RECORDS/2):
test_model = TestModel()
test_model.save()
test_model.field_5 = past_date
test_model.save()
for _ in range(0, DBTestCase.NUMBER_OF_RECORDS/2):
test_model = TestModel()
test_model.save()
test_model.field_5 = future_date
test_model.save()
self.assertEqual(TestModel.objects.filter(field_5__year=past_date.year).count(), DBTestCase.NUMBER_OF_RECORDS/2)
self.assertEqual(TestModel.objects.filter(field_5__month=past_date.month).count(), DBTestCase.NUMBER_OF_RECORDS/2)
self.assertEqual(TestModel.objects.filter(field_5__day=past_date.day).count(), DBTestCase.NUMBER_OF_RECORDS/2)
self.assertEqual(TestModel.objects.filter(field_5__lt=future_date).count(), DBTestCase.NUMBER_OF_RECORDS/2)
self.assertEqual(TestModel.objects.filter(field_5__gt=past_date).count(), DBTestCase.NUMBER_OF_RECORDS/2)
self.assertEqual(TestModel.objects.filter(field_5__range=(past_date, future_date)).count(), DBTestCase.NUMBER_OF_RECORDS)
