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