Debian Codegraph @

tests/expressions/models.py

raw
1 """
2 Tests for F() query expression syntax.
3 """
4
5 import uuid
6
7 from django.db import models
8
9
10 class Manager(models.Model):
11 name = models.CharField(max_length=50)
12 secretary = models.ForeignKey(
13 "Employee", models.CASCADE, null=True, related_name="managers"
14 )
15
16
17 class Employee(models.Model):
18 firstname = models.CharField(max_length=50)
19 lastname = models.CharField(max_length=50)
20 salary = models.IntegerField(blank=True, null=True)
21 manager = models.ForeignKey(Manager, models.CASCADE, null=True)
22 based_in_eu = models.BooleanField(default=False)
23
24 def __str__(self):
25 return "%s %s" % (self.firstname, self.lastname)
26
27
28 class RemoteEmployee(Employee):
29 adjusted_salary = models.IntegerField()
30
31
32 class Company(models.Model):
33 name = models.CharField(max_length=100)
34 num_employees = models.PositiveIntegerField()
35 num_chairs = models.PositiveIntegerField()
36 ceo = models.ForeignKey(
37 Employee,
38 models.CASCADE,
39 related_name="company_ceo_set",
40 )
41 point_of_contact = models.ForeignKey(
42 Employee,
43 models.SET_NULL,
44 related_name="company_point_of_contact_set",
45 null=True,
46 )
47 based_in_eu = models.BooleanField(default=False)
48
49 def __str__(self):
50 return self.name
51
52
53 class Number(models.Model):
54 integer = models.BigIntegerField(db_column="the_integer")
55 float = models.FloatField(null=True, db_column="the_float")
56 decimal_value = models.DecimalField(max_digits=20, decimal_places=17, null=True)
57
58 def __str__(self):
59 return "%i, %s, %s" % (
60 self.integer,
61 "%.3f" % self.float if self.float is not None else None,
62 "%.17f" % self.decimal_value if self.decimal_value is not None else None,
63 )
64
65
66 class Experiment(models.Model):
67 name = models.CharField(max_length=24)
68 assigned = models.DateField()
69 completed = models.DateField()
70 estimated_time = models.DurationField()
71 start = models.DateTimeField()
72 end = models.DateTimeField()
73 scalar = models.IntegerField(null=True)
74
75 class Meta:
76 db_table = "expressions_ExPeRiMeNt"
77 ordering = ("name",)
78
79 def duration(self):
80 return self.end - self.start
81
82
83 class Result(models.Model):
84 experiment = models.ForeignKey(Experiment, models.CASCADE)
85 result_time = models.DateTimeField()
86
87 def __str__(self):
88 return "Result at %s" % self.result_time
89
90
91 class Time(models.Model):
92 time = models.TimeField(null=True)
93
94 def __str__(self):
95 return str(self.time)
96
97
98 class SimulationRun(models.Model):
99 start = models.ForeignKey(Time, models.CASCADE, null=True, related_name="+")
100 end = models.ForeignKey(Time, models.CASCADE, null=True, related_name="+")
101 midpoint = models.TimeField()
102
103 def __str__(self):
104 return "%s (%s to %s)" % (self.midpoint, self.start, self.end)
105
106
107 class UUIDPK(models.Model):
108 id = models.UUIDField(primary_key=True, default=uuid.uuid4)
109
110
111 class UUID(models.Model):
112 uuid = models.UUIDField(null=True)
113 uuid_fk = models.ForeignKey(UUIDPK, models.CASCADE, null=True)
114
115
116 class Text(models.Model):
117 name = models.TextField()
118
119
120 class JSONFieldModel(models.Model):
121 data = models.JSONField(null=True)
122
123 class Meta:
124 required_db_features = {"supports_json_field"}