models.py 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566
  1. import json
  2. import tempfile
  3. import uuid
  4. from django.contrib.contenttypes.fields import GenericForeignKey, GenericRelation
  5. from django.contrib.contenttypes.models import ContentType
  6. from django.core.files.storage import FileSystemStorage
  7. from django.core.serializers.json import DjangoJSONEncoder
  8. from django.db import connection, models
  9. from django.db.models import F, Value
  10. from django.db.models.fields.files import ImageFieldFile
  11. from django.db.models.functions import Lower
  12. from django.utils.functional import SimpleLazyObject
  13. from django.utils.translation import gettext_lazy as _
  14. try:
  15. from PIL import Image
  16. except ImportError:
  17. Image = None
  18. test_collation = SimpleLazyObject(
  19. lambda: connection.features.test_collations.get("non_default")
  20. )
  21. class Foo(models.Model):
  22. a = models.CharField(max_length=10)
  23. d = models.DecimalField(max_digits=5, decimal_places=3)
  24. def get_foo():
  25. return Foo.objects.get(id=1).pk
  26. class Bar(models.Model):
  27. b = models.CharField(max_length=10)
  28. a = models.ForeignKey(Foo, models.CASCADE, default=get_foo, related_name="bars")
  29. class Whiz(models.Model):
  30. CHOICES = {
  31. "Group 1": {
  32. 1: "First",
  33. 2: "Second",
  34. },
  35. "Group 2": (
  36. (3, "Third"),
  37. (4, "Fourth"),
  38. ),
  39. 0: "Other",
  40. 5: _("translated"),
  41. }
  42. c = models.IntegerField(choices=CHOICES, null=True)
  43. class WhizDelayed(models.Model):
  44. c = models.IntegerField(choices=(), null=True)
  45. # Contrived way of adding choices later.
  46. WhizDelayed._meta.get_field("c").choices = Whiz.CHOICES
  47. class WhizIter(models.Model):
  48. c = models.IntegerField(choices=iter(Whiz.CHOICES.items()), null=True)
  49. class WhizIterEmpty(models.Model):
  50. c = models.CharField(choices=iter(()), blank=True, max_length=1)
  51. class Choiceful(models.Model):
  52. class Suit(models.IntegerChoices):
  53. DIAMOND = 1, "Diamond"
  54. SPADE = 2, "Spade"
  55. HEART = 3, "Heart"
  56. CLUB = 4, "Club"
  57. no_choices = models.IntegerField(null=True)
  58. empty_choices = models.IntegerField(choices=(), null=True)
  59. with_choices = models.IntegerField(choices=[(1, "A")], null=True)
  60. with_choices_dict = models.IntegerField(choices={1: "A"}, null=True)
  61. with_choices_nested_dict = models.IntegerField(
  62. choices={"Thing": {1: "A"}}, null=True
  63. )
  64. empty_choices_bool = models.BooleanField(choices=())
  65. empty_choices_text = models.TextField(choices=())
  66. choices_from_enum = models.IntegerField(choices=Suit)
  67. choices_from_iterator = models.IntegerField(choices=((i, str(i)) for i in range(3)))
  68. class BigD(models.Model):
  69. d = models.DecimalField(max_digits=32, decimal_places=30)
  70. class FloatModel(models.Model):
  71. size = models.FloatField()
  72. class BigS(models.Model):
  73. s = models.SlugField(max_length=255)
  74. class UnicodeSlugField(models.Model):
  75. s = models.SlugField(max_length=255, allow_unicode=True)
  76. class AutoModel(models.Model):
  77. value = models.AutoField(primary_key=True)
  78. class BigAutoModel(models.Model):
  79. value = models.BigAutoField(primary_key=True)
  80. class SmallAutoModel(models.Model):
  81. value = models.SmallAutoField(primary_key=True)
  82. class SmallIntegerModel(models.Model):
  83. value = models.SmallIntegerField()
  84. class IntegerModel(models.Model):
  85. value = models.IntegerField()
  86. class BigIntegerModel(models.Model):
  87. value = models.BigIntegerField()
  88. null_value = models.BigIntegerField(null=True, blank=True)
  89. class PositiveBigIntegerModel(models.Model):
  90. value = models.PositiveBigIntegerField()
  91. class PositiveSmallIntegerModel(models.Model):
  92. value = models.PositiveSmallIntegerField()
  93. class PositiveIntegerModel(models.Model):
  94. value = models.PositiveIntegerField()
  95. class Post(models.Model):
  96. title = models.CharField(max_length=100)
  97. body = models.TextField()
  98. class NullBooleanModel(models.Model):
  99. nbfield = models.BooleanField(null=True, blank=True)
  100. class BooleanModel(models.Model):
  101. bfield = models.BooleanField()
  102. class DateTimeModel(models.Model):
  103. d = models.DateField()
  104. dt = models.DateTimeField()
  105. t = models.TimeField()
  106. class DurationModel(models.Model):
  107. field = models.DurationField()
  108. class NullDurationModel(models.Model):
  109. field = models.DurationField(null=True)
  110. class PrimaryKeyCharModel(models.Model):
  111. string = models.CharField(max_length=10, primary_key=True)
  112. class FksToBooleans(models.Model):
  113. """Model with FKs to models with {Null,}BooleanField's, #15040"""
  114. bf = models.ForeignKey(BooleanModel, models.CASCADE)
  115. nbf = models.ForeignKey(NullBooleanModel, models.CASCADE)
  116. class FkToChar(models.Model):
  117. """Model with FK to a model with a CharField primary key, #19299"""
  118. out = models.ForeignKey(PrimaryKeyCharModel, models.CASCADE)
  119. class RenamedField(models.Model):
  120. modelname = models.IntegerField(name="fieldname", choices=((1, "One"),))
  121. class VerboseNameField(models.Model):
  122. id = models.AutoField("verbose pk", primary_key=True)
  123. field1 = models.BigIntegerField("verbose field1")
  124. field2 = models.BooleanField("verbose field2", default=False)
  125. field3 = models.CharField("verbose field3", max_length=10)
  126. field4 = models.DateField("verbose field4")
  127. field5 = models.DateTimeField("verbose field5")
  128. field6 = models.DecimalField("verbose field6", max_digits=6, decimal_places=1)
  129. field7 = models.EmailField("verbose field7")
  130. field8 = models.FileField("verbose field8", upload_to="unused")
  131. field9 = models.FilePathField("verbose field9")
  132. field10 = models.FloatField("verbose field10")
  133. # Don't want to depend on Pillow in this test
  134. # field_image = models.ImageField("verbose field")
  135. field11 = models.IntegerField("verbose field11")
  136. field12 = models.GenericIPAddressField("verbose field12", protocol="ipv4")
  137. field13 = models.PositiveIntegerField("verbose field13")
  138. field14 = models.PositiveSmallIntegerField("verbose field14")
  139. field15 = models.SlugField("verbose field15")
  140. field16 = models.SmallIntegerField("verbose field16")
  141. field17 = models.TextField("verbose field17")
  142. field18 = models.TimeField("verbose field18")
  143. field19 = models.URLField("verbose field19")
  144. field20 = models.UUIDField("verbose field20")
  145. field21 = models.DurationField("verbose field21")
  146. class GenericIPAddress(models.Model):
  147. ip = models.GenericIPAddressField(null=True, protocol="ipv4")
  148. ###############################################################################
  149. # These models aren't used in any test, just here to ensure they validate
  150. # successfully.
  151. # See ticket #16570.
  152. class DecimalLessThanOne(models.Model):
  153. d = models.DecimalField(max_digits=3, decimal_places=3)
  154. # See ticket #18389.
  155. class FieldClassAttributeModel(models.Model):
  156. field_class = models.CharField
  157. ###############################################################################
  158. class DataModel(models.Model):
  159. short_data = models.BinaryField(max_length=10, default=b"\x08")
  160. data = models.BinaryField()
  161. ###############################################################################
  162. # FileField
  163. class Document(models.Model):
  164. myfile = models.FileField(upload_to="unused", unique=True)
  165. ###############################################################################
  166. # ImageField
  167. # If Pillow available, do these tests.
  168. if Image:
  169. class TestImageFieldFile(ImageFieldFile):
  170. """
  171. Custom Field File class that records whether or not the underlying file
  172. was opened.
  173. """
  174. def __init__(self, *args, **kwargs):
  175. self.was_opened = False
  176. super().__init__(*args, **kwargs)
  177. def open(self):
  178. self.was_opened = True
  179. super().open()
  180. class TestImageField(models.ImageField):
  181. attr_class = TestImageFieldFile
  182. # Set up a temp directory for file storage.
  183. temp_storage_dir = tempfile.mkdtemp()
  184. temp_storage = FileSystemStorage(temp_storage_dir)
  185. class Person(models.Model):
  186. """
  187. Model that defines an ImageField with no dimension fields.
  188. """
  189. name = models.CharField(max_length=50)
  190. mugshot = TestImageField(storage=temp_storage, upload_to="tests")
  191. class AbstractPersonWithHeight(models.Model):
  192. """
  193. Abstract model that defines an ImageField with only one dimension field
  194. to make sure the dimension update is correctly run on concrete subclass
  195. instance post-initialization.
  196. """
  197. mugshot = TestImageField(
  198. storage=temp_storage, upload_to="tests", height_field="mugshot_height"
  199. )
  200. mugshot_height = models.PositiveSmallIntegerField()
  201. class Meta:
  202. abstract = True
  203. class PersonWithHeight(AbstractPersonWithHeight):
  204. """
  205. Concrete model that subclass an abstract one with only on dimension
  206. field.
  207. """
  208. name = models.CharField(max_length=50)
  209. class PersonWithHeightAndWidth(models.Model):
  210. """
  211. Model that defines height and width fields after the ImageField.
  212. """
  213. name = models.CharField(max_length=50)
  214. mugshot = TestImageField(
  215. storage=temp_storage,
  216. upload_to="tests",
  217. height_field="mugshot_height",
  218. width_field="mugshot_width",
  219. )
  220. mugshot_height = models.PositiveSmallIntegerField()
  221. mugshot_width = models.PositiveSmallIntegerField()
  222. class PersonDimensionsFirst(models.Model):
  223. """
  224. Model that defines height and width fields before the ImageField.
  225. """
  226. name = models.CharField(max_length=50)
  227. mugshot_height = models.PositiveSmallIntegerField()
  228. mugshot_width = models.PositiveSmallIntegerField()
  229. mugshot = TestImageField(
  230. storage=temp_storage,
  231. upload_to="tests",
  232. height_field="mugshot_height",
  233. width_field="mugshot_width",
  234. )
  235. class PersonTwoImages(models.Model):
  236. """
  237. Model that:
  238. * Defines two ImageFields
  239. * Defines the height/width fields before the ImageFields
  240. * Has a nullable ImageField
  241. """
  242. name = models.CharField(max_length=50)
  243. mugshot_height = models.PositiveSmallIntegerField()
  244. mugshot_width = models.PositiveSmallIntegerField()
  245. mugshot = TestImageField(
  246. storage=temp_storage,
  247. upload_to="tests",
  248. height_field="mugshot_height",
  249. width_field="mugshot_width",
  250. )
  251. headshot_height = models.PositiveSmallIntegerField(blank=True, null=True)
  252. headshot_width = models.PositiveSmallIntegerField(blank=True, null=True)
  253. headshot = TestImageField(
  254. blank=True,
  255. null=True,
  256. storage=temp_storage,
  257. upload_to="tests",
  258. height_field="headshot_height",
  259. width_field="headshot_width",
  260. )
  261. class CustomJSONDecoder(json.JSONDecoder):
  262. def __init__(self, object_hook=None, *args, **kwargs):
  263. return super().__init__(object_hook=self.as_uuid, *args, **kwargs)
  264. def as_uuid(self, dct):
  265. if "uuid" in dct:
  266. dct["uuid"] = uuid.UUID(dct["uuid"])
  267. return dct
  268. class JSONModel(models.Model):
  269. value = models.JSONField()
  270. class Meta:
  271. required_db_features = {"supports_json_field"}
  272. class NullableJSONModel(models.Model):
  273. value = models.JSONField(blank=True, null=True)
  274. value_custom = models.JSONField(
  275. encoder=DjangoJSONEncoder,
  276. decoder=CustomJSONDecoder,
  277. null=True,
  278. )
  279. class Meta:
  280. required_db_features = {"supports_json_field"}
  281. class RelatedJSONModel(models.Model):
  282. value = models.JSONField()
  283. json_model = models.ForeignKey(NullableJSONModel, models.CASCADE)
  284. class Meta:
  285. required_db_features = {"supports_json_field"}
  286. class AllFieldsModel(models.Model):
  287. big_integer = models.BigIntegerField()
  288. binary = models.BinaryField()
  289. boolean = models.BooleanField(default=False)
  290. char = models.CharField(max_length=10)
  291. date = models.DateField()
  292. datetime = models.DateTimeField()
  293. decimal = models.DecimalField(decimal_places=2, max_digits=2)
  294. duration = models.DurationField()
  295. email = models.EmailField()
  296. file_path = models.FilePathField()
  297. floatf = models.FloatField()
  298. integer = models.IntegerField()
  299. generic_ip = models.GenericIPAddressField()
  300. positive_integer = models.PositiveIntegerField()
  301. positive_small_integer = models.PositiveSmallIntegerField()
  302. slug = models.SlugField()
  303. small_integer = models.SmallIntegerField()
  304. text = models.TextField()
  305. time = models.TimeField()
  306. url = models.URLField()
  307. uuid = models.UUIDField()
  308. fo = models.ForeignObject(
  309. "self",
  310. on_delete=models.CASCADE,
  311. from_fields=["positive_integer"],
  312. to_fields=["id"],
  313. related_name="reverse",
  314. )
  315. fk = models.ForeignKey("self", models.CASCADE, related_name="reverse2")
  316. m2m = models.ManyToManyField("self")
  317. oto = models.OneToOneField("self", models.CASCADE)
  318. object_id = models.PositiveIntegerField()
  319. content_type = models.ForeignKey(ContentType, models.CASCADE)
  320. gfk = GenericForeignKey()
  321. gr = GenericRelation(DataModel)
  322. class ManyToMany(models.Model):
  323. m2m = models.ManyToManyField("self")
  324. ###############################################################################
  325. class UUIDModel(models.Model):
  326. field = models.UUIDField()
  327. class NullableUUIDModel(models.Model):
  328. field = models.UUIDField(blank=True, null=True)
  329. class PrimaryKeyUUIDModel(models.Model):
  330. id = models.UUIDField(primary_key=True, default=uuid.uuid4)
  331. class RelatedToUUIDModel(models.Model):
  332. uuid_fk = models.ForeignKey("PrimaryKeyUUIDModel", models.CASCADE)
  333. class UUIDChild(PrimaryKeyUUIDModel):
  334. pass
  335. class UUIDGrandchild(UUIDChild):
  336. pass
  337. class GeneratedModel(models.Model):
  338. a = models.IntegerField()
  339. b = models.IntegerField()
  340. field = models.GeneratedField(expression=F("a") + F("b"), db_persist=True)
  341. class Meta:
  342. required_db_features = {"supports_stored_generated_columns"}
  343. class GeneratedModelVirtual(models.Model):
  344. a = models.IntegerField()
  345. b = models.IntegerField()
  346. field = models.GeneratedField(expression=F("a") + F("b"), db_persist=False)
  347. class Meta:
  348. required_db_features = {"supports_virtual_generated_columns"}
  349. class GeneratedModelParams(models.Model):
  350. field = models.GeneratedField(
  351. expression=Value("Constant", output_field=models.CharField(max_length=10)),
  352. db_persist=True,
  353. )
  354. class Meta:
  355. required_db_features = {"supports_stored_generated_columns"}
  356. class GeneratedModelParamsVirtual(models.Model):
  357. field = models.GeneratedField(
  358. expression=Value("Constant", output_field=models.CharField(max_length=10)),
  359. db_persist=False,
  360. )
  361. class Meta:
  362. required_db_features = {"supports_virtual_generated_columns"}
  363. class GeneratedModelOutputField(models.Model):
  364. name = models.CharField(max_length=10)
  365. lower_name = models.GeneratedField(
  366. expression=Lower("name"),
  367. output_field=models.CharField(db_collation=test_collation, max_length=11),
  368. db_persist=True,
  369. )
  370. class Meta:
  371. required_db_features = {
  372. "supports_stored_generated_columns",
  373. "supports_collation_on_charfield",
  374. }
  375. class GeneratedModelOutputFieldVirtual(models.Model):
  376. name = models.CharField(max_length=10)
  377. lower_name = models.GeneratedField(
  378. expression=Lower("name"),
  379. db_persist=False,
  380. output_field=models.CharField(db_collation=test_collation, max_length=11),
  381. )
  382. class Meta:
  383. required_db_features = {
  384. "supports_virtual_generated_columns",
  385. "supports_collation_on_charfield",
  386. }
  387. class GeneratedModelNull(models.Model):
  388. name = models.CharField(max_length=10, null=True)
  389. lower_name = models.GeneratedField(
  390. expression=Lower("name"), db_persist=True, null=True
  391. )
  392. class Meta:
  393. required_db_features = {"supports_stored_generated_columns"}
  394. class GeneratedModelNullVirtual(models.Model):
  395. name = models.CharField(max_length=10, null=True)
  396. lower_name = models.GeneratedField(
  397. expression=Lower("name"), db_persist=False, null=True
  398. )
  399. class Meta:
  400. required_db_features = {"supports_virtual_generated_columns"}