4
Specify default ordering for a model using the ``ordering`` attribute, which
5
should be a list or tuple of field names. This tells Django how to order
8
If a field name in ``ordering`` starts with a hyphen, that field will be
9
ordered in descending order. Otherwise, it'll be ordered in ascending order.
10
The special-case field name ``"?"`` specifies random order.
12
The ordering attribute is not required. If you leave it off, ordering will be
13
undefined -- not random, just undefined.
16
from django.db import models
18
class Article(models.Model):
19
headline = models.CharField(max_length=100)
20
pub_date = models.DateTimeField()
22
ordering = ('-pub_date', 'headline')
24
def __unicode__(self):
27
__test__ = {'API_TESTS':"""
28
# Create a couple of Articles.
29
>>> from datetime import datetime
30
>>> a1 = Article(headline='Article 1', pub_date=datetime(2005, 7, 26))
32
>>> a2 = Article(headline='Article 2', pub_date=datetime(2005, 7, 27))
34
>>> a3 = Article(headline='Article 3', pub_date=datetime(2005, 7, 27))
36
>>> a4 = Article(headline='Article 4', pub_date=datetime(2005, 7, 28))
39
# By default, Article.objects.all() orders by pub_date descending, then
41
>>> Article.objects.all()
42
[<Article: Article 4>, <Article: Article 2>, <Article: Article 3>, <Article: Article 1>]
44
# Override ordering with order_by, which is in the same format as the ordering
45
# attribute in models.
46
>>> Article.objects.order_by('headline')
47
[<Article: Article 1>, <Article: Article 2>, <Article: Article 3>, <Article: Article 4>]
48
>>> Article.objects.order_by('pub_date', '-headline')
49
[<Article: Article 1>, <Article: Article 3>, <Article: Article 2>, <Article: Article 4>]
51
# Only the last order_by has any effect (since they each override any previous
53
>>> Article.objects.order_by('id')
54
[<Article: Article 1>, <Article: Article 2>, <Article: Article 3>, <Article: Article 4>]
55
>>> Article.objects.order_by('id').order_by('-headline')
56
[<Article: Article 4>, <Article: Article 3>, <Article: Article 2>, <Article: Article 1>]
58
# Use the 'stop' part of slicing notation to limit the results.
59
>>> Article.objects.order_by('headline')[:2]
60
[<Article: Article 1>, <Article: Article 2>]
62
# Use the 'stop' and 'start' parts of slicing notation to offset the result list.
63
>>> Article.objects.order_by('headline')[1:3]
64
[<Article: Article 2>, <Article: Article 3>]
66
# Getting a single item should work too:
67
>>> Article.objects.all()[0]
70
# Use '?' to order randomly. (We're using [...] in the output to indicate we
71
# don't know what order the output will be in.
72
>>> Article.objects.order_by('?')
75
# Ordering can be reversed using the reverse() method on a queryset. This
76
# allows you to extract things like "the last two items" (reverse and then
77
# take the first two).
78
>>> Article.objects.all().reverse()[:2]
79
[<Article: Article 1>, <Article: Article 3>]
81
# Ordering can be based on fields included from an 'extra' clause
82
>>> Article.objects.extra(select={'foo': 'pub_date'}, order_by=['foo', 'headline'])
83
[<Article: Article 1>, <Article: Article 2>, <Article: Article 3>, <Article: Article 4>]
85
# If the extra clause uses an SQL keyword for a name, it will be protected by quoting.
86
>>> Article.objects.extra(select={'order': 'pub_date'}, order_by=['order', 'headline'])
87
[<Article: Article 1>, <Article: Article 2>, <Article: Article 3>, <Article: Article 4>]