models.py 17 KB

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