| 1 |
from django.db.models import Q |
| 2 |
from django.test import TestCase |
| 3 |
|
| 4 |
from .models import Number |
| 5 |
|
| 6 |
|
| 7 |
class XorLookupsTests(TestCase): |
| 8 |
@classmethod |
| 9 |
def setUpTestData(cls): |
| 10 |
cls.numbers = [Number.objects.create(num=i) for i in range(10)] |
| 11 |
|
| 12 |
def test_filter(self): |
| 13 |
self.assertCountEqual( |
| 14 |
Number.objects.filter(num__lte=7) ^ Number.objects.filter(num__gte=3), |
| 15 |
self.numbers[:3] + self.numbers[8:], |
| 16 |
) |
| 17 |
self.assertCountEqual( |
| 18 |
Number.objects.filter(Q(num__lte=7) ^ Q(num__gte=3)), |
| 19 |
self.numbers[:3] + self.numbers[8:], |
| 20 |
) |
| 21 |
|
| 22 |
def test_filter_multiple(self): |
| 23 |
qs = Number.objects.filter( |
| 24 |
Q(num__gte=1) |
| 25 |
^ Q(num__gte=3) |
| 26 |
^ Q(num__gte=5) |
| 27 |
^ Q(num__gte=7) |
| 28 |
^ Q(num__gte=9) |
| 29 |
) |
| 30 |
self.assertCountEqual( |
| 31 |
qs, |
| 32 |
self.numbers[1:3] + self.numbers[5:7] + self.numbers[9:], |
| 33 |
) |
| 34 |
self.assertCountEqual( |
| 35 |
qs.values_list("num", flat=True), |
| 36 |
[ |
| 37 |
i |
| 38 |
for i in range(10) |
| 39 |
if (i >= 1) ^ (i >= 3) ^ (i >= 5) ^ (i >= 7) ^ (i >= 9) |
| 40 |
], |
| 41 |
) |
| 42 |
|
| 43 |
def test_filter_negated(self): |
| 44 |
self.assertCountEqual( |
| 45 |
Number.objects.filter(Q(num__lte=7) ^ ~Q(num__lt=3)), |
| 46 |
self.numbers[:3] + self.numbers[8:], |
| 47 |
) |
| 48 |
self.assertCountEqual( |
| 49 |
Number.objects.filter(~Q(num__gt=7) ^ ~Q(num__lt=3)), |
| 50 |
self.numbers[:3] + self.numbers[8:], |
| 51 |
) |
| 52 |
self.assertCountEqual( |
| 53 |
Number.objects.filter(Q(num__lte=7) ^ ~Q(num__lt=3) ^ Q(num__lte=1)), |
| 54 |
[self.numbers[2]] + self.numbers[8:], |
| 55 |
) |
| 56 |
self.assertCountEqual( |
| 57 |
Number.objects.filter(~(Q(num__lte=7) ^ ~Q(num__lt=3) ^ Q(num__lte=1))), |
| 58 |
self.numbers[:2] + self.numbers[3:8], |
| 59 |
) |
| 60 |
|
| 61 |
def test_exclude(self): |
| 62 |
self.assertCountEqual( |
| 63 |
Number.objects.exclude(Q(num__lte=7) ^ Q(num__gte=3)), |
| 64 |
self.numbers[3:8], |
| 65 |
) |
| 66 |
|
| 67 |
def test_stages(self): |
| 68 |
numbers = Number.objects.all() |
| 69 |
self.assertSequenceEqual( |
| 70 |
numbers.filter(num__gte=0) ^ numbers.filter(num__lte=11), |
| 71 |
[], |
| 72 |
) |
| 73 |
self.assertSequenceEqual( |
| 74 |
numbers.filter(num__gt=0) ^ numbers.filter(num__lt=11), |
| 75 |
[self.numbers[0]], |
| 76 |
) |
| 77 |
|
| 78 |
def test_pk_q(self): |
| 79 |
self.assertCountEqual( |
| 80 |
Number.objects.filter(Q(pk=self.numbers[0].pk) ^ Q(pk=self.numbers[1].pk)), |
| 81 |
self.numbers[:2], |
| 82 |
) |
| 83 |
|
| 84 |
def test_empty_in(self): |
| 85 |
self.assertCountEqual( |
| 86 |
Number.objects.filter(Q(pk__in=[]) ^ Q(num__gte=5)), |
| 87 |
self.numbers[5:], |
| 88 |
) |