tests.py 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746
  1. import copy
  2. import datetime
  3. import pickle
  4. from operator import attrgetter
  5. from django.core.exceptions import FieldError
  6. from django.db import connection, models
  7. from django.test import SimpleTestCase, TestCase, skipUnlessDBFeature
  8. from django.test.utils import isolate_apps
  9. from django.utils import translation
  10. from .models import (
  11. Article,
  12. ArticleIdea,
  13. ArticleTag,
  14. ArticleTranslation,
  15. Country,
  16. Friendship,
  17. Group,
  18. Membership,
  19. NewsArticle,
  20. Person,
  21. )
  22. # Note that these tests are testing internal implementation details.
  23. # ForeignObject is not part of public API.
  24. class MultiColumnFKTests(TestCase):
  25. @classmethod
  26. def setUpTestData(cls):
  27. # Creating countries
  28. cls.usa = Country.objects.create(name="United States of America")
  29. cls.soviet_union = Country.objects.create(name="Soviet Union")
  30. # Creating People
  31. cls.bob = Person.objects.create(name="Bob", person_country=cls.usa)
  32. cls.jim = Person.objects.create(name="Jim", person_country=cls.usa)
  33. cls.george = Person.objects.create(name="George", person_country=cls.usa)
  34. cls.jane = Person.objects.create(name="Jane", person_country=cls.soviet_union)
  35. cls.mark = Person.objects.create(name="Mark", person_country=cls.soviet_union)
  36. cls.sam = Person.objects.create(name="Sam", person_country=cls.soviet_union)
  37. # Creating Groups
  38. cls.kgb = Group.objects.create(name="KGB", group_country=cls.soviet_union)
  39. cls.cia = Group.objects.create(name="CIA", group_country=cls.usa)
  40. cls.republican = Group.objects.create(name="Republican", group_country=cls.usa)
  41. cls.democrat = Group.objects.create(name="Democrat", group_country=cls.usa)
  42. def test_get_succeeds_on_multicolumn_match(self):
  43. # Membership objects have access to their related Person if both
  44. # country_ids match between them
  45. membership = Membership.objects.create(
  46. membership_country_id=self.usa.id,
  47. person_id=self.bob.id,
  48. group_id=self.cia.id,
  49. )
  50. person = membership.person
  51. self.assertEqual((person.id, person.name), (self.bob.id, "Bob"))
  52. def test_get_fails_on_multicolumn_mismatch(self):
  53. # Membership objects returns DoesNotExist error when there is no
  54. # Person with the same id and country_id
  55. membership = Membership.objects.create(
  56. membership_country_id=self.usa.id,
  57. person_id=self.jane.id,
  58. group_id=self.cia.id,
  59. )
  60. with self.assertRaises(Person.DoesNotExist):
  61. getattr(membership, "person")
  62. def test_reverse_query_returns_correct_result(self):
  63. # Creating a valid membership because it has the same country has the person
  64. Membership.objects.create(
  65. membership_country_id=self.usa.id,
  66. person_id=self.bob.id,
  67. group_id=self.cia.id,
  68. )
  69. # Creating an invalid membership because it has a different country has
  70. # the person.
  71. Membership.objects.create(
  72. membership_country_id=self.soviet_union.id,
  73. person_id=self.bob.id,
  74. group_id=self.republican.id,
  75. )
  76. with self.assertNumQueries(1):
  77. membership = self.bob.membership_set.get()
  78. self.assertEqual(membership.group_id, self.cia.id)
  79. self.assertIs(membership.person, self.bob)
  80. def test_query_filters_correctly(self):
  81. # Creating a to valid memberships
  82. Membership.objects.create(
  83. membership_country_id=self.usa.id,
  84. person_id=self.bob.id,
  85. group_id=self.cia.id,
  86. )
  87. Membership.objects.create(
  88. membership_country_id=self.usa.id,
  89. person_id=self.jim.id,
  90. group_id=self.cia.id,
  91. )
  92. # Creating an invalid membership
  93. Membership.objects.create(
  94. membership_country_id=self.soviet_union.id,
  95. person_id=self.george.id,
  96. group_id=self.cia.id,
  97. )
  98. self.assertQuerySetEqual(
  99. Membership.objects.filter(person__name__contains="o"),
  100. [self.bob.id],
  101. attrgetter("person_id"),
  102. )
  103. def test_reverse_query_filters_correctly(self):
  104. timemark = datetime.datetime.now(tz=datetime.UTC).replace(tzinfo=None)
  105. timedelta = datetime.timedelta(days=1)
  106. # Creating a to valid memberships
  107. Membership.objects.create(
  108. membership_country_id=self.usa.id,
  109. person_id=self.bob.id,
  110. group_id=self.cia.id,
  111. date_joined=timemark - timedelta,
  112. )
  113. Membership.objects.create(
  114. membership_country_id=self.usa.id,
  115. person_id=self.jim.id,
  116. group_id=self.cia.id,
  117. date_joined=timemark + timedelta,
  118. )
  119. # Creating an invalid membership
  120. Membership.objects.create(
  121. membership_country_id=self.soviet_union.id,
  122. person_id=self.george.id,
  123. group_id=self.cia.id,
  124. date_joined=timemark + timedelta,
  125. )
  126. self.assertQuerySetEqual(
  127. Person.objects.filter(membership__date_joined__gte=timemark),
  128. ["Jim"],
  129. attrgetter("name"),
  130. )
  131. def test_forward_in_lookup_filters_correctly(self):
  132. Membership.objects.create(
  133. membership_country_id=self.usa.id,
  134. person_id=self.bob.id,
  135. group_id=self.cia.id,
  136. )
  137. Membership.objects.create(
  138. membership_country_id=self.usa.id,
  139. person_id=self.jim.id,
  140. group_id=self.cia.id,
  141. )
  142. # Creating an invalid membership
  143. Membership.objects.create(
  144. membership_country_id=self.soviet_union.id,
  145. person_id=self.george.id,
  146. group_id=self.cia.id,
  147. )
  148. self.assertQuerySetEqual(
  149. Membership.objects.filter(person__in=[self.george, self.jim]),
  150. [
  151. self.jim.id,
  152. ],
  153. attrgetter("person_id"),
  154. )
  155. self.assertQuerySetEqual(
  156. Membership.objects.filter(person__in=Person.objects.filter(name="Jim")),
  157. [
  158. self.jim.id,
  159. ],
  160. attrgetter("person_id"),
  161. )
  162. def test_double_nested_query(self):
  163. m1 = Membership.objects.create(
  164. membership_country_id=self.usa.id,
  165. person_id=self.bob.id,
  166. group_id=self.cia.id,
  167. )
  168. m2 = Membership.objects.create(
  169. membership_country_id=self.usa.id,
  170. person_id=self.jim.id,
  171. group_id=self.cia.id,
  172. )
  173. Friendship.objects.create(
  174. from_friend_country_id=self.usa.id,
  175. from_friend_id=self.bob.id,
  176. to_friend_country_id=self.usa.id,
  177. to_friend_id=self.jim.id,
  178. )
  179. self.assertSequenceEqual(
  180. Membership.objects.filter(
  181. person__in=Person.objects.filter(
  182. from_friend__in=Friendship.objects.filter(
  183. to_friend__in=Person.objects.all()
  184. )
  185. )
  186. ),
  187. [m1],
  188. )
  189. self.assertSequenceEqual(
  190. Membership.objects.exclude(
  191. person__in=Person.objects.filter(
  192. from_friend__in=Friendship.objects.filter(
  193. to_friend__in=Person.objects.all()
  194. )
  195. )
  196. ),
  197. [m2],
  198. )
  199. def test_query_does_not_mutate(self):
  200. """
  201. Recompiling the same subquery doesn't mutate it.
  202. """
  203. queryset = Friendship.objects.filter(to_friend__in=Person.objects.all())
  204. self.assertEqual(str(queryset.query), str(queryset.query))
  205. def test_select_related_foreignkey_forward_works(self):
  206. Membership.objects.create(
  207. membership_country=self.usa, person=self.bob, group=self.cia
  208. )
  209. Membership.objects.create(
  210. membership_country=self.usa, person=self.jim, group=self.democrat
  211. )
  212. with self.assertNumQueries(1):
  213. people = [
  214. m.person
  215. for m in Membership.objects.select_related("person").order_by("pk")
  216. ]
  217. normal_people = [m.person for m in Membership.objects.order_by("pk")]
  218. self.assertEqual(people, normal_people)
  219. def test_prefetch_foreignobject_forward(self):
  220. Membership.objects.create(
  221. membership_country=self.usa, person=self.bob, group=self.cia
  222. )
  223. Membership.objects.create(
  224. membership_country=self.usa, person=self.jim, group=self.democrat
  225. )
  226. with self.assertNumQueries(2):
  227. people = [
  228. m.person
  229. for m in Membership.objects.prefetch_related("person").order_by("pk")
  230. ]
  231. normal_people = [m.person for m in Membership.objects.order_by("pk")]
  232. self.assertEqual(people, normal_people)
  233. def test_prefetch_foreignobject_hidden_forward(self):
  234. Friendship.objects.create(
  235. from_friend_country=self.usa,
  236. from_friend_id=self.bob.id,
  237. to_friend_country_id=self.usa.id,
  238. to_friend_id=self.george.id,
  239. )
  240. Friendship.objects.create(
  241. from_friend_country=self.usa,
  242. from_friend_id=self.bob.id,
  243. to_friend_country_id=self.soviet_union.id,
  244. to_friend_id=self.sam.id,
  245. )
  246. with self.assertNumQueries(2) as ctx:
  247. friendships = list(
  248. Friendship.objects.prefetch_related("to_friend").order_by("pk")
  249. )
  250. prefetch_sql = ctx[-1]["sql"]
  251. # Prefetch queryset should be filtered by all foreign related fields
  252. # to prevent extra rows from being eagerly fetched.
  253. prefetch_where_sql = prefetch_sql.split("WHERE")[-1]
  254. for to_field_name in Friendship.to_friend.field.to_fields:
  255. to_field = Person._meta.get_field(to_field_name)
  256. with self.subTest(to_field=to_field):
  257. self.assertIn(
  258. connection.ops.quote_name(to_field.column),
  259. prefetch_where_sql,
  260. )
  261. self.assertNotIn(" JOIN ", prefetch_sql)
  262. with self.assertNumQueries(0):
  263. self.assertEqual(friendships[0].to_friend, self.george)
  264. self.assertEqual(friendships[1].to_friend, self.sam)
  265. def test_prefetch_foreignobject_reverse(self):
  266. Membership.objects.create(
  267. membership_country=self.usa, person=self.bob, group=self.cia
  268. )
  269. Membership.objects.create(
  270. membership_country=self.usa, person=self.jim, group=self.democrat
  271. )
  272. with self.assertNumQueries(2):
  273. membership_sets = [
  274. list(p.membership_set.all())
  275. for p in Person.objects.prefetch_related("membership_set").order_by(
  276. "pk"
  277. )
  278. ]
  279. with self.assertNumQueries(7):
  280. normal_membership_sets = [
  281. list(p.membership_set.all()) for p in Person.objects.order_by("pk")
  282. ]
  283. self.assertEqual(membership_sets, normal_membership_sets)
  284. def test_m2m_through_forward_returns_valid_members(self):
  285. # We start out by making sure that the Group 'CIA' has no members.
  286. self.assertQuerySetEqual(self.cia.members.all(), [])
  287. Membership.objects.create(
  288. membership_country=self.usa, person=self.bob, group=self.cia
  289. )
  290. Membership.objects.create(
  291. membership_country=self.usa, person=self.jim, group=self.cia
  292. )
  293. # Bob and Jim should be members of the CIA.
  294. self.assertQuerySetEqual(
  295. self.cia.members.all(), ["Bob", "Jim"], attrgetter("name")
  296. )
  297. def test_m2m_through_reverse_returns_valid_members(self):
  298. # We start out by making sure that Bob is in no groups.
  299. self.assertQuerySetEqual(self.bob.groups.all(), [])
  300. Membership.objects.create(
  301. membership_country=self.usa, person=self.bob, group=self.cia
  302. )
  303. Membership.objects.create(
  304. membership_country=self.usa, person=self.bob, group=self.republican
  305. )
  306. # Bob should be in the CIA and a Republican
  307. self.assertQuerySetEqual(
  308. self.bob.groups.all(), ["CIA", "Republican"], attrgetter("name")
  309. )
  310. def test_m2m_through_forward_ignores_invalid_members(self):
  311. # We start out by making sure that the Group 'CIA' has no members.
  312. self.assertQuerySetEqual(self.cia.members.all(), [])
  313. # Something adds jane to group CIA but Jane is in Soviet Union which
  314. # isn't CIA's country.
  315. Membership.objects.create(
  316. membership_country=self.usa, person=self.jane, group=self.cia
  317. )
  318. # There should still be no members in CIA
  319. self.assertQuerySetEqual(self.cia.members.all(), [])
  320. def test_m2m_through_reverse_ignores_invalid_members(self):
  321. # We start out by making sure that Jane has no groups.
  322. self.assertQuerySetEqual(self.jane.groups.all(), [])
  323. # Something adds jane to group CIA but Jane is in Soviet Union which
  324. # isn't CIA's country.
  325. Membership.objects.create(
  326. membership_country=self.usa, person=self.jane, group=self.cia
  327. )
  328. # Jane should still not be in any groups
  329. self.assertQuerySetEqual(self.jane.groups.all(), [])
  330. def test_m2m_through_on_self_works(self):
  331. self.assertQuerySetEqual(self.jane.friends.all(), [])
  332. Friendship.objects.create(
  333. from_friend_country=self.jane.person_country,
  334. from_friend=self.jane,
  335. to_friend_country=self.george.person_country,
  336. to_friend=self.george,
  337. )
  338. self.assertQuerySetEqual(
  339. self.jane.friends.all(), ["George"], attrgetter("name")
  340. )
  341. def test_m2m_through_on_self_ignores_mismatch_columns(self):
  342. self.assertQuerySetEqual(self.jane.friends.all(), [])
  343. # Note that we use ids instead of instances. This is because instances
  344. # on ForeignObject properties will set all related field off of the
  345. # given instance.
  346. Friendship.objects.create(
  347. from_friend_id=self.jane.id,
  348. to_friend_id=self.george.id,
  349. to_friend_country_id=self.jane.person_country_id,
  350. from_friend_country_id=self.george.person_country_id,
  351. )
  352. self.assertQuerySetEqual(self.jane.friends.all(), [])
  353. def test_prefetch_related_m2m_forward_works(self):
  354. Membership.objects.create(
  355. membership_country=self.usa, person=self.bob, group=self.cia
  356. )
  357. Membership.objects.create(
  358. membership_country=self.usa, person=self.jim, group=self.democrat
  359. )
  360. with self.assertNumQueries(2):
  361. members_lists = [
  362. list(g.members.all()) for g in Group.objects.prefetch_related("members")
  363. ]
  364. normal_members_lists = [list(g.members.all()) for g in Group.objects.all()]
  365. self.assertEqual(members_lists, normal_members_lists)
  366. def test_prefetch_related_m2m_reverse_works(self):
  367. Membership.objects.create(
  368. membership_country=self.usa, person=self.bob, group=self.cia
  369. )
  370. Membership.objects.create(
  371. membership_country=self.usa, person=self.jim, group=self.democrat
  372. )
  373. with self.assertNumQueries(2):
  374. groups_lists = [
  375. list(p.groups.all()) for p in Person.objects.prefetch_related("groups")
  376. ]
  377. normal_groups_lists = [list(p.groups.all()) for p in Person.objects.all()]
  378. self.assertEqual(groups_lists, normal_groups_lists)
  379. @translation.override("fi")
  380. def test_translations(self):
  381. a1 = Article.objects.create(pub_date=datetime.date.today())
  382. at1_fi = ArticleTranslation(
  383. article=a1, lang="fi", title="Otsikko", body="Diipadaapa"
  384. )
  385. at1_fi.save()
  386. at2_en = ArticleTranslation(
  387. article=a1, lang="en", title="Title", body="Lalalalala"
  388. )
  389. at2_en.save()
  390. self.assertEqual(Article.objects.get(pk=a1.pk).active_translation, at1_fi)
  391. with self.assertNumQueries(1):
  392. fetched = Article.objects.select_related("active_translation").get(
  393. active_translation__title="Otsikko"
  394. )
  395. self.assertEqual(fetched.active_translation.title, "Otsikko")
  396. a2 = Article.objects.create(pub_date=datetime.date.today())
  397. at2_fi = ArticleTranslation(
  398. article=a2, lang="fi", title="Atsikko", body="Diipadaapa", abstract="dipad"
  399. )
  400. at2_fi.save()
  401. a3 = Article.objects.create(pub_date=datetime.date.today())
  402. at3_en = ArticleTranslation(
  403. article=a3, lang="en", title="A title", body="lalalalala", abstract="lala"
  404. )
  405. at3_en.save()
  406. # Test model initialization with active_translation field.
  407. a3 = Article(id=a3.id, pub_date=a3.pub_date, active_translation=at3_en)
  408. a3.save()
  409. self.assertEqual(
  410. list(Article.objects.filter(active_translation__abstract=None)), [a1, a3]
  411. )
  412. self.assertEqual(
  413. list(
  414. Article.objects.filter(
  415. active_translation__abstract=None,
  416. active_translation__pk__isnull=False,
  417. )
  418. ),
  419. [a1],
  420. )
  421. with translation.override("en"):
  422. self.assertEqual(
  423. list(Article.objects.filter(active_translation__abstract=None)),
  424. [a1, a2],
  425. )
  426. def test_foreign_key_raises_informative_does_not_exist(self):
  427. referrer = ArticleTranslation()
  428. with self.assertRaisesMessage(
  429. Article.DoesNotExist, "ArticleTranslation has no article"
  430. ):
  431. referrer.article
  432. def test_foreign_key_related_query_name(self):
  433. a1 = Article.objects.create(pub_date=datetime.date.today())
  434. ArticleTag.objects.create(article=a1, name="foo")
  435. self.assertEqual(Article.objects.filter(tag__name="foo").count(), 1)
  436. self.assertEqual(Article.objects.filter(tag__name="bar").count(), 0)
  437. msg = (
  438. "Cannot resolve keyword 'tags' into field. Choices are: "
  439. "active_translation, active_translation_q, articletranslation, "
  440. "id, idea_things, newsarticle, pub_date, tag"
  441. )
  442. with self.assertRaisesMessage(FieldError, msg):
  443. Article.objects.filter(tags__name="foo")
  444. def test_many_to_many_related_query_name(self):
  445. a1 = Article.objects.create(pub_date=datetime.date.today())
  446. i1 = ArticleIdea.objects.create(name="idea1")
  447. a1.ideas.add(i1)
  448. self.assertEqual(Article.objects.filter(idea_things__name="idea1").count(), 1)
  449. self.assertEqual(Article.objects.filter(idea_things__name="idea2").count(), 0)
  450. msg = (
  451. "Cannot resolve keyword 'ideas' into field. Choices are: "
  452. "active_translation, active_translation_q, articletranslation, "
  453. "id, idea_things, newsarticle, pub_date, tag"
  454. )
  455. with self.assertRaisesMessage(FieldError, msg):
  456. Article.objects.filter(ideas__name="idea1")
  457. @translation.override("fi")
  458. def test_inheritance(self):
  459. na = NewsArticle.objects.create(pub_date=datetime.date.today())
  460. ArticleTranslation.objects.create(
  461. article=na, lang="fi", title="foo", body="bar"
  462. )
  463. self.assertSequenceEqual(
  464. NewsArticle.objects.select_related("active_translation"), [na]
  465. )
  466. with self.assertNumQueries(1):
  467. self.assertEqual(
  468. NewsArticle.objects.select_related("active_translation")[
  469. 0
  470. ].active_translation.title,
  471. "foo",
  472. )
  473. @skipUnlessDBFeature("has_bulk_insert")
  474. def test_batch_create_foreign_object(self):
  475. objs = [
  476. Person(name="abcd_%s" % i, person_country=self.usa) for i in range(0, 5)
  477. ]
  478. Person.objects.bulk_create(objs, 10)
  479. def test_isnull_lookup(self):
  480. m1 = Membership.objects.create(
  481. person_id=self.bob.id,
  482. membership_country_id=self.usa.id,
  483. group_id=None,
  484. )
  485. m2 = Membership.objects.create(
  486. person_id=self.jim.id,
  487. membership_country_id=None,
  488. group_id=self.cia.id,
  489. )
  490. m3 = Membership.objects.create(
  491. person_id=self.jane.id,
  492. membership_country_id=None,
  493. group_id=None,
  494. )
  495. m4 = Membership.objects.create(
  496. person_id=self.george.id,
  497. membership_country_id=self.soviet_union.id,
  498. group_id=self.kgb.id,
  499. )
  500. for member in [m1, m2, m3]:
  501. with self.assertRaises(Membership.group.RelatedObjectDoesNotExist):
  502. getattr(member, "group")
  503. self.assertSequenceEqual(
  504. Membership.objects.filter(group__isnull=True),
  505. [m1, m2, m3],
  506. )
  507. self.assertSequenceEqual(
  508. Membership.objects.filter(group__isnull=False),
  509. [m4],
  510. )
  511. class TestModelCheckTests(SimpleTestCase):
  512. @isolate_apps("foreign_object")
  513. def test_check_composite_foreign_object(self):
  514. class Parent(models.Model):
  515. a = models.PositiveIntegerField()
  516. b = models.PositiveIntegerField()
  517. class Meta:
  518. unique_together = (("a", "b"),)
  519. class Child(models.Model):
  520. a = models.PositiveIntegerField()
  521. b = models.PositiveIntegerField()
  522. value = models.CharField(max_length=255)
  523. parent = models.ForeignObject(
  524. Parent,
  525. on_delete=models.SET_NULL,
  526. from_fields=("a", "b"),
  527. to_fields=("a", "b"),
  528. related_name="children",
  529. )
  530. self.assertEqual(Child._meta.get_field("parent").check(from_model=Child), [])
  531. @isolate_apps("foreign_object")
  532. def test_check_subset_composite_foreign_object(self):
  533. class Parent(models.Model):
  534. a = models.PositiveIntegerField()
  535. b = models.PositiveIntegerField()
  536. c = models.PositiveIntegerField()
  537. class Meta:
  538. unique_together = (("a", "b"),)
  539. class Child(models.Model):
  540. a = models.PositiveIntegerField()
  541. b = models.PositiveIntegerField()
  542. c = models.PositiveIntegerField()
  543. d = models.CharField(max_length=255)
  544. parent = models.ForeignObject(
  545. Parent,
  546. on_delete=models.SET_NULL,
  547. from_fields=("a", "b", "c"),
  548. to_fields=("a", "b", "c"),
  549. related_name="children",
  550. )
  551. self.assertEqual(Child._meta.get_field("parent").check(from_model=Child), [])
  552. class TestExtraJoinFilterQ(TestCase):
  553. @translation.override("fi")
  554. def test_extra_join_filter_q(self):
  555. a = Article.objects.create(pub_date=datetime.datetime.today())
  556. ArticleTranslation.objects.create(
  557. article=a, lang="fi", title="title", body="body"
  558. )
  559. qs = Article.objects.all()
  560. with self.assertNumQueries(2):
  561. self.assertEqual(qs[0].active_translation_q.title, "title")
  562. qs = qs.select_related("active_translation_q")
  563. with self.assertNumQueries(1):
  564. self.assertEqual(qs[0].active_translation_q.title, "title")
  565. class TestCachedPathInfo(TestCase):
  566. def test_equality(self):
  567. """
  568. The path_infos and reverse_path_infos attributes are equivalent to
  569. calling the get_<method>() with no arguments.
  570. """
  571. foreign_object = Membership._meta.get_field("person")
  572. self.assertEqual(
  573. foreign_object.path_infos,
  574. foreign_object.get_path_info(),
  575. )
  576. self.assertEqual(
  577. foreign_object.reverse_path_infos,
  578. foreign_object.get_reverse_path_info(),
  579. )
  580. def test_copy_removes_direct_cached_values(self):
  581. """
  582. Shallow copying a ForeignObject (or a ForeignObjectRel) removes the
  583. object's direct cached PathInfo values.
  584. """
  585. foreign_object = Membership._meta.get_field("person")
  586. # Trigger storage of cached_property into ForeignObject's __dict__.
  587. foreign_object.path_infos
  588. foreign_object.reverse_path_infos
  589. # The ForeignObjectRel doesn't have reverse_path_infos.
  590. foreign_object.remote_field.path_infos
  591. self.assertIn("path_infos", foreign_object.__dict__)
  592. self.assertIn("reverse_path_infos", foreign_object.__dict__)
  593. self.assertIn("path_infos", foreign_object.remote_field.__dict__)
  594. # Cached value is removed via __getstate__() on ForeignObjectRel
  595. # because no __copy__() method exists, so __reduce_ex__() is used.
  596. remote_field_copy = copy.copy(foreign_object.remote_field)
  597. self.assertNotIn("path_infos", remote_field_copy.__dict__)
  598. # Cached values are removed via __copy__() on ForeignObject for
  599. # consistency of behavior.
  600. foreign_object_copy = copy.copy(foreign_object)
  601. self.assertNotIn("path_infos", foreign_object_copy.__dict__)
  602. self.assertNotIn("reverse_path_infos", foreign_object_copy.__dict__)
  603. # ForeignObjectRel's remains because it's part of a shallow copy.
  604. self.assertIn("path_infos", foreign_object_copy.remote_field.__dict__)
  605. def test_deepcopy_removes_cached_values(self):
  606. """
  607. Deep copying a ForeignObject removes the object's cached PathInfo
  608. values, including those of the related ForeignObjectRel.
  609. """
  610. foreign_object = Membership._meta.get_field("person")
  611. # Trigger storage of cached_property into ForeignObject's __dict__.
  612. foreign_object.path_infos
  613. foreign_object.reverse_path_infos
  614. # The ForeignObjectRel doesn't have reverse_path_infos.
  615. foreign_object.remote_field.path_infos
  616. self.assertIn("path_infos", foreign_object.__dict__)
  617. self.assertIn("reverse_path_infos", foreign_object.__dict__)
  618. self.assertIn("path_infos", foreign_object.remote_field.__dict__)
  619. # Cached value is removed via __getstate__() on ForeignObjectRel
  620. # because no __deepcopy__() method exists, so __reduce_ex__() is used.
  621. remote_field_copy = copy.deepcopy(foreign_object.remote_field)
  622. self.assertNotIn("path_infos", remote_field_copy.__dict__)
  623. # Field.__deepcopy__() internally uses __copy__() on both the
  624. # ForeignObject and ForeignObjectRel, so all cached values are removed.
  625. foreign_object_copy = copy.deepcopy(foreign_object)
  626. self.assertNotIn("path_infos", foreign_object_copy.__dict__)
  627. self.assertNotIn("reverse_path_infos", foreign_object_copy.__dict__)
  628. self.assertNotIn("path_infos", foreign_object_copy.remote_field.__dict__)
  629. def test_pickling_foreignobjectrel(self):
  630. """
  631. Pickling a ForeignObjectRel removes the path_infos attribute.
  632. ForeignObjectRel implements __getstate__(), so copy and pickle modules
  633. both use that, but ForeignObject implements __reduce__() and __copy__()
  634. separately, so doesn't share the same behaviour.
  635. """
  636. foreign_object_rel = Membership._meta.get_field("person").remote_field
  637. # Trigger storage of cached_property into ForeignObjectRel's __dict__.
  638. foreign_object_rel.path_infos
  639. self.assertIn("path_infos", foreign_object_rel.__dict__)
  640. foreign_object_rel_restored = pickle.loads(pickle.dumps(foreign_object_rel))
  641. self.assertNotIn("path_infos", foreign_object_rel_restored.__dict__)
  642. def test_pickling_foreignobject(self):
  643. """
  644. Pickling a ForeignObject does not remove the cached PathInfo values.
  645. ForeignObject will always keep the path_infos and reverse_path_infos
  646. attributes within the same process, because of the way
  647. Field.__reduce__() is used for restoring values.
  648. """
  649. foreign_object = Membership._meta.get_field("person")
  650. # Trigger storage of cached_property into ForeignObjectRel's __dict__
  651. foreign_object.path_infos
  652. foreign_object.reverse_path_infos
  653. self.assertIn("path_infos", foreign_object.__dict__)
  654. self.assertIn("reverse_path_infos", foreign_object.__dict__)
  655. foreign_object_restored = pickle.loads(pickle.dumps(foreign_object))
  656. self.assertIn("path_infos", foreign_object_restored.__dict__)
  657. self.assertIn("reverse_path_infos", foreign_object_restored.__dict__)