models.py 6.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233
  1. from datetime import datetime
  2. from django.core.exceptions import ValidationError
  3. from django.db import models
  4. from django.db.models.functions import Lower
  5. def validate_answer_to_universe(value):
  6. if value != 42:
  7. raise ValidationError(
  8. "This is not the answer to life, universe and everything!", code="not42"
  9. )
  10. class ModelToValidate(models.Model):
  11. name = models.CharField(max_length=100)
  12. created = models.DateTimeField(default=datetime.now)
  13. number = models.IntegerField(db_column="number_val")
  14. parent = models.ForeignKey(
  15. "self",
  16. models.SET_NULL,
  17. blank=True,
  18. null=True,
  19. limit_choices_to={"number": 10},
  20. )
  21. email = models.EmailField(blank=True)
  22. ufm = models.ForeignKey(
  23. "UniqueFieldsModel",
  24. models.SET_NULL,
  25. to_field="unique_charfield",
  26. blank=True,
  27. null=True,
  28. )
  29. url = models.URLField(blank=True)
  30. f_with_custom_validator = models.IntegerField(
  31. blank=True, null=True, validators=[validate_answer_to_universe]
  32. )
  33. f_with_iterable_of_validators = models.IntegerField(
  34. blank=True, null=True, validators=(validate_answer_to_universe,)
  35. )
  36. slug = models.SlugField(blank=True)
  37. def clean(self):
  38. super().clean()
  39. if self.number == 11:
  40. raise ValidationError("Invalid number supplied!")
  41. class UniqueFieldsModel(models.Model):
  42. unique_charfield = models.CharField(max_length=100, unique=True)
  43. unique_integerfield = models.IntegerField(unique=True)
  44. non_unique_field = models.IntegerField()
  45. class CustomPKModel(models.Model):
  46. my_pk_field = models.CharField(max_length=100, primary_key=True)
  47. class UniqueTogetherModel(models.Model):
  48. cfield = models.CharField(max_length=100)
  49. ifield = models.IntegerField()
  50. efield = models.EmailField()
  51. class Meta:
  52. unique_together = (
  53. (
  54. "ifield",
  55. "cfield",
  56. ),
  57. ["ifield", "efield"],
  58. )
  59. class UniqueForDateModel(models.Model):
  60. start_date = models.DateField()
  61. end_date = models.DateTimeField()
  62. count = models.IntegerField(
  63. unique_for_date="start_date", unique_for_year="end_date"
  64. )
  65. order = models.IntegerField(unique_for_month="end_date")
  66. name = models.CharField(max_length=100)
  67. class CustomMessagesModel(models.Model):
  68. other = models.IntegerField(blank=True, null=True)
  69. number = models.IntegerField(
  70. db_column="number_val",
  71. error_messages={"null": "NULL", "not42": "AAARGH", "not_equal": "%s != me"},
  72. validators=[validate_answer_to_universe],
  73. )
  74. class AuthorManager(models.Manager):
  75. def get_queryset(self):
  76. qs = super().get_queryset()
  77. return qs.filter(archived=False)
  78. class Author(models.Model):
  79. name = models.CharField(max_length=100)
  80. archived = models.BooleanField(default=False)
  81. objects = AuthorManager()
  82. class Article(models.Model):
  83. title = models.CharField(max_length=100)
  84. author = models.ForeignKey(Author, models.CASCADE)
  85. pub_date = models.DateTimeField(blank=True)
  86. def clean(self):
  87. if self.pub_date is None:
  88. self.pub_date = datetime.now()
  89. class Post(models.Model):
  90. title = models.CharField(max_length=50, unique_for_date="posted", blank=True)
  91. slug = models.CharField(max_length=50, unique_for_year="posted", blank=True)
  92. subtitle = models.CharField(max_length=50, unique_for_month="posted", blank=True)
  93. posted = models.DateField()
  94. class FlexibleDatePost(models.Model):
  95. title = models.CharField(max_length=50, unique_for_date="posted", blank=True)
  96. slug = models.CharField(max_length=50, unique_for_year="posted", blank=True)
  97. subtitle = models.CharField(max_length=50, unique_for_month="posted", blank=True)
  98. posted = models.DateField(blank=True, null=True)
  99. class UniqueErrorsModel(models.Model):
  100. name = models.CharField(
  101. max_length=100,
  102. unique=True,
  103. error_messages={"unique": "Custom unique name message."},
  104. )
  105. no = models.IntegerField(
  106. unique=True, error_messages={"unique": "Custom unique number message."}
  107. )
  108. class GenericIPAddressTestModel(models.Model):
  109. generic_ip = models.GenericIPAddressField(blank=True, null=True, unique=True)
  110. v4_ip = models.GenericIPAddressField(blank=True, null=True, protocol="ipv4")
  111. v6_ip = models.GenericIPAddressField(blank=True, null=True, protocol="ipv6")
  112. ip_verbose_name = models.GenericIPAddressField(
  113. "IP Address Verbose", blank=True, null=True
  114. )
  115. class GenericIPAddrUnpackUniqueTest(models.Model):
  116. generic_v4unpack_ip = models.GenericIPAddressField(
  117. null=True, blank=True, unique=True, unpack_ipv4=True
  118. )
  119. class UniqueFuncConstraintModel(models.Model):
  120. field = models.CharField(max_length=255)
  121. class Meta:
  122. required_db_features = {"supports_expression_indexes"}
  123. constraints = [
  124. models.UniqueConstraint(Lower("field"), name="func_lower_field_uq"),
  125. ]
  126. class Product(models.Model):
  127. price = models.IntegerField(null=True)
  128. discounted_price = models.IntegerField(null=True)
  129. class Meta:
  130. required_db_features = {
  131. "supports_table_check_constraints",
  132. }
  133. constraints = [
  134. models.CheckConstraint(
  135. check=models.Q(price__gt=models.F("discounted_price")),
  136. name="price_gt_discounted_price_validation",
  137. ),
  138. ]
  139. class ChildProduct(Product):
  140. class Meta:
  141. required_db_features = {
  142. "supports_table_check_constraints",
  143. }
  144. class UniqueConstraintProduct(models.Model):
  145. name = models.CharField(max_length=255)
  146. color = models.CharField(max_length=32)
  147. rank = models.IntegerField()
  148. class Meta:
  149. constraints = [
  150. models.UniqueConstraint(
  151. fields=["name", "color"], name="name_color_uniq_validation"
  152. ),
  153. models.UniqueConstraint(fields=["rank"], name="rank_uniq_validation"),
  154. ]
  155. class ChildUniqueConstraintProduct(UniqueConstraintProduct):
  156. pass
  157. class UniqueConstraintConditionProduct(models.Model):
  158. name = models.CharField(max_length=255)
  159. color = models.CharField(max_length=31, null=True, blank=True)
  160. class Meta:
  161. required_db_features = {"supports_partial_indexes"}
  162. constraints = [
  163. models.UniqueConstraint(
  164. fields=["name"],
  165. name="name_without_color_uniq_validation",
  166. condition=models.Q(color__isnull=True),
  167. ),
  168. ]
  169. class UniqueConstraintNullsDistinctProduct(models.Model):
  170. name = models.CharField(max_length=255, blank=True, null=True)
  171. class Meta:
  172. required_db_features = {"supports_nulls_distinct_unique_constraints"}
  173. constraints = [
  174. models.UniqueConstraint(
  175. fields=["name"],
  176. name="name_nulls_not_distinct_uniq",
  177. nulls_distinct=False,
  178. ),
  179. ]