Debian Codegraph @

tests/ordering/models.py

raw
1 """
2 Specifying ordering
3
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
6 ``QuerySet`` results.
7
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.
11
12 The ordering attribute is not required. If you leave it off, ordering will be
13 undefined -- not random, just undefined.
14 """
15
16 from django.db import models
17
18
19 class Author(models.Model):
20 name = models.CharField(max_length=63, null=True, blank=True)
21 editor = models.ForeignKey("self", models.CASCADE, null=True)
22
23 class Meta:
24 ordering = ("-pk",)
25
26
27 class Article(models.Model):
28 author = models.ForeignKey(Author, models.SET_NULL, null=True)
29 second_author = models.ForeignKey(
30 Author, models.SET_NULL, null=True, related_name="+"
31 )
32 headline = models.CharField(max_length=100)
33 pub_date = models.DateTimeField()
34
35 class Meta:
36 ordering = (
37 "-pub_date",
38 models.F("headline"),
39 models.F("author__name").asc(),
40 models.OrderBy(models.F("second_author__name")),
41 )
42
43
44 class OrderedByAuthorArticle(Article):
45 class Meta:
46 proxy = True
47 ordering = ("author", "second_author")
48
49
50 class OrderedByFArticle(Article):
51 class Meta:
52 proxy = True
53 ordering = (models.F("author").asc(nulls_first=True), "id")
54
55
56 class ChildArticle(Article):
57 pass
58
59
60 class Reference(models.Model):
61 article = models.ForeignKey(OrderedByAuthorArticle, models.CASCADE)
62
63 class Meta:
64 ordering = ("article",)
65
66
67 class OrderedByExpression(models.Model):
68 name = models.CharField(max_length=30)
69
70 class Meta:
71 ordering = [models.functions.Lower("name")]
72
73
74 class OrderedByExpressionChild(models.Model):
75 parent = models.ForeignKey(OrderedByExpression, models.CASCADE)
76
77 class Meta:
78 ordering = ["parent"]
79
80
81 class OrderedByExpressionGrandChild(models.Model):
82 parent = models.ForeignKey(OrderedByExpressionChild, models.CASCADE)