| 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) |