def test_filtered_list_view__multiplechoice__qs_filter_field(self):
"""
FIXED : When using qs_filter_field, the behaviour changes because
the HiddenWidget trick only works with filter_field
attribute. But it compares a list with EQUAL operator
instead of IN.
"""
people = ParentModel.objects.create(name='fake')
self.QueryModel.objects.create(organization='A', people=people)
self.QueryModel.objects.create(organization='C', people=people)
view = views.FilteredListView(
qs_filter_fields={'organization': 'organization'},
form_class=self.Form,
model=self.QueryModel)
data = MultiValueDict({"organization": ['A']})
setup_view(view, RequestFactory().get('/fake', data))
self.assertTrue(view.form.is_valid(), view.form.errors)
self.assertIn(
'WHERE "django_genericfilters_querymodel"."organization" IN (A)',
str(view.form_valid(view.form).query))
self.assertEqual(1, view.form_valid(view.form).count())
view = views.FilteredListView(
qs_filter_fields={'organization': 'organization'},
form_class=self.Form,
model=self.QueryModel)
data = MultiValueDict({"organization": ['A', 'C']})
setup_view(view, RequestFactory().get('/fake', data))
self.assertTrue(view.form.is_valid())
self.assertEqual(2, view.form_valid(view.form).count())
def test_filtered_list_view__none(self):
"""
FIXED : None value add "IS NULL" filters instead of ignore it.
"""
view = views.FilteredListView(qs_filter_fields={
'city': 'city',
'people__name': 'people'
},
form_class=self.Form,
model=self.QueryModel)
data = {"city": None, "people": "S"}
setup_view(view, RequestFactory().get('/fake', data))
view.form.is_valid()
self.assertIn('WHERE "django_genericfilters_parentmodel"."name" = S',
str(view.form_valid(view.form).query))
view = views.FilteredListView(qs_filter_fields={
'city': 'city',
'people__name': 'people'
},
form_class=self.Form,
model=self.QueryModel)
data = {"city": "N", "people": None}
setup_view(view, RequestFactory().get('/fake', data))
view.form.is_valid()
self.assertIn('WHERE "django_genericfilters_querymodel"."city" = N',
str(view.form_valid(view.form).query))
def test_filtered_list_view__multiplechoice(self):
"""
FIXED : filtered fields has HiddenWidget widgets that cannot handle
multiple values. Use Field.hidden_widget instead.
"""
view = views.FilteredListView(filter_fields=["organization"],
form_class=self.Form,
model=Something)
data = MultiValueDict({"organization": ["A"]})
setup_view(view, RequestFactory().get("/fake", data))
self.assertTrue(view.form.is_valid(), view.form.errors)
self.assertIn(
'"django_genericfilters_something"."organization" IN (A)',
str(view.form_valid(view.form).query),
)
view = views.FilteredListView(filter_fields=["organization"],
form_class=self.Form,
model=Something)
data = MultiValueDict({"organization": ["A", "C"]})
setup_view(view, RequestFactory().get("/fake", data))
self.assertTrue(view.form.is_valid())
def test_is_form_submitted_method(self):
"""Is form submitted return True when the request method is GET."""
request = RequestFactory().get("/fake", {"foo": "bar"})
view = setup_view(views.FilteredListView(), request)
assert view.is_form_submitted() is True
request = RequestFactory().post("/fake", {"foo": "bar"})
view = setup_view(views.FilteredListView(), request)
assert view.is_form_submitted() is False
def test_filtered_list_view__multiplemodelchoice__qs_filter_field(self):
stateA = Status.objects.create(name="stateA")
stateB = Status.objects.create(name="stateB")
stateC = Status.objects.create(name="stateC")
people = People.objects.create(name="fake")
A = Something.objects.create(organization="A",
people=people,
status=stateA)
B = Something.objects.create(organization="B",
people=people,
status=stateB)
C = Something.objects.create(organization="C",
people=people,
status=stateB)
Something.objects.create(organization="D",
people=people,
status=stateC)
view = views.FilteredListView(
qs_filter_fields={
"city": "city",
"status": "status"
},
form_class=self.Form,
model=Something,
)
data = MultiValueDict({"status": [stateA.pk]})
setup_view(view, RequestFactory().get("/fake", data))
view.form.is_valid()
self.assertIsInstance(view.form.fields["status"].widget,
forms.SelectMultiple)
queryset = view.form_valid(view.form)
self.assertIn("IN (%s)" % stateA.pk, str(queryset.query))
self.assertEqual([A], list(queryset))
view = views.FilteredListView(
qs_filter_fields={
"city": "city",
"status": "status"
},
form_class=self.Form,
model=Something,
)
data = MultiValueDict({"status": [stateA.pk, stateB.pk]})
setup_view(view, RequestFactory().get("/fake", data))
view.form.is_valid()
queryset = view.form_valid(view.form)
self.assertEqual([A, B, C], list(queryset))
def test_filtered_list_view__multiplemodelchoice(self):
"""
FIXED : filtered fields has HiddenWidget widgets that cannot handle
multiple values. Use Field.hidden_widget instead.
"""
stateA = Status.objects.create(name="stateA")
stateB = Status.objects.create(name="stateB")
stateC = Status.objects.create(name="stateC")
people = People.objects.create(name="fake")
A = Something.objects.create(organization="A",
people=people,
status=stateA)
B = Something.objects.create(organization="B",
people=people,
status=stateB)
C = Something.objects.create(organization="C",
people=people,
status=stateB)
Something.objects.create(organization="D",
people=people,
status=stateC)
view = views.FilteredListView(
filter_fields=["city", "status"],
form_class=self.Form,
model=Something,
)
data = MultiValueDict({"status": [stateA.pk]})
setup_view(view, RequestFactory().get("/fake", data))
view.form.is_valid()
self.assertIsInstance(view.form.fields["status"].widget,
forms.MultipleHiddenInput)
queryset = view.form_valid(view.form)
self.assertIn("IN (%s)" % stateA.pk, str(queryset.query))
self.assertEqual([A], list(queryset.all()))
view = views.FilteredListView(
filter_fields=["city", "status"],
form_class=self.Form,
model=Something,
)
data = MultiValueDict({"status": [stateA.pk, stateB.pk]})
setup_view(view, RequestFactory().get("/fake", data))
view.form.is_valid()
queryset = view.form_valid(view.form)
self.assertEqual([A, B, C], list(queryset.all()))
def test_filtered_list_view__multiplemodelchoice__qs_filter_field(self):
stateA = StatusModel.objects.create(name='stateA')
stateB = StatusModel.objects.create(name='stateB')
stateC = StatusModel.objects.create(name='stateC')
people = ParentModel.objects.create(name='fake')
A = self.QueryModel.objects.create(organization='A',
people=people,
status=stateA)
B = self.QueryModel.objects.create(organization='B',
people=people,
status=stateB)
C = self.QueryModel.objects.create(organization='C',
people=people,
status=stateB)
self.QueryModel.objects.create(organization='D',
people=people,
status=stateC)
view = views.FilteredListView(qs_filter_fields={
"city": "city",
"status": "status"
},
form_class=self.Form,
model=self.QueryModel)
data = MultiValueDict({"status": [stateA.pk]})
setup_view(view, RequestFactory().get('/fake', data))
view.form.is_valid()
self.assertIsInstance(view.form.fields['status'].widget,
forms.SelectMultiple)
queryset = view.form_valid(view.form)
self.assertIn('IN (%s)' % stateA.pk, str(queryset.query))
self.assertEqual([A], list(queryset))
view = views.FilteredListView(qs_filter_fields={
"city": "city",
"status": "status"
},
form_class=self.Form,
model=self.QueryModel)
data = MultiValueDict({"status": [stateA.pk, stateB.pk]})
setup_view(view, RequestFactory().get('/fake', data))
view.form.is_valid()
queryset = view.form_valid(view.form)
self.assertEqual([A, B, C], list(queryset))
def test_filtered_list_view__multiplemodelchoice(self):
"""
FIXED : filtered fields has HiddenWidget widgets that cannot handle
multiple values. Use Field.hidden_widget instead.
"""
stateA = StatusModel.objects.create(name='stateA')
stateB = StatusModel.objects.create(name='stateB')
stateC = StatusModel.objects.create(name='stateC')
people = ParentModel.objects.create(name='fake')
A = self.QueryModel.objects.create(organization='A',
people=people,
status=stateA)
B = self.QueryModel.objects.create(organization='B',
people=people,
status=stateB)
C = self.QueryModel.objects.create(organization='C',
people=people,
status=stateB)
self.QueryModel.objects.create(organization='D',
people=people,
status=stateC)
view = views.FilteredListView(filter_fields=["city", 'status'],
form_class=self.Form,
model=self.QueryModel)
data = MultiValueDict({"status": [stateA.pk]})
setup_view(view, RequestFactory().get('/fake', data))
view.form.is_valid()
self.assertIsInstance(view.form.fields['status'].widget,
forms.MultipleHiddenInput)
queryset = view.form_valid(view.form)
self.assertIn('IN (%s)' % stateA.pk, str(queryset.query))
self.assertEqual([A], list(queryset.all()))
view = views.FilteredListView(filter_fields=["city", 'status'],
form_class=self.Form,
model=self.QueryModel)
data = MultiValueDict({"status": [stateA.pk, stateB.pk]})
setup_view(view, RequestFactory().get('/fake', data))
view.form.is_valid()
queryset = view.form_valid(view.form)
self.assertEqual([A, B, C], list(queryset.all()))
def test_default_filter(self):
"""Test the default filter"""
request = RequestFactory().get('/fake')
view = setup_view(
views.FilteredListView(model=self.QueryModel,
form_class=self.Form,
default_filter={
'is_active': '1',
'page': '1'
}), request)
query_filter = urllib.parse.urlencode({'is_active': '1', 'page': '1'})
get_filter = view.get_form_kwargs()
self.assertEqual(get_filter['data'], QueryDict(query_filter))
def test_default_filter_submit(self):
"""Test the default filter submit"""
data = {"city": "N"}
request = RequestFactory().get('/fake', data)
view = setup_view(
views.FilteredListView(model=self.QueryModel,
form_class=self.Form,
default_filter={
'is_active': '1',
'page': '1'
}), request)
query_filter = urllib.parse.urlencode({
'is_active': '1',
'page': '1',
'city': 'N'
})
get_filter = view.get_form_kwargs()
self.assertEqual(get_filter['data'], QueryDict(query_filter))
def test_filtered_list_view__multiplemodelchoice__none(self):
"""
FIXED : Empty queryset in MultipleModelChoiceField is added as
subrequest in filter and raises an sql error instead of
ignore it.
"""
people = ParentModel.objects.create(name='fake')
statusA = StatusModel.objects.create(name='stateA')
statusB = StatusModel.objects.create(name='stateB')
self.QueryModel.objects.create(organization='A',
people=people,
status=statusA)
self.QueryModel.objects.create(organization='C',
people=people,
status=statusB)
view = views.FilteredListView(qs_filter_fields={
"city": "city",
'status': 'status'
},
form_class=self.Form,
model=self.QueryModel)
setup_view(view, RequestFactory().get('/fake', {}))
view.form.is_valid()
# no filter at all
self.assertNotIn('WHERE', str(view.form_valid(view.form).query))
def test_filtered_list_view__multiplemodelchoice__none(self):
"""
FIXED : Empty queryset in MultipleModelChoiceField is added as
subrequest in filter and raises an sql error instead of
ignore it.
"""
people = People.objects.create(name="fake")
statusA = Status.objects.create(name="stateA")
statusB = Status.objects.create(name="stateB")
Something.objects.create(organization="A",
people=people,
status=statusA)
Something.objects.create(organization="C",
people=people,
status=statusB)
view = views.FilteredListView(
qs_filter_fields={
"city": "city",
"status": "status"
},
form_class=self.Form,
model=Something,
)
setup_view(view, RequestFactory().get("/fake", {}))
view.form.is_valid()
# no filter at all
self.assertNotIn("WHERE", str(view.form_valid(view.form).query))
def test_filtered_list_view(self):
a = views.FilteredListView(filter_fields=["city"],
form_class=self.Form,
model=Something)
b = views.FilteredListView(
filter_fields=["city", "people"],
qs_filter_fields={"people__name": "people"},
form_class=self.Form,
model=Something,
)
setattr(
a,
"request",
type("obj", (object, ), {
"method": "GET",
"GET": {
"city": "N"
}
}),
)
setattr(
b,
"request",
type("obj", (object, ), {
"method": "GET",
"GET": {
"people": "S"
}
}),
)
self.assertEqual({"city": "city"}, a.get_qs_filters())
a.form.is_valid()
self.assertIn(
'"django_genericfilters_something"."city" = N',
a.form_valid(a.form).query.__str__(),
)
self.assertEqual({"people__name": "people"}, b.get_qs_filters())
b.form.is_valid()
self.assertIn(
'"django_genericfilters_people"."name" = S',
b.form_valid(b.form).query.__str__(),
)
def test_default_order_fallback_form_empty(self):
"""Queryset is unordered if no default_order or data (empty form)."""
request = RequestFactory().get("/fake")
view = setup_view(
views.FilteredListView(model=Something, form_class=self.Form),
request)
queryset = view.form_empty()
self.assertEqual(list(queryset.query.order_by), [])
def test_default_order_form_empty(self):
"""Queryset is ordered by default_order when no order_by in request."""
request = RequestFactory().get('/fake')
view = setup_view(
views.FilteredListView(model=self.QueryModel,
form_class=self.Form,
default_order='last_name'), request)
queryset = view.form_empty()
self.assertEqual(queryset.query.order_by, ['last_name'])
def test_default_order_fallback_form_valid(self):
"""Queryset is unordered if no default_order or data (valid form)."""
data = {"city": "N"}
view = setup_view(
views.FilteredListView(model=self.QueryModel,
form_class=self.Form),
RequestFactory().get('/fake', data))
view.form.is_valid()
queryset = view.form_valid(view.form)
self.assertEqual(queryset.query.order_by, [])
def test_default_order_form_empty(self):
"""Queryset is ordered by default_order when no order_by in request."""
request = RequestFactory().get("/fake")
view = setup_view(
views.FilteredListView(model=Something,
form_class=self.Form,
default_order="city"),
request,
)
queryset = view.form_empty()
self.assertEqual(list(queryset.query.order_by), ["city"])
def test_default_order_fallback_form_invalid(self):
"""Queryset is unordered if no default_order or data (invalid form)."""
data = {"city": "fake"}
view = setup_view(
views.FilteredListView(model=Something, form_class=self.Form),
RequestFactory().get("/fake", data),
)
view.form.is_valid()
queryset = view.form_invalid(view.form)
self.assertEqual(list(queryset.query.order_by), [])
def test_default_order_in_request(self):
"""Test with order_by in data."""
data = {"city": "N", "order_by": "last_name"}
view = setup_view(
views.FilteredListView(model=self.QueryModel,
form_class=self.Form,
default_order='-last_name'),
RequestFactory().get('/fake', data))
view.form.is_valid()
queryset = view.form_valid(view.form)
self.assertEqual(queryset.query.order_by, ['last_name'])
def test_default_order_form_valid(self):
"""Queryset is ordered by default_order when no order_by in request."""
data = {"city": "N"}
view = setup_view(
views.FilteredListView(model=self.QueryModel,
form_class=self.Form,
default_order='last_name'),
RequestFactory().get('/fake', data))
view.form.is_valid()
queryset = view.form_valid(view.form)
self.assertEqual(queryset.query.order_by, ['last_name'])
def test_default_order_in_request(self):
"""Test with order_by in data."""
data = {"city": "N", "order_by": "city"}
view = setup_view(
views.FilteredListView(model=Something,
form_class=self.Form,
default_order="-city"),
RequestFactory().get("/fake", data),
)
view.form.is_valid()
queryset = view.form_valid(view.form)
self.assertEqual(list(queryset.query.order_by), ["city"])
def test_default_order_form_valid(self):
"""Queryset is ordered by default_order when no order_by in request."""
data = {"city": "N"}
view = setup_view(
views.FilteredListView(model=Something,
form_class=self.Form,
default_order="city"),
RequestFactory().get("/fake", data),
)
view.form.is_valid()
queryset = view.form_valid(view.form)
self.assertEqual(list(queryset.query.order_by), ["city"])
def test_filtered_list_view__multiplechoice__qs_filter_field(self):
"""
FIXED : When using qs_filter_field, the behaviour changes because
the HiddenWidget trick only works with filter_field
attribute. But it compares a list with EQUAL operator
instead of IN.
"""
people = People.objects.create(name="fake")
Something.objects.create(organization="A", people=people)
Something.objects.create(organization="C", people=people)
view = views.FilteredListView(
qs_filter_fields={"organization": "organization"},
form_class=self.Form,
model=Something,
)
data = MultiValueDict({"organization": ["A"]})
setup_view(view, RequestFactory().get("/fake", data))
self.assertTrue(view.form.is_valid(), view.form.errors)
self.assertIn(
'"django_genericfilters_something"."organization" IN (A)',
str(view.form_valid(view.form).query),
)
self.assertEqual(1, view.form_valid(view.form).count())
view = views.FilteredListView(
qs_filter_fields={"organization": "organization"},
form_class=self.Form,
model=Something,
)
data = MultiValueDict({"organization": ["A", "C"]})
setup_view(view, RequestFactory().get("/fake", data))
self.assertTrue(view.form.is_valid())
self.assertEqual(2, view.form_valid(view.form).count())
def test_filtered_list_view__none(self):
"""
FIXED : None value understood as "IS NULL" filter instead of being ignored.
"""
view = views.FilteredListView(
qs_filter_fields={
"city": "city",
"people__name": "people"
},
form_class=self.Form,
model=Something,
)
data = {"city": "None", "people": "S"}
setup_view(view, RequestFactory().get("/fake", data))
view.form.is_valid()
self.assertIn(
'"django_genericfilters_people"."name" = S',
str(view.form_valid(view.form).query),
)
view = views.FilteredListView(
qs_filter_fields={
"city": "city",
"people__name": "people"
},
form_class=self.Form,
model=Something,
)
data = {"city": "N", "people": "None"}
setup_view(view, RequestFactory().get("/fake", data))
view.form.is_valid()
self.assertIn(
'"django_genericfilters_something"."city" = N',
str(view.form_valid(view.form).query),
)
def test_filtered_list_view__multiplechoice(self):
"""
FIXED : filtered fields has HiddenWidget widgets that cannot handle
multiple values. Use Field.hidden_widget instead.
"""
view = views.FilteredListView(filter_fields=['organization'],
form_class=self.Form,
model=self.QueryModel)
data = MultiValueDict({"organization": ['A']})
setup_view(view, RequestFactory().get('/fake', data))
self.assertTrue(view.form.is_valid(), view.form.errors)
self.assertIn(
'WHERE "django_genericfilters_querymodel"."organization" IN (A)',
str(view.form_valid(view.form).query))
view = views.FilteredListView(filter_fields=['organization'],
form_class=self.Form,
model=self.QueryModel)
data = MultiValueDict({"organization": ['A', 'C']})
setup_view(view, RequestFactory().get('/fake', data))
self.assertTrue(view.form.is_valid())
def test_filtered_list_view(self):
a = views.FilteredListView(filter_fields=['city'],
form_class=self.Form,
model=self.QueryModel)
b = views.FilteredListView(filter_fields=['city', 'people'],
qs_filter_fields={'people__name': 'people'},
form_class=self.Form,
model=self.QueryModel)
setattr(
a, 'request',
type('obj', (object, ), {
"method": "GET",
"GET": {
"city": "N"
}
}))
setattr(
b, 'request',
type('obj', (object, ), {
"method": "GET",
"GET": {
"people": "S"
}
}))
self.assertEqual({'city': 'city'}, a.get_qs_filters())
a.form.is_valid()
self.assertIn('WHERE "django_genericfilters_querymodel"."city" = N',
a.form_valid(a.form).query.__str__())
self.assertEqual({'people__name': 'people'}, b.get_qs_filters())
b.form.is_valid()
self.assertIn('WHERE "django_genericfilters_parentmodel"."name" = S',
b.form_valid(b.form).query.__str__())
def test_filtered_list_view__modelchoice(self):
peopleA = ParentModel.objects.create(name='fakeA')
view = views.FilteredListView(qs_filter_fields={
'city': 'city',
'people': 'parent'
},
form_class=self.Form,
model=self.QueryModel)
data = {"parent": peopleA.pk}
setup_view(view, RequestFactory().get('/fake', data))
view.form.is_valid()
self.assertIn(
'WHERE "django_genericfilters_querymodel"."people_id" = %s' %
(peopleA.pk, ), str(view.form_valid(view.form).query))
def test_filtered_list_view__modelchoice__empty_queryset(self):
"""
FIXED : Empty queryset in ModelChoiceField add "IS NULL" filters
instead of ignore it.
"""
view = views.FilteredListView(qs_filter_fields={
'city': 'city',
'people': 'parent'
},
form_class=self.Form,
model=self.QueryModel)
data = {"city": "N", "parent": 1}
setup_view(view, RequestFactory().get('/fake', data))
view.form.is_valid()
self.assertIn('WHERE "django_genericfilters_querymodel"."city" = N',
str(view.form_valid(view.form).query))
def test_default_filter(self):
"""Test the default filter"""
request = RequestFactory().get("/fake")
view = setup_view(
views.FilteredListView(
model=Something,
form_class=self.Form,
default_filter={
"is_active": "1",
"page": "1"
},
),
request,
)
query_filter = urllib.parse.urlencode({"is_active": "1", "page": "1"})
get_filter = view.get_form_kwargs()
self.assertEqual(get_filter["data"], QueryDict(query_filter))
def test_filtered_list_view__multiplemodelchoice__invalid_id(self):
"""
FIXED : Invalid id in MultipleModelChoiceField generate a None
value and add "IS NULL" filter instead of ignore it.
"""
StatusModel.objects.create(name='stateA')
StatusModel.objects.create(name='stateB')
view = views.FilteredListView(qs_filter_fields={
"city": "city",
'status': 'status'
},
form_class=self.Form,
model=self.QueryModel)
data = MultiValueDict({"status": [1001]})
setup_view(view, RequestFactory().get('/fake', data))
view.form.is_valid()
# no filter at all
self.assertNotIn('WHERE', str(view.form_valid(view.form).query))
def test_filtered_list_view__modelchoice(self):
peopleA = People.objects.create(name="fakeA")
view = views.FilteredListView(
qs_filter_fields={
"city": "city",
"people": "parent"
},
form_class=self.Form,
model=Something,
)
data = {"parent": peopleA.pk}
setup_view(view, RequestFactory().get("/fake", data))
view.form.is_valid()
self.assertIn(
'"django_genericfilters_something"."people_id" = %s' %
(peopleA.pk, ),
str(view.form_valid(view.form).query),
)
