Changeset 7485 for django/trunk/tests/modeltests

Timestamp:

04/27/08 19:03:01 (7 months ago)

Author:

adrian

Message:

Added some tests to modeltests/many_to_one that demonstrate a post-queryset-refactor bug in dates(). Refs #7097

Files:

• django/trunk/tests/modeltests/many_to_one/models.py (modified) (3 diffs)

django/trunk/tests/modeltests/many_to_one/models.py

@@ -247 +247 @@
-[<Reporter: John Smith>]
-
-
+.
->>> Reporter.objects.filter(article__reporter=r).distinct()
-[<Reporter: John Smith>]
@@ -267 +267 @@
-[<Reporter: John Smith>]
-
-Deletes using a join in the query
+You can delete using a JOIN in the query.
->>> Reporter.objects.filter(article__headline__startswith='This').delete()
->>> Reporter.objects.all()
@@ -274 +274 @@
-[]
-
+# Check that Article.objects.select_related().dates() works properly when
+# there are multiple Articles with the same date but different foreign-key
+# objects (Reporters).
+>>> r1 = Reporter.objects.create(first_name='Mike', last_name='Royko', email='royko@suntimes.com')
+>>> r2 = Reporter.objects.create(first_name='John', last_name='Kass', email='jkass@tribune.com')
+>>> a1 = Article.objects.create(headline='First', pub_date=datetime(1980, 4, 23), reporter=r1)
+>>> a2 = Article.objects.create(headline='Second', pub_date=datetime(1980, 4, 23), reporter=r2)
+>>> Article.objects.select_related().dates('pub_date', 'day')
+[datetime.datetime(1980, 4, 23, 0, 0)]
+>>> Article.objects.select_related().dates('pub_date', 'month')
+[datetime.datetime(1980, 4, 1, 0, 0)]
+>>> Article.objects.select_related().dates('pub_date', 'year')
+[datetime.datetime(1980, 1, 1, 0, 0)]
-"""}