tests.py 65 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498
  1. import datetime
  2. from django.contrib import admin
  3. from django.contrib.admin.models import LogEntry
  4. from django.contrib.admin.options import IncorrectLookupParameters
  5. from django.contrib.admin.templatetags.admin_list import pagination
  6. from django.contrib.admin.tests import AdminSeleniumTestCase
  7. from django.contrib.admin.views.main import (
  8. ALL_VAR, IS_POPUP_VAR, ORDER_VAR, PAGE_VAR, SEARCH_VAR, TO_FIELD_VAR,
  9. )
  10. from django.contrib.auth.models import User
  11. from django.contrib.contenttypes.models import ContentType
  12. from django.contrib.messages.storage.cookie import CookieStorage
  13. from django.db import connection, models
  14. from django.db.models import F, Field, IntegerField
  15. from django.db.models.functions import Upper
  16. from django.db.models.lookups import Contains, Exact
  17. from django.template import Context, Template, TemplateSyntaxError
  18. from django.test import TestCase, override_settings
  19. from django.test.client import RequestFactory
  20. from django.test.utils import (
  21. CaptureQueriesContext, isolate_apps, register_lookup,
  22. )
  23. from django.urls import reverse
  24. from django.utils import formats
  25. from .admin import (
  26. BandAdmin, ChildAdmin, ChordsBandAdmin, ConcertAdmin,
  27. CustomPaginationAdmin, CustomPaginator, DynamicListDisplayChildAdmin,
  28. DynamicListDisplayLinksChildAdmin, DynamicListFilterChildAdmin,
  29. DynamicSearchFieldsChildAdmin, EmptyValueChildAdmin, EventAdmin,
  30. FilteredChildAdmin, GroupAdmin, InvitationAdmin,
  31. NoListDisplayLinksParentAdmin, ParentAdmin, QuartetAdmin, SwallowAdmin,
  32. site as custom_site,
  33. )
  34. from .models import (
  35. Band, CharPK, Child, ChordsBand, ChordsMusician, Concert, CustomIdUser,
  36. Event, Genre, Group, Invitation, Membership, Musician, OrderedObject,
  37. Parent, Quartet, Swallow, SwallowOneToOne, UnorderedObject,
  38. )
  39. def build_tbody_html(pk, href, extra_fields):
  40. return (
  41. '<tbody><tr>'
  42. '<td class="action-checkbox">'
  43. '<input type="checkbox" name="_selected_action" value="{}" '
  44. 'class="action-select"></td>'
  45. '<th class="field-name"><a href="{}">name</a></th>'
  46. '{}</tr></tbody>'
  47. ).format(pk, href, extra_fields)
  48. @override_settings(ROOT_URLCONF="admin_changelist.urls")
  49. class ChangeListTests(TestCase):
  50. factory = RequestFactory()
  51. @classmethod
  52. def setUpTestData(cls):
  53. cls.superuser = User.objects.create_superuser(username='super', email='a@b.com', password='xxx')
  54. def _create_superuser(self, username):
  55. return User.objects.create_superuser(username=username, email='a@b.com', password='xxx')
  56. def _mocked_authenticated_request(self, url, user):
  57. request = self.factory.get(url)
  58. request.user = user
  59. return request
  60. def test_specified_ordering_by_f_expression(self):
  61. class OrderedByFBandAdmin(admin.ModelAdmin):
  62. list_display = ['name', 'genres', 'nr_of_members']
  63. ordering = (
  64. F('nr_of_members').desc(nulls_last=True),
  65. Upper(F('name')).asc(),
  66. F('genres').asc(),
  67. )
  68. m = OrderedByFBandAdmin(Band, custom_site)
  69. request = self.factory.get('/band/')
  70. request.user = self.superuser
  71. cl = m.get_changelist_instance(request)
  72. self.assertEqual(cl.get_ordering_field_columns(), {3: 'desc', 2: 'asc'})
  73. def test_specified_ordering_by_f_expression_without_asc_desc(self):
  74. class OrderedByFBandAdmin(admin.ModelAdmin):
  75. list_display = ['name', 'genres', 'nr_of_members']
  76. ordering = (F('nr_of_members'), Upper('name'), F('genres'))
  77. m = OrderedByFBandAdmin(Band, custom_site)
  78. request = self.factory.get('/band/')
  79. request.user = self.superuser
  80. cl = m.get_changelist_instance(request)
  81. self.assertEqual(cl.get_ordering_field_columns(), {3: 'asc', 2: 'asc'})
  82. def test_select_related_preserved(self):
  83. """
  84. Regression test for #10348: ChangeList.get_queryset() shouldn't
  85. overwrite a custom select_related provided by ModelAdmin.get_queryset().
  86. """
  87. m = ChildAdmin(Child, custom_site)
  88. request = self.factory.get('/child/')
  89. request.user = self.superuser
  90. cl = m.get_changelist_instance(request)
  91. self.assertEqual(cl.queryset.query.select_related, {'parent': {}})
  92. def test_select_related_as_tuple(self):
  93. ia = InvitationAdmin(Invitation, custom_site)
  94. request = self.factory.get('/invitation/')
  95. request.user = self.superuser
  96. cl = ia.get_changelist_instance(request)
  97. self.assertEqual(cl.queryset.query.select_related, {'player': {}})
  98. def test_select_related_as_empty_tuple(self):
  99. ia = InvitationAdmin(Invitation, custom_site)
  100. ia.list_select_related = ()
  101. request = self.factory.get('/invitation/')
  102. request.user = self.superuser
  103. cl = ia.get_changelist_instance(request)
  104. self.assertIs(cl.queryset.query.select_related, False)
  105. def test_get_select_related_custom_method(self):
  106. class GetListSelectRelatedAdmin(admin.ModelAdmin):
  107. list_display = ('band', 'player')
  108. def get_list_select_related(self, request):
  109. return ('band', 'player')
  110. ia = GetListSelectRelatedAdmin(Invitation, custom_site)
  111. request = self.factory.get('/invitation/')
  112. request.user = self.superuser
  113. cl = ia.get_changelist_instance(request)
  114. self.assertEqual(cl.queryset.query.select_related, {'player': {}, 'band': {}})
  115. def test_result_list_empty_changelist_value(self):
  116. """
  117. Regression test for #14982: EMPTY_CHANGELIST_VALUE should be honored
  118. for relationship fields
  119. """
  120. new_child = Child.objects.create(name='name', parent=None)
  121. request = self.factory.get('/child/')
  122. request.user = self.superuser
  123. m = ChildAdmin(Child, custom_site)
  124. cl = m.get_changelist_instance(request)
  125. cl.formset = None
  126. template = Template('{% load admin_list %}{% spaceless %}{% result_list cl %}{% endspaceless %}')
  127. context = Context({'cl': cl, 'opts': Child._meta})
  128. table_output = template.render(context)
  129. link = reverse('admin:admin_changelist_child_change', args=(new_child.id,))
  130. row_html = build_tbody_html(new_child.id, link, '<td class="field-parent nowrap">-</td>')
  131. self.assertNotEqual(table_output.find(row_html), -1, 'Failed to find expected row element: %s' % table_output)
  132. def test_result_list_set_empty_value_display_on_admin_site(self):
  133. """
  134. Empty value display can be set on AdminSite.
  135. """
  136. new_child = Child.objects.create(name='name', parent=None)
  137. request = self.factory.get('/child/')
  138. request.user = self.superuser
  139. # Set a new empty display value on AdminSite.
  140. admin.site.empty_value_display = '???'
  141. m = ChildAdmin(Child, admin.site)
  142. cl = m.get_changelist_instance(request)
  143. cl.formset = None
  144. template = Template('{% load admin_list %}{% spaceless %}{% result_list cl %}{% endspaceless %}')
  145. context = Context({'cl': cl, 'opts': Child._meta})
  146. table_output = template.render(context)
  147. link = reverse('admin:admin_changelist_child_change', args=(new_child.id,))
  148. row_html = build_tbody_html(new_child.id, link, '<td class="field-parent nowrap">???</td>')
  149. self.assertNotEqual(table_output.find(row_html), -1, 'Failed to find expected row element: %s' % table_output)
  150. def test_result_list_set_empty_value_display_in_model_admin(self):
  151. """
  152. Empty value display can be set in ModelAdmin or individual fields.
  153. """
  154. new_child = Child.objects.create(name='name', parent=None)
  155. request = self.factory.get('/child/')
  156. request.user = self.superuser
  157. m = EmptyValueChildAdmin(Child, admin.site)
  158. cl = m.get_changelist_instance(request)
  159. cl.formset = None
  160. template = Template('{% load admin_list %}{% spaceless %}{% result_list cl %}{% endspaceless %}')
  161. context = Context({'cl': cl, 'opts': Child._meta})
  162. table_output = template.render(context)
  163. link = reverse('admin:admin_changelist_child_change', args=(new_child.id,))
  164. row_html = build_tbody_html(
  165. new_child.id,
  166. link,
  167. '<td class="field-age_display">&amp;dagger;</td>'
  168. '<td class="field-age">-empty-</td>'
  169. )
  170. self.assertNotEqual(table_output.find(row_html), -1, 'Failed to find expected row element: %s' % table_output)
  171. def test_result_list_html(self):
  172. """
  173. Inclusion tag result_list generates a table when with default
  174. ModelAdmin settings.
  175. """
  176. new_parent = Parent.objects.create(name='parent')
  177. new_child = Child.objects.create(name='name', parent=new_parent)
  178. request = self.factory.get('/child/')
  179. request.user = self.superuser
  180. m = ChildAdmin(Child, custom_site)
  181. cl = m.get_changelist_instance(request)
  182. cl.formset = None
  183. template = Template('{% load admin_list %}{% spaceless %}{% result_list cl %}{% endspaceless %}')
  184. context = Context({'cl': cl, 'opts': Child._meta})
  185. table_output = template.render(context)
  186. link = reverse('admin:admin_changelist_child_change', args=(new_child.id,))
  187. row_html = build_tbody_html(new_child.id, link, '<td class="field-parent nowrap">%s</td>' % new_parent)
  188. self.assertNotEqual(table_output.find(row_html), -1, 'Failed to find expected row element: %s' % table_output)
  189. def test_result_list_editable_html(self):
  190. """
  191. Regression tests for #11791: Inclusion tag result_list generates a
  192. table and this checks that the items are nested within the table
  193. element tags.
  194. Also a regression test for #13599, verifies that hidden fields
  195. when list_editable is enabled are rendered in a div outside the
  196. table.
  197. """
  198. new_parent = Parent.objects.create(name='parent')
  199. new_child = Child.objects.create(name='name', parent=new_parent)
  200. request = self.factory.get('/child/')
  201. request.user = self.superuser
  202. m = ChildAdmin(Child, custom_site)
  203. # Test with list_editable fields
  204. m.list_display = ['id', 'name', 'parent']
  205. m.list_display_links = ['id']
  206. m.list_editable = ['name']
  207. cl = m.get_changelist_instance(request)
  208. FormSet = m.get_changelist_formset(request)
  209. cl.formset = FormSet(queryset=cl.result_list)
  210. template = Template('{% load admin_list %}{% spaceless %}{% result_list cl %}{% endspaceless %}')
  211. context = Context({'cl': cl, 'opts': Child._meta})
  212. table_output = template.render(context)
  213. # make sure that hidden fields are in the correct place
  214. hiddenfields_div = (
  215. '<div class="hiddenfields">'
  216. '<input type="hidden" name="form-0-id" value="%d" id="id_form-0-id">'
  217. '</div>'
  218. ) % new_child.id
  219. self.assertInHTML(hiddenfields_div, table_output, msg_prefix='Failed to find hidden fields')
  220. # make sure that list editable fields are rendered in divs correctly
  221. editable_name_field = (
  222. '<input name="form-0-name" value="name" class="vTextField" '
  223. 'maxlength="30" type="text" id="id_form-0-name">'
  224. )
  225. self.assertInHTML(
  226. '<td class="field-name">%s</td>' % editable_name_field,
  227. table_output,
  228. msg_prefix='Failed to find "name" list_editable field',
  229. )
  230. def test_result_list_editable(self):
  231. """
  232. Regression test for #14312: list_editable with pagination
  233. """
  234. new_parent = Parent.objects.create(name='parent')
  235. for i in range(1, 201):
  236. Child.objects.create(name='name %s' % i, parent=new_parent)
  237. request = self.factory.get('/child/', data={'p': -1}) # Anything outside range
  238. request.user = self.superuser
  239. m = ChildAdmin(Child, custom_site)
  240. # Test with list_editable fields
  241. m.list_display = ['id', 'name', 'parent']
  242. m.list_display_links = ['id']
  243. m.list_editable = ['name']
  244. with self.assertRaises(IncorrectLookupParameters):
  245. m.get_changelist_instance(request)
  246. def test_custom_paginator(self):
  247. new_parent = Parent.objects.create(name='parent')
  248. for i in range(1, 201):
  249. Child.objects.create(name='name %s' % i, parent=new_parent)
  250. request = self.factory.get('/child/')
  251. request.user = self.superuser
  252. m = CustomPaginationAdmin(Child, custom_site)
  253. cl = m.get_changelist_instance(request)
  254. cl.get_results(request)
  255. self.assertIsInstance(cl.paginator, CustomPaginator)
  256. def test_distinct_for_m2m_in_list_filter(self):
  257. """
  258. Regression test for #13902: When using a ManyToMany in list_filter,
  259. results shouldn't appear more than once. Basic ManyToMany.
  260. """
  261. blues = Genre.objects.create(name='Blues')
  262. band = Band.objects.create(name='B.B. King Review', nr_of_members=11)
  263. band.genres.add(blues)
  264. band.genres.add(blues)
  265. m = BandAdmin(Band, custom_site)
  266. request = self.factory.get('/band/', data={'genres': blues.pk})
  267. request.user = self.superuser
  268. cl = m.get_changelist_instance(request)
  269. cl.get_results(request)
  270. # There's only one Group instance
  271. self.assertEqual(cl.result_count, 1)
  272. def test_distinct_for_through_m2m_in_list_filter(self):
  273. """
  274. Regression test for #13902: When using a ManyToMany in list_filter,
  275. results shouldn't appear more than once. With an intermediate model.
  276. """
  277. lead = Musician.objects.create(name='Vox')
  278. band = Group.objects.create(name='The Hype')
  279. Membership.objects.create(group=band, music=lead, role='lead voice')
  280. Membership.objects.create(group=band, music=lead, role='bass player')
  281. m = GroupAdmin(Group, custom_site)
  282. request = self.factory.get('/group/', data={'members': lead.pk})
  283. request.user = self.superuser
  284. cl = m.get_changelist_instance(request)
  285. cl.get_results(request)
  286. # There's only one Group instance
  287. self.assertEqual(cl.result_count, 1)
  288. def test_distinct_for_through_m2m_at_second_level_in_list_filter(self):
  289. """
  290. When using a ManyToMany in list_filter at the second level behind a
  291. ForeignKey, distinct() must be called and results shouldn't appear more
  292. than once.
  293. """
  294. lead = Musician.objects.create(name='Vox')
  295. band = Group.objects.create(name='The Hype')
  296. Concert.objects.create(name='Woodstock', group=band)
  297. Membership.objects.create(group=band, music=lead, role='lead voice')
  298. Membership.objects.create(group=band, music=lead, role='bass player')
  299. m = ConcertAdmin(Concert, custom_site)
  300. request = self.factory.get('/concert/', data={'group__members': lead.pk})
  301. request.user = self.superuser
  302. cl = m.get_changelist_instance(request)
  303. cl.get_results(request)
  304. # There's only one Concert instance
  305. self.assertEqual(cl.result_count, 1)
  306. def test_distinct_for_inherited_m2m_in_list_filter(self):
  307. """
  308. Regression test for #13902: When using a ManyToMany in list_filter,
  309. results shouldn't appear more than once. Model managed in the
  310. admin inherits from the one that defines the relationship.
  311. """
  312. lead = Musician.objects.create(name='John')
  313. four = Quartet.objects.create(name='The Beatles')
  314. Membership.objects.create(group=four, music=lead, role='lead voice')
  315. Membership.objects.create(group=four, music=lead, role='guitar player')
  316. m = QuartetAdmin(Quartet, custom_site)
  317. request = self.factory.get('/quartet/', data={'members': lead.pk})
  318. request.user = self.superuser
  319. cl = m.get_changelist_instance(request)
  320. cl.get_results(request)
  321. # There's only one Quartet instance
  322. self.assertEqual(cl.result_count, 1)
  323. def test_distinct_for_m2m_to_inherited_in_list_filter(self):
  324. """
  325. Regression test for #13902: When using a ManyToMany in list_filter,
  326. results shouldn't appear more than once. Target of the relationship
  327. inherits from another.
  328. """
  329. lead = ChordsMusician.objects.create(name='Player A')
  330. three = ChordsBand.objects.create(name='The Chords Trio')
  331. Invitation.objects.create(band=three, player=lead, instrument='guitar')
  332. Invitation.objects.create(band=three, player=lead, instrument='bass')
  333. m = ChordsBandAdmin(ChordsBand, custom_site)
  334. request = self.factory.get('/chordsband/', data={'members': lead.pk})
  335. request.user = self.superuser
  336. cl = m.get_changelist_instance(request)
  337. cl.get_results(request)
  338. # There's only one ChordsBand instance
  339. self.assertEqual(cl.result_count, 1)
  340. def test_distinct_for_non_unique_related_object_in_list_filter(self):
  341. """
  342. Regressions tests for #15819: If a field listed in list_filters
  343. is a non-unique related object, distinct() must be called.
  344. """
  345. parent = Parent.objects.create(name='Mary')
  346. # Two children with the same name
  347. Child.objects.create(parent=parent, name='Daniel')
  348. Child.objects.create(parent=parent, name='Daniel')
  349. m = ParentAdmin(Parent, custom_site)
  350. request = self.factory.get('/parent/', data={'child__name': 'Daniel'})
  351. request.user = self.superuser
  352. cl = m.get_changelist_instance(request)
  353. # Make sure distinct() was called
  354. self.assertEqual(cl.queryset.count(), 1)
  355. def test_changelist_search_form_validation(self):
  356. m = ConcertAdmin(Concert, custom_site)
  357. tests = [
  358. ({SEARCH_VAR: '\x00'}, 'Null characters are not allowed.'),
  359. ({SEARCH_VAR: 'some\x00thing'}, 'Null characters are not allowed.'),
  360. ]
  361. for case, error in tests:
  362. with self.subTest(case=case):
  363. request = self.factory.get('/concert/', case)
  364. request.user = self.superuser
  365. request._messages = CookieStorage(request)
  366. m.get_changelist_instance(request)
  367. messages = [m.message for m in request._messages]
  368. self.assertEqual(1, len(messages))
  369. self.assertEqual(error, messages[0])
  370. def test_distinct_for_non_unique_related_object_in_search_fields(self):
  371. """
  372. Regressions tests for #15819: If a field listed in search_fields
  373. is a non-unique related object, distinct() must be called.
  374. """
  375. parent = Parent.objects.create(name='Mary')
  376. Child.objects.create(parent=parent, name='Danielle')
  377. Child.objects.create(parent=parent, name='Daniel')
  378. m = ParentAdmin(Parent, custom_site)
  379. request = self.factory.get('/parent/', data={SEARCH_VAR: 'daniel'})
  380. request.user = self.superuser
  381. cl = m.get_changelist_instance(request)
  382. # Make sure distinct() was called
  383. self.assertEqual(cl.queryset.count(), 1)
  384. def test_distinct_for_many_to_many_at_second_level_in_search_fields(self):
  385. """
  386. When using a ManyToMany in search_fields at the second level behind a
  387. ForeignKey, distinct() must be called and results shouldn't appear more
  388. than once.
  389. """
  390. lead = Musician.objects.create(name='Vox')
  391. band = Group.objects.create(name='The Hype')
  392. Concert.objects.create(name='Woodstock', group=band)
  393. Membership.objects.create(group=band, music=lead, role='lead voice')
  394. Membership.objects.create(group=band, music=lead, role='bass player')
  395. m = ConcertAdmin(Concert, custom_site)
  396. request = self.factory.get('/concert/', data={SEARCH_VAR: 'vox'})
  397. request.user = self.superuser
  398. cl = m.get_changelist_instance(request)
  399. # There's only one Concert instance
  400. self.assertEqual(cl.queryset.count(), 1)
  401. def test_pk_in_search_fields(self):
  402. band = Group.objects.create(name='The Hype')
  403. Concert.objects.create(name='Woodstock', group=band)
  404. m = ConcertAdmin(Concert, custom_site)
  405. m.search_fields = ['group__pk']
  406. request = self.factory.get('/concert/', data={SEARCH_VAR: band.pk})
  407. request.user = self.superuser
  408. cl = m.get_changelist_instance(request)
  409. self.assertEqual(cl.queryset.count(), 1)
  410. request = self.factory.get('/concert/', data={SEARCH_VAR: band.pk + 5})
  411. request.user = self.superuser
  412. cl = m.get_changelist_instance(request)
  413. self.assertEqual(cl.queryset.count(), 0)
  414. def test_builtin_lookup_in_search_fields(self):
  415. band = Group.objects.create(name='The Hype')
  416. concert = Concert.objects.create(name='Woodstock', group=band)
  417. m = ConcertAdmin(Concert, custom_site)
  418. m.search_fields = ['name__iexact']
  419. request = self.factory.get('/', data={SEARCH_VAR: 'woodstock'})
  420. request.user = self.superuser
  421. cl = m.get_changelist_instance(request)
  422. self.assertCountEqual(cl.queryset, [concert])
  423. request = self.factory.get('/', data={SEARCH_VAR: 'wood'})
  424. request.user = self.superuser
  425. cl = m.get_changelist_instance(request)
  426. self.assertCountEqual(cl.queryset, [])
  427. def test_custom_lookup_in_search_fields(self):
  428. band = Group.objects.create(name='The Hype')
  429. concert = Concert.objects.create(name='Woodstock', group=band)
  430. m = ConcertAdmin(Concert, custom_site)
  431. m.search_fields = ['group__name__cc']
  432. with register_lookup(Field, Contains, lookup_name='cc'):
  433. request = self.factory.get('/', data={SEARCH_VAR: 'Hype'})
  434. request.user = self.superuser
  435. cl = m.get_changelist_instance(request)
  436. self.assertCountEqual(cl.queryset, [concert])
  437. request = self.factory.get('/', data={SEARCH_VAR: 'Woodstock'})
  438. request.user = self.superuser
  439. cl = m.get_changelist_instance(request)
  440. self.assertCountEqual(cl.queryset, [])
  441. def test_spanning_relations_with_custom_lookup_in_search_fields(self):
  442. hype = Group.objects.create(name='The Hype')
  443. concert = Concert.objects.create(name='Woodstock', group=hype)
  444. vox = Musician.objects.create(name='Vox', age=20)
  445. Membership.objects.create(music=vox, group=hype)
  446. # Register a custom lookup on IntegerField to ensure that field
  447. # traversing logic in ModelAdmin.get_search_results() works.
  448. with register_lookup(IntegerField, Exact, lookup_name='exactly'):
  449. m = ConcertAdmin(Concert, custom_site)
  450. m.search_fields = ['group__members__age__exactly']
  451. request = self.factory.get('/', data={SEARCH_VAR: '20'})
  452. request.user = self.superuser
  453. cl = m.get_changelist_instance(request)
  454. self.assertCountEqual(cl.queryset, [concert])
  455. request = self.factory.get('/', data={SEARCH_VAR: '21'})
  456. request.user = self.superuser
  457. cl = m.get_changelist_instance(request)
  458. self.assertCountEqual(cl.queryset, [])
  459. def test_custom_lookup_with_pk_shortcut(self):
  460. self.assertEqual(CharPK._meta.pk.name, 'char_pk') # Not equal to 'pk'.
  461. m = admin.ModelAdmin(CustomIdUser, custom_site)
  462. abc = CharPK.objects.create(char_pk='abc')
  463. abcd = CharPK.objects.create(char_pk='abcd')
  464. m = admin.ModelAdmin(CharPK, custom_site)
  465. m.search_fields = ['pk__exact']
  466. request = self.factory.get('/', data={SEARCH_VAR: 'abc'})
  467. request.user = self.superuser
  468. cl = m.get_changelist_instance(request)
  469. self.assertCountEqual(cl.queryset, [abc])
  470. request = self.factory.get('/', data={SEARCH_VAR: 'abcd'})
  471. request.user = self.superuser
  472. cl = m.get_changelist_instance(request)
  473. self.assertCountEqual(cl.queryset, [abcd])
  474. def test_no_distinct_for_m2m_in_list_filter_without_params(self):
  475. """
  476. If a ManyToManyField is in list_filter but isn't in any lookup params,
  477. the changelist's query shouldn't have distinct.
  478. """
  479. m = BandAdmin(Band, custom_site)
  480. for lookup_params in ({}, {'name': 'test'}):
  481. request = self.factory.get('/band/', lookup_params)
  482. request.user = self.superuser
  483. cl = m.get_changelist_instance(request)
  484. self.assertFalse(cl.queryset.query.distinct)
  485. # A ManyToManyField in params does have distinct applied.
  486. request = self.factory.get('/band/', {'genres': '0'})
  487. request.user = self.superuser
  488. cl = m.get_changelist_instance(request)
  489. self.assertTrue(cl.queryset.query.distinct)
  490. def test_pagination(self):
  491. """
  492. Regression tests for #12893: Pagination in admins changelist doesn't
  493. use queryset set by modeladmin.
  494. """
  495. parent = Parent.objects.create(name='anything')
  496. for i in range(1, 31):
  497. Child.objects.create(name='name %s' % i, parent=parent)
  498. Child.objects.create(name='filtered %s' % i, parent=parent)
  499. request = self.factory.get('/child/')
  500. request.user = self.superuser
  501. # Test default queryset
  502. m = ChildAdmin(Child, custom_site)
  503. cl = m.get_changelist_instance(request)
  504. self.assertEqual(cl.queryset.count(), 60)
  505. self.assertEqual(cl.paginator.count, 60)
  506. self.assertEqual(list(cl.paginator.page_range), [1, 2, 3, 4, 5, 6])
  507. # Test custom queryset
  508. m = FilteredChildAdmin(Child, custom_site)
  509. cl = m.get_changelist_instance(request)
  510. self.assertEqual(cl.queryset.count(), 30)
  511. self.assertEqual(cl.paginator.count, 30)
  512. self.assertEqual(list(cl.paginator.page_range), [1, 2, 3])
  513. def test_computed_list_display_localization(self):
  514. """
  515. Regression test for #13196: output of functions should be localized
  516. in the changelist.
  517. """
  518. self.client.force_login(self.superuser)
  519. event = Event.objects.create(date=datetime.date.today())
  520. response = self.client.get(reverse('admin:admin_changelist_event_changelist'))
  521. self.assertContains(response, formats.localize(event.date))
  522. self.assertNotContains(response, str(event.date))
  523. def test_dynamic_list_display(self):
  524. """
  525. Regression tests for #14206: dynamic list_display support.
  526. """
  527. parent = Parent.objects.create(name='parent')
  528. for i in range(10):
  529. Child.objects.create(name='child %s' % i, parent=parent)
  530. user_noparents = self._create_superuser('noparents')
  531. user_parents = self._create_superuser('parents')
  532. # Test with user 'noparents'
  533. m = custom_site._registry[Child]
  534. request = self._mocked_authenticated_request('/child/', user_noparents)
  535. response = m.changelist_view(request)
  536. self.assertNotContains(response, 'Parent object')
  537. list_display = m.get_list_display(request)
  538. list_display_links = m.get_list_display_links(request, list_display)
  539. self.assertEqual(list_display, ['name', 'age'])
  540. self.assertEqual(list_display_links, ['name'])
  541. # Test with user 'parents'
  542. m = DynamicListDisplayChildAdmin(Child, custom_site)
  543. request = self._mocked_authenticated_request('/child/', user_parents)
  544. response = m.changelist_view(request)
  545. self.assertContains(response, 'Parent object')
  546. custom_site.unregister(Child)
  547. list_display = m.get_list_display(request)
  548. list_display_links = m.get_list_display_links(request, list_display)
  549. self.assertEqual(list_display, ('parent', 'name', 'age'))
  550. self.assertEqual(list_display_links, ['parent'])
  551. # Test default implementation
  552. custom_site.register(Child, ChildAdmin)
  553. m = custom_site._registry[Child]
  554. request = self._mocked_authenticated_request('/child/', user_noparents)
  555. response = m.changelist_view(request)
  556. self.assertContains(response, 'Parent object')
  557. def test_show_all(self):
  558. parent = Parent.objects.create(name='anything')
  559. for i in range(1, 31):
  560. Child.objects.create(name='name %s' % i, parent=parent)
  561. Child.objects.create(name='filtered %s' % i, parent=parent)
  562. # Add "show all" parameter to request
  563. request = self.factory.get('/child/', data={ALL_VAR: ''})
  564. request.user = self.superuser
  565. # Test valid "show all" request (number of total objects is under max)
  566. m = ChildAdmin(Child, custom_site)
  567. m.list_max_show_all = 200
  568. # 200 is the max we'll pass to ChangeList
  569. cl = m.get_changelist_instance(request)
  570. cl.get_results(request)
  571. self.assertEqual(len(cl.result_list), 60)
  572. # Test invalid "show all" request (number of total objects over max)
  573. # falls back to paginated pages
  574. m = ChildAdmin(Child, custom_site)
  575. m.list_max_show_all = 30
  576. # 30 is the max we'll pass to ChangeList for this test
  577. cl = m.get_changelist_instance(request)
  578. cl.get_results(request)
  579. self.assertEqual(len(cl.result_list), 10)
  580. def test_dynamic_list_display_links(self):
  581. """
  582. Regression tests for #16257: dynamic list_display_links support.
  583. """
  584. parent = Parent.objects.create(name='parent')
  585. for i in range(1, 10):
  586. Child.objects.create(id=i, name='child %s' % i, parent=parent, age=i)
  587. m = DynamicListDisplayLinksChildAdmin(Child, custom_site)
  588. superuser = self._create_superuser('superuser')
  589. request = self._mocked_authenticated_request('/child/', superuser)
  590. response = m.changelist_view(request)
  591. for i in range(1, 10):
  592. link = reverse('admin:admin_changelist_child_change', args=(i,))
  593. self.assertContains(response, '<a href="%s">%s</a>' % (link, i))
  594. list_display = m.get_list_display(request)
  595. list_display_links = m.get_list_display_links(request, list_display)
  596. self.assertEqual(list_display, ('parent', 'name', 'age'))
  597. self.assertEqual(list_display_links, ['age'])
  598. def test_no_list_display_links(self):
  599. """#15185 -- Allow no links from the 'change list' view grid."""
  600. p = Parent.objects.create(name='parent')
  601. m = NoListDisplayLinksParentAdmin(Parent, custom_site)
  602. superuser = self._create_superuser('superuser')
  603. request = self._mocked_authenticated_request('/parent/', superuser)
  604. response = m.changelist_view(request)
  605. link = reverse('admin:admin_changelist_parent_change', args=(p.pk,))
  606. self.assertNotContains(response, '<a href="%s">' % link)
  607. def test_clear_all_filters_link(self):
  608. self.client.force_login(self.superuser)
  609. url = reverse('admin:auth_user_changelist')
  610. response = self.client.get(url)
  611. self.assertNotContains(response, '&#10006; Clear all filters')
  612. link = '<a href="%s">&#10006; Clear all filters</a>'
  613. for data, href in (
  614. ({'is_staff__exact': '0'}, '?'),
  615. (
  616. {'is_staff__exact': '0', 'username__startswith': 'test'},
  617. '?username__startswith=test',
  618. ),
  619. (
  620. {'is_staff__exact': '0', SEARCH_VAR: 'test'},
  621. '?%s=test' % SEARCH_VAR,
  622. ),
  623. (
  624. {'is_staff__exact': '0', IS_POPUP_VAR: 'id'},
  625. '?%s=id' % IS_POPUP_VAR,
  626. ),
  627. ):
  628. with self.subTest(data=data):
  629. response = self.client.get(url, data=data)
  630. self.assertContains(response, link % href)
  631. def test_clear_all_filters_link_callable_filter(self):
  632. self.client.force_login(self.superuser)
  633. url = reverse('admin:admin_changelist_band_changelist')
  634. response = self.client.get(url)
  635. self.assertNotContains(response, '&#10006; Clear all filters')
  636. link = '<a href="%s">&#10006; Clear all filters</a>'
  637. for data, href in (
  638. ({'nr_of_members_partition': '5'}, '?'),
  639. (
  640. {'nr_of_members_partition': 'more', 'name__startswith': 'test'},
  641. '?name__startswith=test',
  642. ),
  643. (
  644. {'nr_of_members_partition': '5', IS_POPUP_VAR: 'id'},
  645. '?%s=id' % IS_POPUP_VAR,
  646. ),
  647. ):
  648. with self.subTest(data=data):
  649. response = self.client.get(url, data=data)
  650. self.assertContains(response, link % href)
  651. def test_no_clear_all_filters_link(self):
  652. self.client.force_login(self.superuser)
  653. url = reverse('admin:auth_user_changelist')
  654. link = '>&#10006; Clear all filters</a>'
  655. for data in (
  656. {SEARCH_VAR: 'test'},
  657. {ORDER_VAR: '-1'},
  658. {TO_FIELD_VAR: 'id'},
  659. {PAGE_VAR: '1'},
  660. {IS_POPUP_VAR: '1'},
  661. {'username__startswith': 'test'},
  662. ):
  663. with self.subTest(data=data):
  664. response = self.client.get(url, data=data)
  665. self.assertNotContains(response, link)
  666. def test_tuple_list_display(self):
  667. swallow = Swallow.objects.create(origin='Africa', load='12.34', speed='22.2')
  668. swallow2 = Swallow.objects.create(origin='Africa', load='12.34', speed='22.2')
  669. swallow_o2o = SwallowOneToOne.objects.create(swallow=swallow2)
  670. model_admin = SwallowAdmin(Swallow, custom_site)
  671. superuser = self._create_superuser('superuser')
  672. request = self._mocked_authenticated_request('/swallow/', superuser)
  673. response = model_admin.changelist_view(request)
  674. # just want to ensure it doesn't blow up during rendering
  675. self.assertContains(response, str(swallow.origin))
  676. self.assertContains(response, str(swallow.load))
  677. self.assertContains(response, str(swallow.speed))
  678. # Reverse one-to-one relations should work.
  679. self.assertContains(response, '<td class="field-swallowonetoone">-</td>')
  680. self.assertContains(response, '<td class="field-swallowonetoone">%s</td>' % swallow_o2o)
  681. def test_multiuser_edit(self):
  682. """
  683. Simultaneous edits of list_editable fields on the changelist by
  684. different users must not result in one user's edits creating a new
  685. object instead of modifying the correct existing object (#11313).
  686. """
  687. # To replicate this issue, simulate the following steps:
  688. # 1. User1 opens an admin changelist with list_editable fields.
  689. # 2. User2 edits object "Foo" such that it moves to another page in
  690. # the pagination order and saves.
  691. # 3. User1 edits object "Foo" and saves.
  692. # 4. The edit made by User1 does not get applied to object "Foo" but
  693. # instead is used to create a new object (bug).
  694. # For this test, order the changelist by the 'speed' attribute and
  695. # display 3 objects per page (SwallowAdmin.list_per_page = 3).
  696. # Setup the test to reflect the DB state after step 2 where User2 has
  697. # edited the first swallow object's speed from '4' to '1'.
  698. a = Swallow.objects.create(origin='Swallow A', load=4, speed=1)
  699. b = Swallow.objects.create(origin='Swallow B', load=2, speed=2)
  700. c = Swallow.objects.create(origin='Swallow C', load=5, speed=5)
  701. d = Swallow.objects.create(origin='Swallow D', load=9, speed=9)
  702. superuser = self._create_superuser('superuser')
  703. self.client.force_login(superuser)
  704. changelist_url = reverse('admin:admin_changelist_swallow_changelist')
  705. # Send the POST from User1 for step 3. It's still using the changelist
  706. # ordering from before User2's edits in step 2.
  707. data = {
  708. 'form-TOTAL_FORMS': '3',
  709. 'form-INITIAL_FORMS': '3',
  710. 'form-MIN_NUM_FORMS': '0',
  711. 'form-MAX_NUM_FORMS': '1000',
  712. 'form-0-uuid': str(d.pk),
  713. 'form-1-uuid': str(c.pk),
  714. 'form-2-uuid': str(a.pk),
  715. 'form-0-load': '9.0',
  716. 'form-0-speed': '9.0',
  717. 'form-1-load': '5.0',
  718. 'form-1-speed': '5.0',
  719. 'form-2-load': '5.0',
  720. 'form-2-speed': '4.0',
  721. '_save': 'Save',
  722. }
  723. response = self.client.post(changelist_url, data, follow=True, extra={'o': '-2'})
  724. # The object User1 edited in step 3 is displayed on the changelist and
  725. # has the correct edits applied.
  726. self.assertContains(response, '1 swallow was changed successfully.')
  727. self.assertContains(response, a.origin)
  728. a.refresh_from_db()
  729. self.assertEqual(a.load, float(data['form-2-load']))
  730. self.assertEqual(a.speed, float(data['form-2-speed']))
  731. b.refresh_from_db()
  732. self.assertEqual(b.load, 2)
  733. self.assertEqual(b.speed, 2)
  734. c.refresh_from_db()
  735. self.assertEqual(c.load, float(data['form-1-load']))
  736. self.assertEqual(c.speed, float(data['form-1-speed']))
  737. d.refresh_from_db()
  738. self.assertEqual(d.load, float(data['form-0-load']))
  739. self.assertEqual(d.speed, float(data['form-0-speed']))
  740. # No new swallows were created.
  741. self.assertEqual(len(Swallow.objects.all()), 4)
  742. def test_get_edited_object_ids(self):
  743. a = Swallow.objects.create(origin='Swallow A', load=4, speed=1)
  744. b = Swallow.objects.create(origin='Swallow B', load=2, speed=2)
  745. c = Swallow.objects.create(origin='Swallow C', load=5, speed=5)
  746. superuser = self._create_superuser('superuser')
  747. self.client.force_login(superuser)
  748. changelist_url = reverse('admin:admin_changelist_swallow_changelist')
  749. m = SwallowAdmin(Swallow, custom_site)
  750. data = {
  751. 'form-TOTAL_FORMS': '3',
  752. 'form-INITIAL_FORMS': '3',
  753. 'form-MIN_NUM_FORMS': '0',
  754. 'form-MAX_NUM_FORMS': '1000',
  755. 'form-0-uuid': str(a.pk),
  756. 'form-1-uuid': str(b.pk),
  757. 'form-2-uuid': str(c.pk),
  758. 'form-0-load': '9.0',
  759. 'form-0-speed': '9.0',
  760. 'form-1-load': '5.0',
  761. 'form-1-speed': '5.0',
  762. 'form-2-load': '5.0',
  763. 'form-2-speed': '4.0',
  764. '_save': 'Save',
  765. }
  766. request = self.factory.post(changelist_url, data=data)
  767. pks = m._get_edited_object_pks(request, prefix='form')
  768. self.assertEqual(sorted(pks), sorted([str(a.pk), str(b.pk), str(c.pk)]))
  769. def test_get_list_editable_queryset(self):
  770. a = Swallow.objects.create(origin='Swallow A', load=4, speed=1)
  771. Swallow.objects.create(origin='Swallow B', load=2, speed=2)
  772. data = {
  773. 'form-TOTAL_FORMS': '2',
  774. 'form-INITIAL_FORMS': '2',
  775. 'form-MIN_NUM_FORMS': '0',
  776. 'form-MAX_NUM_FORMS': '1000',
  777. 'form-0-uuid': str(a.pk),
  778. 'form-0-load': '10',
  779. '_save': 'Save',
  780. }
  781. superuser = self._create_superuser('superuser')
  782. self.client.force_login(superuser)
  783. changelist_url = reverse('admin:admin_changelist_swallow_changelist')
  784. m = SwallowAdmin(Swallow, custom_site)
  785. request = self.factory.post(changelist_url, data=data)
  786. queryset = m._get_list_editable_queryset(request, prefix='form')
  787. self.assertEqual(queryset.count(), 1)
  788. data['form-0-uuid'] = 'INVALD_PRIMARY_KEY'
  789. # The unfiltered queryset is returned if there's invalid data.
  790. request = self.factory.post(changelist_url, data=data)
  791. queryset = m._get_list_editable_queryset(request, prefix='form')
  792. self.assertEqual(queryset.count(), 2)
  793. def test_get_list_editable_queryset_with_regex_chars_in_prefix(self):
  794. a = Swallow.objects.create(origin='Swallow A', load=4, speed=1)
  795. Swallow.objects.create(origin='Swallow B', load=2, speed=2)
  796. data = {
  797. 'form$-TOTAL_FORMS': '2',
  798. 'form$-INITIAL_FORMS': '2',
  799. 'form$-MIN_NUM_FORMS': '0',
  800. 'form$-MAX_NUM_FORMS': '1000',
  801. 'form$-0-uuid': str(a.pk),
  802. 'form$-0-load': '10',
  803. '_save': 'Save',
  804. }
  805. superuser = self._create_superuser('superuser')
  806. self.client.force_login(superuser)
  807. changelist_url = reverse('admin:admin_changelist_swallow_changelist')
  808. m = SwallowAdmin(Swallow, custom_site)
  809. request = self.factory.post(changelist_url, data=data)
  810. queryset = m._get_list_editable_queryset(request, prefix='form$')
  811. self.assertEqual(queryset.count(), 1)
  812. def test_changelist_view_list_editable_changed_objects_uses_filter(self):
  813. """list_editable edits use a filtered queryset to limit memory usage."""
  814. a = Swallow.objects.create(origin='Swallow A', load=4, speed=1)
  815. Swallow.objects.create(origin='Swallow B', load=2, speed=2)
  816. data = {
  817. 'form-TOTAL_FORMS': '2',
  818. 'form-INITIAL_FORMS': '2',
  819. 'form-MIN_NUM_FORMS': '0',
  820. 'form-MAX_NUM_FORMS': '1000',
  821. 'form-0-uuid': str(a.pk),
  822. 'form-0-load': '10',
  823. '_save': 'Save',
  824. }
  825. superuser = self._create_superuser('superuser')
  826. self.client.force_login(superuser)
  827. changelist_url = reverse('admin:admin_changelist_swallow_changelist')
  828. with CaptureQueriesContext(connection) as context:
  829. response = self.client.post(changelist_url, data=data)
  830. self.assertEqual(response.status_code, 200)
  831. self.assertIn('WHERE', context.captured_queries[4]['sql'])
  832. self.assertIn('IN', context.captured_queries[4]['sql'])
  833. # Check only the first few characters since the UUID may have dashes.
  834. self.assertIn(str(a.pk)[:8], context.captured_queries[4]['sql'])
  835. def test_deterministic_order_for_unordered_model(self):
  836. """
  837. The primary key is used in the ordering of the changelist's results to
  838. guarantee a deterministic order, even when the model doesn't have any
  839. default ordering defined (#17198).
  840. """
  841. superuser = self._create_superuser('superuser')
  842. for counter in range(1, 51):
  843. UnorderedObject.objects.create(id=counter, bool=True)
  844. class UnorderedObjectAdmin(admin.ModelAdmin):
  845. list_per_page = 10
  846. def check_results_order(ascending=False):
  847. custom_site.register(UnorderedObject, UnorderedObjectAdmin)
  848. model_admin = UnorderedObjectAdmin(UnorderedObject, custom_site)
  849. counter = 0 if ascending else 51
  850. for page in range(1, 6):
  851. request = self._mocked_authenticated_request('/unorderedobject/?p=%s' % page, superuser)
  852. response = model_admin.changelist_view(request)
  853. for result in response.context_data['cl'].result_list:
  854. counter += 1 if ascending else -1
  855. self.assertEqual(result.id, counter)
  856. custom_site.unregister(UnorderedObject)
  857. # When no order is defined at all, everything is ordered by '-pk'.
  858. check_results_order()
  859. # When an order field is defined but multiple records have the same
  860. # value for that field, make sure everything gets ordered by -pk as well.
  861. UnorderedObjectAdmin.ordering = ['bool']
  862. check_results_order()
  863. # When order fields are defined, including the pk itself, use them.
  864. UnorderedObjectAdmin.ordering = ['bool', '-pk']
  865. check_results_order()
  866. UnorderedObjectAdmin.ordering = ['bool', 'pk']
  867. check_results_order(ascending=True)
  868. UnorderedObjectAdmin.ordering = ['-id', 'bool']
  869. check_results_order()
  870. UnorderedObjectAdmin.ordering = ['id', 'bool']
  871. check_results_order(ascending=True)
  872. def test_deterministic_order_for_model_ordered_by_its_manager(self):
  873. """
  874. The primary key is used in the ordering of the changelist's results to
  875. guarantee a deterministic order, even when the model has a manager that
  876. defines a default ordering (#17198).
  877. """
  878. superuser = self._create_superuser('superuser')
  879. for counter in range(1, 51):
  880. OrderedObject.objects.create(id=counter, bool=True, number=counter)
  881. class OrderedObjectAdmin(admin.ModelAdmin):
  882. list_per_page = 10
  883. def check_results_order(ascending=False):
  884. custom_site.register(OrderedObject, OrderedObjectAdmin)
  885. model_admin = OrderedObjectAdmin(OrderedObject, custom_site)
  886. counter = 0 if ascending else 51
  887. for page in range(1, 6):
  888. request = self._mocked_authenticated_request('/orderedobject/?p=%s' % page, superuser)
  889. response = model_admin.changelist_view(request)
  890. for result in response.context_data['cl'].result_list:
  891. counter += 1 if ascending else -1
  892. self.assertEqual(result.id, counter)
  893. custom_site.unregister(OrderedObject)
  894. # When no order is defined at all, use the model's default ordering (i.e. 'number')
  895. check_results_order(ascending=True)
  896. # When an order field is defined but multiple records have the same
  897. # value for that field, make sure everything gets ordered by -pk as well.
  898. OrderedObjectAdmin.ordering = ['bool']
  899. check_results_order()
  900. # When order fields are defined, including the pk itself, use them.
  901. OrderedObjectAdmin.ordering = ['bool', '-pk']
  902. check_results_order()
  903. OrderedObjectAdmin.ordering = ['bool', 'pk']
  904. check_results_order(ascending=True)
  905. OrderedObjectAdmin.ordering = ['-id', 'bool']
  906. check_results_order()
  907. OrderedObjectAdmin.ordering = ['id', 'bool']
  908. check_results_order(ascending=True)
  909. @isolate_apps('admin_changelist')
  910. def test_total_ordering_optimization(self):
  911. class Related(models.Model):
  912. unique_field = models.BooleanField(unique=True)
  913. class Meta:
  914. ordering = ('unique_field',)
  915. class Model(models.Model):
  916. unique_field = models.BooleanField(unique=True)
  917. unique_nullable_field = models.BooleanField(unique=True, null=True)
  918. related = models.ForeignKey(Related, models.CASCADE)
  919. other_related = models.ForeignKey(Related, models.CASCADE)
  920. related_unique = models.OneToOneField(Related, models.CASCADE)
  921. field = models.BooleanField()
  922. other_field = models.BooleanField()
  923. null_field = models.BooleanField(null=True)
  924. class Meta:
  925. unique_together = {
  926. ('field', 'other_field'),
  927. ('field', 'null_field'),
  928. ('related', 'other_related_id'),
  929. }
  930. class ModelAdmin(admin.ModelAdmin):
  931. def get_queryset(self, request):
  932. return Model.objects.none()
  933. request = self._mocked_authenticated_request('/', self.superuser)
  934. site = admin.AdminSite(name='admin')
  935. model_admin = ModelAdmin(Model, site)
  936. change_list = model_admin.get_changelist_instance(request)
  937. tests = (
  938. ([], ['-pk']),
  939. # Unique non-nullable field.
  940. (['unique_field'], ['unique_field']),
  941. (['-unique_field'], ['-unique_field']),
  942. # Unique nullable field.
  943. (['unique_nullable_field'], ['unique_nullable_field', '-pk']),
  944. # Field.
  945. (['field'], ['field', '-pk']),
  946. # Related field introspection is not implemented.
  947. (['related__unique_field'], ['related__unique_field', '-pk']),
  948. # Related attname unique.
  949. (['related_unique_id'], ['related_unique_id']),
  950. # Related ordering introspection is not implemented.
  951. (['related_unique'], ['related_unique', '-pk']),
  952. # Composite unique.
  953. (['field', '-other_field'], ['field', '-other_field']),
  954. # Composite unique nullable.
  955. (['-field', 'null_field'], ['-field', 'null_field', '-pk']),
  956. # Composite unique and nullable.
  957. (['-field', 'null_field', 'other_field'], ['-field', 'null_field', 'other_field']),
  958. # Composite unique attnames.
  959. (['related_id', '-other_related_id'], ['related_id', '-other_related_id']),
  960. # Composite unique names.
  961. (['related', '-other_related_id'], ['related', '-other_related_id', '-pk']),
  962. )
  963. # F() objects composite unique.
  964. total_ordering = [F('field'), F('other_field').desc(nulls_last=True)]
  965. # F() objects composite unique nullable.
  966. non_total_ordering = [F('field'), F('null_field').desc(nulls_last=True)]
  967. tests += (
  968. (total_ordering, total_ordering),
  969. (non_total_ordering, non_total_ordering + ['-pk']),
  970. )
  971. for ordering, expected in tests:
  972. with self.subTest(ordering=ordering):
  973. self.assertEqual(change_list._get_deterministic_ordering(ordering), expected)
  974. @isolate_apps('admin_changelist')
  975. def test_total_ordering_optimization_meta_constraints(self):
  976. class Related(models.Model):
  977. unique_field = models.BooleanField(unique=True)
  978. class Meta:
  979. ordering = ('unique_field',)
  980. class Model(models.Model):
  981. field_1 = models.BooleanField()
  982. field_2 = models.BooleanField()
  983. field_3 = models.BooleanField()
  984. field_4 = models.BooleanField()
  985. field_5 = models.BooleanField()
  986. field_6 = models.BooleanField()
  987. nullable_1 = models.BooleanField(null=True)
  988. nullable_2 = models.BooleanField(null=True)
  989. related_1 = models.ForeignKey(Related, models.CASCADE)
  990. related_2 = models.ForeignKey(Related, models.CASCADE)
  991. related_3 = models.ForeignKey(Related, models.CASCADE)
  992. related_4 = models.ForeignKey(Related, models.CASCADE)
  993. class Meta:
  994. constraints = [
  995. *[
  996. models.UniqueConstraint(fields=fields, name=''.join(fields))
  997. for fields in (
  998. ['field_1'],
  999. ['nullable_1'],
  1000. ['related_1'],
  1001. ['related_2_id'],
  1002. ['field_2', 'field_3'],
  1003. ['field_2', 'nullable_2'],
  1004. ['field_2', 'related_3'],
  1005. ['field_3', 'related_4_id'],
  1006. )
  1007. ],
  1008. models.CheckConstraint(check=models.Q(id__gt=0), name='foo'),
  1009. models.UniqueConstraint(
  1010. fields=['field_5'],
  1011. condition=models.Q(id__gt=10),
  1012. name='total_ordering_1',
  1013. ),
  1014. models.UniqueConstraint(
  1015. fields=['field_6'],
  1016. condition=models.Q(),
  1017. name='total_ordering',
  1018. ),
  1019. ]
  1020. class ModelAdmin(admin.ModelAdmin):
  1021. def get_queryset(self, request):
  1022. return Model.objects.none()
  1023. request = self._mocked_authenticated_request('/', self.superuser)
  1024. site = admin.AdminSite(name='admin')
  1025. model_admin = ModelAdmin(Model, site)
  1026. change_list = model_admin.get_changelist_instance(request)
  1027. tests = (
  1028. # Unique non-nullable field.
  1029. (['field_1'], ['field_1']),
  1030. # Unique nullable field.
  1031. (['nullable_1'], ['nullable_1', '-pk']),
  1032. # Related attname unique.
  1033. (['related_1_id'], ['related_1_id']),
  1034. (['related_2_id'], ['related_2_id']),
  1035. # Related ordering introspection is not implemented.
  1036. (['related_1'], ['related_1', '-pk']),
  1037. # Composite unique.
  1038. (['-field_2', 'field_3'], ['-field_2', 'field_3']),
  1039. # Composite unique nullable.
  1040. (['field_2', '-nullable_2'], ['field_2', '-nullable_2', '-pk']),
  1041. # Composite unique and nullable.
  1042. (
  1043. ['field_2', '-nullable_2', 'field_3'],
  1044. ['field_2', '-nullable_2', 'field_3'],
  1045. ),
  1046. # Composite field and related field name.
  1047. (['field_2', '-related_3'], ['field_2', '-related_3', '-pk']),
  1048. (['field_3', 'related_4'], ['field_3', 'related_4', '-pk']),
  1049. # Composite field and related field attname.
  1050. (['field_2', 'related_3_id'], ['field_2', 'related_3_id']),
  1051. (['field_3', '-related_4_id'], ['field_3', '-related_4_id']),
  1052. # Partial unique constraint is ignored.
  1053. (['field_5'], ['field_5', '-pk']),
  1054. # Unique constraint with an empty condition.
  1055. (['field_6'], ['field_6']),
  1056. )
  1057. for ordering, expected in tests:
  1058. with self.subTest(ordering=ordering):
  1059. self.assertEqual(change_list._get_deterministic_ordering(ordering), expected)
  1060. def test_dynamic_list_filter(self):
  1061. """
  1062. Regression tests for ticket #17646: dynamic list_filter support.
  1063. """
  1064. parent = Parent.objects.create(name='parent')
  1065. for i in range(10):
  1066. Child.objects.create(name='child %s' % i, parent=parent)
  1067. user_noparents = self._create_superuser('noparents')
  1068. user_parents = self._create_superuser('parents')
  1069. # Test with user 'noparents'
  1070. m = DynamicListFilterChildAdmin(Child, custom_site)
  1071. request = self._mocked_authenticated_request('/child/', user_noparents)
  1072. response = m.changelist_view(request)
  1073. self.assertEqual(response.context_data['cl'].list_filter, ['name', 'age'])
  1074. # Test with user 'parents'
  1075. m = DynamicListFilterChildAdmin(Child, custom_site)
  1076. request = self._mocked_authenticated_request('/child/', user_parents)
  1077. response = m.changelist_view(request)
  1078. self.assertEqual(response.context_data['cl'].list_filter, ('parent', 'name', 'age'))
  1079. def test_dynamic_search_fields(self):
  1080. child = self._create_superuser('child')
  1081. m = DynamicSearchFieldsChildAdmin(Child, custom_site)
  1082. request = self._mocked_authenticated_request('/child/', child)
  1083. response = m.changelist_view(request)
  1084. self.assertEqual(response.context_data['cl'].search_fields, ('name', 'age'))
  1085. def test_pagination_page_range(self):
  1086. """
  1087. Regression tests for ticket #15653: ensure the number of pages
  1088. generated for changelist views are correct.
  1089. """
  1090. # instantiating and setting up ChangeList object
  1091. m = GroupAdmin(Group, custom_site)
  1092. request = self.factory.get('/group/')
  1093. request.user = self.superuser
  1094. cl = m.get_changelist_instance(request)
  1095. cl.list_per_page = 10
  1096. ELLIPSIS = cl.paginator.ELLIPSIS
  1097. for number, pages, expected in [
  1098. (1, 1, []),
  1099. (1, 2, [1, 2]),
  1100. (6, 11, [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11]),
  1101. (6, 12, [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12]),
  1102. (6, 13, [1, 2, 3, 4, 5, 6, 7, 8, 9, ELLIPSIS, 12, 13]),
  1103. (7, 12, [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12]),
  1104. (7, 13, [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13]),
  1105. (7, 14, [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, ELLIPSIS, 13, 14]),
  1106. (8, 13, [1, 2, ELLIPSIS, 5, 6, 7, 8, 9, 10, 11, 12, 13]),
  1107. (8, 14, [1, 2, ELLIPSIS, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14]),
  1108. (8, 15, [1, 2, ELLIPSIS, 5, 6, 7, 8, 9, 10, 11, ELLIPSIS, 14, 15]),
  1109. ]:
  1110. with self.subTest(number=number, pages=pages):
  1111. # assuming exactly `pages * cl.list_per_page` objects
  1112. Group.objects.all().delete()
  1113. for i in range(pages * cl.list_per_page):
  1114. Group.objects.create(name='test band')
  1115. # setting page number and calculating page range
  1116. cl.page_num = number
  1117. cl.get_results(request)
  1118. self.assertEqual(list(pagination(cl)['page_range']), expected)
  1119. def test_object_tools_displayed_no_add_permission(self):
  1120. """
  1121. When ModelAdmin.has_add_permission() returns False, the object-tools
  1122. block is still shown.
  1123. """
  1124. superuser = self._create_superuser('superuser')
  1125. m = EventAdmin(Event, custom_site)
  1126. request = self._mocked_authenticated_request('/event/', superuser)
  1127. self.assertFalse(m.has_add_permission(request))
  1128. response = m.changelist_view(request)
  1129. self.assertIn('<ul class="object-tools">', response.rendered_content)
  1130. # The "Add" button inside the object-tools shouldn't appear.
  1131. self.assertNotIn('Add ', response.rendered_content)
  1132. class GetAdminLogTests(TestCase):
  1133. def test_custom_user_pk_not_named_id(self):
  1134. """
  1135. {% get_admin_log %} works if the user model's primary key isn't named
  1136. 'id'.
  1137. """
  1138. context = Context({'user': CustomIdUser()})
  1139. template = Template('{% load log %}{% get_admin_log 10 as admin_log for_user user %}')
  1140. # This template tag just logs.
  1141. self.assertEqual(template.render(context), '')
  1142. def test_no_user(self):
  1143. """{% get_admin_log %} works without specifying a user."""
  1144. user = User(username='jondoe', password='secret', email='super@example.com')
  1145. user.save()
  1146. ct = ContentType.objects.get_for_model(User)
  1147. LogEntry.objects.log_action(user.pk, ct.pk, user.pk, repr(user), 1)
  1148. t = Template(
  1149. '{% load log %}'
  1150. '{% get_admin_log 100 as admin_log %}'
  1151. '{% for entry in admin_log %}'
  1152. '{{ entry|safe }}'
  1153. '{% endfor %}'
  1154. )
  1155. self.assertEqual(t.render(Context({})), 'Added “<User: jondoe>”.')
  1156. def test_missing_args(self):
  1157. msg = "'get_admin_log' statements require two arguments"
  1158. with self.assertRaisesMessage(TemplateSyntaxError, msg):
  1159. Template('{% load log %}{% get_admin_log 10 as %}')
  1160. def test_non_integer_limit(self):
  1161. msg = "First argument to 'get_admin_log' must be an integer"
  1162. with self.assertRaisesMessage(TemplateSyntaxError, msg):
  1163. Template('{% load log %}{% get_admin_log "10" as admin_log for_user user %}')
  1164. def test_without_as(self):
  1165. msg = "Second argument to 'get_admin_log' must be 'as'"
  1166. with self.assertRaisesMessage(TemplateSyntaxError, msg):
  1167. Template('{% load log %}{% get_admin_log 10 ad admin_log for_user user %}')
  1168. def test_without_for_user(self):
  1169. msg = "Fourth argument to 'get_admin_log' must be 'for_user'"
  1170. with self.assertRaisesMessage(TemplateSyntaxError, msg):
  1171. Template('{% load log %}{% get_admin_log 10 as admin_log foruser user %}')
  1172. @override_settings(ROOT_URLCONF='admin_changelist.urls')
  1173. class SeleniumTests(AdminSeleniumTestCase):
  1174. available_apps = ['admin_changelist'] + AdminSeleniumTestCase.available_apps
  1175. def setUp(self):
  1176. User.objects.create_superuser(username='super', password='secret', email=None)
  1177. def test_add_row_selection(self):
  1178. """
  1179. The status line for selected rows gets updated correctly (#22038).
  1180. """
  1181. self.admin_login(username='super', password='secret')
  1182. self.selenium.get(self.live_server_url + reverse('admin:auth_user_changelist'))
  1183. form_id = '#changelist-form'
  1184. # Test amount of rows in the Changelist
  1185. rows = self.selenium.find_elements_by_css_selector(
  1186. '%s #result_list tbody tr' % form_id
  1187. )
  1188. self.assertEqual(len(rows), 1)
  1189. row = rows[0]
  1190. selection_indicator = self.selenium.find_element_by_css_selector(
  1191. '%s .action-counter' % form_id
  1192. )
  1193. all_selector = self.selenium.find_element_by_id('action-toggle')
  1194. row_selector = self.selenium.find_element_by_css_selector(
  1195. '%s #result_list tbody tr:first-child .action-select' % form_id
  1196. )
  1197. # Test current selection
  1198. self.assertEqual(selection_indicator.text, "0 of 1 selected")
  1199. self.assertIs(all_selector.get_property('checked'), False)
  1200. self.assertEqual(row.get_attribute('class'), '')
  1201. # Select a row and check again
  1202. row_selector.click()
  1203. self.assertEqual(selection_indicator.text, "1 of 1 selected")
  1204. self.assertIs(all_selector.get_property('checked'), True)
  1205. self.assertEqual(row.get_attribute('class'), 'selected')
  1206. # Deselect a row and check again
  1207. row_selector.click()
  1208. self.assertEqual(selection_indicator.text, "0 of 1 selected")
  1209. self.assertIs(all_selector.get_property('checked'), False)
  1210. self.assertEqual(row.get_attribute('class'), '')
  1211. def test_select_all_across_pages(self):
  1212. Parent.objects.bulk_create([Parent(name='parent%d' % i) for i in range(101)])
  1213. self.admin_login(username='super', password='secret')
  1214. self.selenium.get(self.live_server_url + reverse('admin:admin_changelist_parent_changelist'))
  1215. selection_indicator = self.selenium.find_element_by_css_selector('.action-counter')
  1216. select_all_indicator = self.selenium.find_element_by_css_selector('.actions .all')
  1217. question = self.selenium.find_element_by_css_selector('.actions > .question')
  1218. clear = self.selenium.find_element_by_css_selector('.actions > .clear')
  1219. select_all = self.selenium.find_element_by_id('action-toggle')
  1220. select_across = self.selenium.find_element_by_name('select_across')
  1221. self.assertIs(question.is_displayed(), False)
  1222. self.assertIs(clear.is_displayed(), False)
  1223. self.assertIs(select_all.get_property('checked'), False)
  1224. self.assertEqual(select_across.get_property('value'), '0')
  1225. self.assertIs(selection_indicator.is_displayed(), True)
  1226. self.assertEqual(selection_indicator.text, '0 of 100 selected')
  1227. self.assertIs(select_all_indicator.is_displayed(), False)
  1228. select_all.click()
  1229. self.assertIs(question.is_displayed(), True)
  1230. self.assertIs(clear.is_displayed(), False)
  1231. self.assertIs(select_all.get_property('checked'), True)
  1232. self.assertEqual(select_across.get_property('value'), '0')
  1233. self.assertIs(selection_indicator.is_displayed(), True)
  1234. self.assertEqual(selection_indicator.text, '100 of 100 selected')
  1235. self.assertIs(select_all_indicator.is_displayed(), False)
  1236. question.click()
  1237. self.assertIs(question.is_displayed(), False)
  1238. self.assertIs(clear.is_displayed(), True)
  1239. self.assertIs(select_all.get_property('checked'), True)
  1240. self.assertEqual(select_across.get_property('value'), '1')
  1241. self.assertIs(selection_indicator.is_displayed(), False)
  1242. self.assertIs(select_all_indicator.is_displayed(), True)
  1243. clear.click()
  1244. self.assertIs(question.is_displayed(), False)
  1245. self.assertIs(clear.is_displayed(), False)
  1246. self.assertIs(select_all.get_property('checked'), False)
  1247. self.assertEqual(select_across.get_property('value'), '0')
  1248. self.assertIs(selection_indicator.is_displayed(), True)
  1249. self.assertEqual(selection_indicator.text, '0 of 100 selected')
  1250. self.assertIs(select_all_indicator.is_displayed(), False)
  1251. def test_actions_warn_on_pending_edits(self):
  1252. Parent.objects.create(name='foo')
  1253. self.admin_login(username='super', password='secret')
  1254. self.selenium.get(self.live_server_url + reverse('admin:admin_changelist_parent_changelist'))
  1255. name_input = self.selenium.find_element_by_id('id_form-0-name')
  1256. name_input.clear()
  1257. name_input.send_keys('bar')
  1258. self.selenium.find_element_by_id('action-toggle').click()
  1259. self.selenium.find_element_by_name('index').click() # Go
  1260. alert = self.selenium.switch_to.alert
  1261. try:
  1262. self.assertEqual(
  1263. alert.text,
  1264. 'You have unsaved changes on individual editable fields. If you '
  1265. 'run an action, your unsaved changes will be lost.'
  1266. )
  1267. finally:
  1268. alert.dismiss()
  1269. def test_save_with_changes_warns_on_pending_action(self):
  1270. from selenium.webdriver.support.ui import Select
  1271. Parent.objects.create(name='parent')
  1272. self.admin_login(username='super', password='secret')
  1273. self.selenium.get(self.live_server_url + reverse('admin:admin_changelist_parent_changelist'))
  1274. name_input = self.selenium.find_element_by_id('id_form-0-name')
  1275. name_input.clear()
  1276. name_input.send_keys('other name')
  1277. Select(
  1278. self.selenium.find_element_by_name('action')
  1279. ).select_by_value('delete_selected')
  1280. self.selenium.find_element_by_name('_save').click()
  1281. alert = self.selenium.switch_to.alert
  1282. try:
  1283. self.assertEqual(
  1284. alert.text,
  1285. 'You have selected an action, but you haven’t saved your '
  1286. 'changes to individual fields yet. Please click OK to save. '
  1287. 'You’ll need to re-run the action.',
  1288. )
  1289. finally:
  1290. alert.dismiss()
  1291. def test_save_without_changes_warns_on_pending_action(self):
  1292. from selenium.webdriver.support.ui import Select
  1293. Parent.objects.create(name='parent')
  1294. self.admin_login(username='super', password='secret')
  1295. self.selenium.get(self.live_server_url + reverse('admin:admin_changelist_parent_changelist'))
  1296. Select(
  1297. self.selenium.find_element_by_name('action')
  1298. ).select_by_value('delete_selected')
  1299. self.selenium.find_element_by_name('_save').click()
  1300. alert = self.selenium.switch_to.alert
  1301. try:
  1302. self.assertEqual(
  1303. alert.text,
  1304. 'You have selected an action, and you haven’t made any '
  1305. 'changes on individual fields. You’re probably looking for '
  1306. 'the Go button rather than the Save button.',
  1307. )
  1308. finally:
  1309. alert.dismiss()