Debian Codegraph @

tests/filtered_relation/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=50, unique=True)
8 favorite_books = models.ManyToManyField(
9 "Book",
10 related_name="preferred_by_authors",
11 related_query_name="preferred_by_authors",
12 )
13 content_type = models.ForeignKey(ContentType, models.CASCADE, null=True)
14 object_id = models.PositiveIntegerField(null=True)
15 content_object = GenericForeignKey()
16
17
18 class Editor(models.Model):
19 name = models.CharField(max_length=255)
20
21
22 class Book(models.Model):
23 AVAILABLE = "available"
24 RESERVED = "reserved"
25 RENTED = "rented"
26 STATES = (
27 (AVAILABLE, "Available"),
28 (RESERVED, "reserved"),
29 (RENTED, "Rented"),
30 )
31 title = models.CharField(max_length=255)
32 author = models.ForeignKey(
33 Author,
34 models.CASCADE,
35 related_name="books",
36 related_query_name="book",
37 )
38 editor = models.ForeignKey(Editor, models.CASCADE)
39 number_editor = models.IntegerField(default=-1)
40 editor_number = models.IntegerField(default=-2)
41 generic_author = GenericRelation(Author)
42 state = models.CharField(max_length=9, choices=STATES, default=AVAILABLE)
43
44
45 class Borrower(models.Model):
46 name = models.CharField(max_length=50, unique=True)
47
48
49 class Reservation(models.Model):
50 NEW = "new"
51 STOPPED = "stopped"
52 STATES = (
53 (NEW, "New"),
54 (STOPPED, "Stopped"),
55 )
56 borrower = models.ForeignKey(
57 Borrower,
58 models.CASCADE,
59 related_name="reservations",
60 related_query_name="reservation",
61 )
62 book = models.ForeignKey(
63 Book,
64 models.CASCADE,
65 related_name="reservations",
66 related_query_name="reservation",
67 )
68 state = models.CharField(max_length=7, choices=STATES, default=NEW)
69
70
71 class RentalSession(models.Model):
72 NEW = "new"
73 STOPPED = "stopped"
74 STATES = (
75 (NEW, "New"),
76 (STOPPED, "Stopped"),
77 )
78 borrower = models.ForeignKey(
79 Borrower,
80 models.CASCADE,
81 related_name="rental_sessions",
82 related_query_name="rental_session",
83 )
84 book = models.ForeignKey(
85 Book,
86 models.CASCADE,
87 related_name="rental_sessions",
88 related_query_name="rental_session",
89 )
90 state = models.CharField(max_length=7, choices=STATES, default=NEW)
91
92
93 class Seller(models.Model):
94 name = models.CharField(max_length=255)
95
96
97 class Currency(models.Model):
98 currency = models.CharField(max_length=3)
99
100
101 class ExchangeRate(models.Model):
102 rate_date = models.DateField()
103 from_currency = models.ForeignKey(
104 Currency,
105 models.CASCADE,
106 related_name="rates_from",
107 )
108 to_currency = models.ForeignKey(
109 Currency,
110 models.CASCADE,
111 related_name="rates_to",
112 )
113 rate = models.DecimalField(max_digits=6, decimal_places=4)
114
115
116 class BookDailySales(models.Model):
117 book = models.ForeignKey(Book, models.CASCADE, related_name="daily_sales")
118 sale_date = models.DateField()
119 currency = models.ForeignKey(Currency, models.CASCADE)
120 seller = models.ForeignKey(Seller, models.CASCADE)
121 sales = models.DecimalField(max_digits=10, decimal_places=2)