Changeset 7625

Timestamp:

06/12/08 08:19:37 (5 months ago)

Author:

russellm

Message:

Fixed #7327 -- Added documentation and test case for defining subqueries. Thanks, Sebastian Noack.

Files:

• django/trunk/docs/db-api.txt (modified) (1 diff)
• django/trunk/tests/modeltests/many_to_one/models.py (modified) (1 diff)

django/trunk/docs/db-api.txt

@@ -1374 +1374 @@
-    SELECT ... WHERE id IN (1, 3, 4);
-
+You can also use a queryset to dynamically evaluate the list of values
+instead of providing a list of literal values. The queryset must be
+reduced to a list of individual values using the ``values()`` method, 
+and then converted into a query using the ``query`` attribute::
+
+    Entry.objects.filter(blog__in=Blog.objects.filter(name__contains='Cheddar').values('pk').query)
+
+This queryset will be evaluated as subselect statement::
+
+    SELET ... WHERE blog.id IN (SELECT id FROM ... WHERE NAME LIKE '%Cheddar%')
+
-startswith
-~~~~~~~~~~

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

@@ -175 +175 @@
->>> Article.objects.filter(reporter__in=[r,r2]).distinct()
-[<Article: John's second story>, <Article: Paul's story>, <Article: This is a test>]
+
+# You can also use a queryset instead of a literal list of instances.
+# The queryset must be reduced to a list of values using values(), 
+# then converted into a query
+>>> Article.objects.filter(reporter__in=Reporter.objects.filter(first_name='John').values('pk').query).distinct()
+[<Article: John's second story>, <Article: This is a test>]
-
-# You need two underscores between "reporter" and "id" -- not one.