Debian Codegraph @

tests/many_to_one/models.py

raw
1 """
2 Many-to-one relationships
3
4 To define a many-to-one relationship, use ``ForeignKey()``.
5 """
6
7 from django.db import models
8
9
10 class Reporter(models.Model):
11 first_name = models.CharField(max_length=30)
12 last_name = models.CharField(max_length=30)
13 email = models.EmailField()
14
15 def __str__(self):
16 return "%s %s" % (self.first_name, self.last_name)
17
18
19 class Article(models.Model):
20 headline = models.CharField(max_length=100)
21 pub_date = models.DateField()
22 reporter = models.ForeignKey(Reporter, models.CASCADE)
23
24 class Meta:
25 ordering = ("headline",)
26
27 def __str__(self):
28 return self.headline
29
30
31 class Country(models.Model):
32 id = models.SmallAutoField(primary_key=True)
33 name = models.CharField(max_length=50)
34
35
36 class City(models.Model):
37 id = models.BigAutoField(primary_key=True)
38 country = models.ForeignKey(
39 Country, models.CASCADE, related_name="cities", null=True
40 )
41 name = models.CharField(max_length=50)
42
43
44 class District(models.Model):
45 city = models.ForeignKey(City, models.CASCADE, related_name="districts", null=True)
46 name = models.CharField(max_length=50)
47
48 def __str__(self):
49 return self.name
50
51
52 # If ticket #1578 ever slips back in, these models will not be able to be
53 # created (the field names being lowercased versions of their opposite classes
54 # is important here).
55 class First(models.Model):
56 second = models.IntegerField()
57
58
59 class Second(models.Model):
60 first = models.ForeignKey(First, models.CASCADE, related_name="the_first")
61
62
63 # Protect against repetition of #1839, #2415 and #2536.
64 class Third(models.Model):
65 name = models.CharField(max_length=20)
66 third = models.ForeignKey(
67 "self", models.SET_NULL, null=True, related_name="child_set"
68 )
69
70
71 class Parent(models.Model):
72 name = models.CharField(max_length=20, unique=True)
73 bestchild = models.ForeignKey(
74 "Child", models.SET_NULL, null=True, related_name="favored_by"
75 )
76
77
78 class ParentStringPrimaryKey(models.Model):
79 name = models.CharField(primary_key=True, max_length=15)
80
81
82 class Child(models.Model):
83 name = models.CharField(max_length=20)
84 parent = models.ForeignKey(Parent, models.CASCADE)
85
86
87 class ChildNullableParent(models.Model):
88 parent = models.ForeignKey(Parent, models.CASCADE, null=True)
89
90
91 class ChildStringPrimaryKeyParent(models.Model):
92 parent = models.ForeignKey(ParentStringPrimaryKey, on_delete=models.CASCADE)
93
94
95 class ToFieldChild(models.Model):
96 parent = models.ForeignKey(
97 Parent, models.CASCADE, to_field="name", related_name="to_field_children"
98 )
99
100
101 # Multiple paths to the same model (#7110, #7125)
102 class Category(models.Model):
103 name = models.CharField(max_length=20)
104
105 def __str__(self):
106 return self.name
107
108
109 class Record(models.Model):
110 category = models.ForeignKey(Category, models.CASCADE)
111
112
113 class Relation(models.Model):
114 left = models.ForeignKey(Record, models.CASCADE, related_name="left_set")
115 right = models.ForeignKey(Record, models.CASCADE, related_name="right_set")
116
117 def __str__(self):
118 return "%s - %s" % (self.left.category.name, self.right.category.name)
119
120
121 # Test related objects visibility.
122 class SchoolManager(models.Manager):
123 def get_queryset(self):
124 return super().get_queryset().filter(is_public=True)
125
126
127 class School(models.Model):
128 is_public = models.BooleanField(default=False)
129 objects = SchoolManager()
130
131
132 class Student(models.Model):
133 school = models.ForeignKey(School, models.CASCADE)