Debian Codegraph @

tests/aggregation_regress/models.py

raw
1 from django.contrib.contenttypes.fields import GenericForeignKey, GenericRelation
2 from django.contrib.contenttypes.models import ContentType
3 from django.db import models
4
5
6 class Author(models.Model):
7 name = models.CharField(max_length=100)
8 age = models.IntegerField()
9 friends = models.ManyToManyField("self", blank=True)
10
11
12 class Publisher(models.Model):
13 name = models.CharField(max_length=255)
14 num_awards = models.IntegerField()
15
16
17 class ItemTag(models.Model):
18 tag = models.CharField(max_length=100)
19 content_type = models.ForeignKey(ContentType, models.CASCADE)
20 object_id = models.PositiveIntegerField()
21 content_object = GenericForeignKey("content_type", "object_id")
22
23
24 class Book(models.Model):
25 isbn = models.CharField(max_length=9)
26 name = models.CharField(max_length=255)
27 pages = models.IntegerField()
28 rating = models.FloatField()
29 price = models.DecimalField(decimal_places=2, max_digits=6)
30 authors = models.ManyToManyField(Author)
31 contact = models.ForeignKey(Author, models.CASCADE, related_name="book_contact_set")
32 publisher = models.ForeignKey(Publisher, models.CASCADE)
33 pubdate = models.DateField()
34 tags = GenericRelation(ItemTag)
35
36 class Meta:
37 ordering = ("name",)
38
39
40 class Store(models.Model):
41 name = models.CharField(max_length=255)
42 books = models.ManyToManyField(Book)
43 original_opening = models.DateTimeField()
44 friday_night_closing = models.TimeField()
45
46
47 class Entries(models.Model):
48 EntryID = models.AutoField(primary_key=True, db_column="Entry ID")
49 Entry = models.CharField(unique=True, max_length=50)
50 Exclude = models.BooleanField(default=False)
51
52
53 class Clues(models.Model):
54 ID = models.AutoField(primary_key=True)
55 EntryID = models.ForeignKey(
56 Entries, models.CASCADE, verbose_name="Entry", db_column="Entry ID"
57 )
58 Clue = models.CharField(max_length=150)
59
60
61 class WithManualPK(models.Model):
62 # The generic relations regression test needs two different model
63 # classes with the same PK value, and there are some (external)
64 # DB backends that don't work nicely when assigning integer to AutoField
65 # column (MSSQL at least).
66 id = models.IntegerField(primary_key=True)
67
68
69 class HardbackBook(Book):
70 weight = models.FloatField()
71
72
73 # Models for ticket #21150
74 class Alfa(models.Model):
75 name = models.CharField(max_length=10, null=True)
76
77
78 class Bravo(models.Model):
79 pass
80
81
82 class Charlie(models.Model):
83 alfa = models.ForeignKey(Alfa, models.SET_NULL, null=True)
84 bravo = models.ForeignKey(Bravo, models.SET_NULL, null=True)
85
86
87 class SelfRefFK(models.Model):
88 name = models.CharField(max_length=50)
89 parent = models.ForeignKey(
90 "self", models.SET_NULL, null=True, blank=True, related_name="children"
91 )
92
93
94 class AuthorProxy(Author):
95 class Meta:
96 proxy = True
97
98
99 class Recipe(models.Model):
100 name = models.CharField(max_length=20)
101 author = models.ForeignKey(AuthorProxy, models.CASCADE)
102 tasters = models.ManyToManyField(AuthorProxy, related_name="recipes")
103
104
105 class RecipeProxy(Recipe):
106 class Meta:
107 proxy = True
108
109
110 class AuthorUnmanaged(models.Model):
111 age = models.IntegerField()
112
113 class Meta:
114 db_table = Author._meta.db_table
115 managed = False
116
117
118 class RecipeTasterUnmanaged(models.Model):
119 recipe = models.ForeignKey("RecipeUnmanaged", models.CASCADE)
120 author = models.ForeignKey(
121 AuthorUnmanaged, models.CASCADE, db_column="authorproxy_id"
122 )
123
124 class Meta:
125 managed = False
126 db_table = Recipe.tasters.through._meta.db_table
127
128
129 class RecipeUnmanaged(models.Model):
130 author = models.ForeignKey(AuthorUnmanaged, models.CASCADE)
131 tasters = models.ManyToManyField(
132 AuthorUnmanaged, through=RecipeTasterUnmanaged, related_name="+"
133 )
134
135 class Meta:
136 managed = False
137 db_table = Recipe._meta.db_table