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