- Model field reference
- Field options
- Field types
- AutoField
- BigAutoField
- BigIntegerField
- BinaryField
- BooleanField
- CharField
- DateField
- DateTimeField
- DecimalField
- DurationField
- EmailField
- FileField
- FilePathField
- FloatField
- ImageField
- IntegerField
- GenericIPAddressField
- NullBooleanField
- PositiveIntegerField
- PositiveSmallIntegerField
- SlugField
- SmallAutoField
- SmallIntegerField
- TextField
- TimeField
- URLField
- UUIDField
- Relationship fields
- Field API reference
- Field attribute reference
Model field reference
This document contains all the API references of Field
including thefield options and field types Django offers.
See also
If the built-in fields don’t do the trick, you can try django-localflavor (documentation), which contains assortedpieces of code that are useful for particular countries and cultures.
Also, you can easily write your own custom model fields.
Note
Technically, these models are defined in django.db.models.fields
, butfor convenience they’re imported into django.db.models
; the standardconvention is to use from django.db import models
and refer to fields asmodels.<Foo>Field
.
Field options
The following arguments are available to all field types. All are optional.
null
Avoid using null
on string-based fields such asCharField
and TextField
. If a string-based field hasnull=True
, that means it has two possible values for “no data”: NULL
,and the empty string. In most cases, it’s redundant to have two possible valuesfor “no data;” the Django convention is to use the empty string, notNULL
. One exception is when a CharField
has both unique=True
and blank=True
set. In this situation, null=True
is required to avoidunique constraint violations when saving multiple objects with blank values.
For both string-based and non-string-based fields, you will also need toset blank=True
if you wish to permit empty values in forms, as thenull
parameter only affects database storage(see blank
).
Note
When using the Oracle database backend, the value NULL
will be stored todenote the empty string regardless of this attribute.
blank
Note that this is different than null
. null
ispurely database-related, whereas blank
is validation-related. Ifa field has blank=True
, form validation will allow entry of an empty value.If a field has blank=False
, the field will be required.
choices
Field.
choices
- A sequence consisting itself of iterables of exactly two items (e.g.
[(A, B), (A, B) …]
) to use as choices for this field. If choices aregiven, they’re enforced by model validation and thedefault form widget will be a select box with these choices instead of thestandard text field.
The first element in each tuple is the actual value to be set on the model,and the second element is the human-readable name. For example:
- YEAR_IN_SCHOOL_CHOICES = [
- ('FR', 'Freshman'),
- ('SO', 'Sophomore'),
- ('JR', 'Junior'),
- ('SR', 'Senior'),
- ('GR', 'Graduate'),
- ]
Generally, it’s best to define choices inside a model class, and todefine a suitably-named constant for each value:
- from django.db import models
- class Student(models.Model):
- FRESHMAN = 'FR'
- SOPHOMORE = 'SO'
- JUNIOR = 'JR'
- SENIOR = 'SR'
- GRADUATE = 'GR'
- YEAR_IN_SCHOOL_CHOICES = [
- (FRESHMAN, 'Freshman'),
- (SOPHOMORE, 'Sophomore'),
- (JUNIOR, 'Junior'),
- (SENIOR, 'Senior'),
- (GRADUATE, 'Graduate'),
- ]
- year_in_school = models.CharField(
- max_length=2,
- choices=YEAR_IN_SCHOOL_CHOICES,
- default=FRESHMAN,
- )
- def is_upperclass(self):
- return self.year_in_school in {self.JUNIOR, self.SENIOR}
Though you can define a choices list outside of a model class and thenrefer to it, defining the choices and names for each choice inside themodel class keeps all of that information with the class that uses it,and helps reference the choices (e.g, Student.SOPHOMORE
will work anywhere that the Student
model has been imported).
In addition, Django provides enumeration types that you can subclass to definechoices in a concise way:
- from django.utils.translation import gettext_lazy as _
- class Student(models.Model):
- class YearInSchool(models.TextChoices):
- FRESHMAN = 'FR', _('Freshman')
- SOPHOMORE = 'SO', _('Sophomore')
- JUNIOR = 'JR', _('Junior')
- SENIOR = 'SR', _('Senior')
- GRADUATE = 'GR', _('Graduate')
- year_in_school = models.CharField(
- max_length=2,
- choices=YearInSchool.choices,
- default=YearInSchool.FRESHMAN,
- )
- def is_upperclass(self):
- return self.year_in_school in {YearInSchool.JUNIOR, YearInSchool.SENIOR}
These work similar to enum
from Python’s standard library, but with somemodifications:
- Instead of values in the
enum
, Django uses(value, label)
tuples. Thelabel
can be a lazy translatable string. If a tuple is not provided, thelabel is automatically generated from the member name. .label
property is added on values, to return the label specified.- Number of custom properties are added to the enumeration classes –
.choices
,.labels
,.values
, and.names
– to make it easierto access lists of those separate parts of the enumeration. Use.choices
as a suitable value to pass tochoices
in a field definition. - The use of
enum.unique()
is enforced to ensure that values cannot bedefined multiple times. This is unlikely to be expected in choices for afield.Note thatYearInSchool.SENIOR
,YearInSchool['SENIOR']
,YearInSchool('SR')
work as expected, whileYearInSchool.SENIOR.label
isa translatable string.
If you don’t need to have the human-readable names translated, you can havethem inferred from the member name (replacing underscores to spaces and usingtitle-case):
- class YearInSchool(models.TextChoices):
- FRESHMAN = 'FR'
- SOPHOMORE = 'SO'
- JUNIOR = 'JR'
- SENIOR = 'SR'
- GRADUATE = 'GR'
Since the case where the enum values need to be integers is extremely common,Django provides a IntegerChoices
class. For example:
- class Card(models.Model):
- class Suit(models.IntegerChoices):
- DIAMOND = 1
- SPADE = 2
- HEART = 3
- CLUB = 4
- suit = models.IntegerField(choices=Suit.choices)
It is also possible to make use of the Enum Functional API with the caveatthat labels are automatically generated as highlighted above:
- >>> MedalType = models.TextChoices('MedalType', 'GOLD SILVER BRONZE')
- >>> MedalType.choices
- [('GOLD', 'Gold'), ('SILVER', 'Silver'), ('BRONZE', 'Bronze')]
- >>> Place = models.IntegerChoices('Place', 'FIRST SECOND THIRD')
- >>> Place.choices
- [(1, 'First'), (2, 'Second'), (3, 'Third')]
If you require support for a concrete data type other than int
or str
,you can subclass Choices
and the required concrete data type, e.g.:class:datetime.date
for use with DateField
:
- class MoonLandings(datetime.date, models.Choices):
- APOLLO_11 = 1969, 7, 20, 'Apollo 11 (Eagle)'
- APOLLO_12 = 1969, 11, 19, 'Apollo 12 (Intrepid)'
- APOLLO_14 = 1971, 2, 5, 'Apollo 14 (Antares)'
- APOLLO_15 = 1971, 7, 30, 'Apollo 15 (Falcon)'
- APOLLO_16 = 1972, 4, 21, 'Apollo 16 (Orion)'
- APOLLO_17 = 1972, 12, 11, 'Apollo 17 (Challenger)'
You can also collect your available choices into named groups that canbe used for organizational purposes:
- MEDIA_CHOICES = [
- ('Audio', (
- ('vinyl', 'Vinyl'),
- ('cd', 'CD'),
- )
- ),
- ('Video', (
- ('vhs', 'VHS Tape'),
- ('dvd', 'DVD'),
- )
- ),
- ('unknown', 'Unknown'),
- ]
The first element in each tuple is the name to apply to the group. Thesecond element is an iterable of 2-tuples, with each 2-tuple containinga value and a human-readable name for an option. Grouped options may becombined with ungrouped options within a single list (such as theunknown option in this example). Grouping is not supported by the customenumeration types for managing choices.
For each model field that has choices
set, Django will add amethod to retrieve the human-readable name for the field’s current value. Seeget_FOO_display()
in the database APIdocumentation.
Note that choices can be any sequence object – not necessarily a list ortuple. This lets you construct choices dynamically. But if you find yourselfhacking choices
to be dynamic, you’re probably better off usinga proper database table with a ForeignKey
. choices
ismeant for static data that doesn’t change much, if ever.
Note
A new migration is created each time the order of choices
changes.
Unless blank=False
is set on the field along with adefault
then a label containing "————-"
will be renderedwith the select box. To override this behavior, add a tuple to choices
containing None
; e.g. (None, 'Your String For Display')
.Alternatively, you can use an empty string instead of None
where this makessense - such as on a CharField
. To change the labelwhen using one of the custom enumeration types, set the empty
attributeon the class:
- class Answer(models.IntegerChoices):
- NO = 0, _('No')
- YES = 1, _('Yes')
- __empty__ = _('(Unknown)')
New in Django 3.0:The TextChoices
, IntegerChoices
, and Choices
classes were added.
db_column
Field.
db_column
- The name of the database column to use for this field. If this isn’t given,Django will use the field’s name.
If your database column name is an SQL reserved word, or containscharacters that aren’t allowed in Python variable names – notably, thehyphen – that’s OK. Django quotes column and table names behind thescenes.
db_index
db_tablespace
Field.
db_tablespace
- The name of the database tablespace to use forthis field’s index, if this field is indexed. The default is the project’s
DEFAULT_INDEX_TABLESPACE
setting, if set, or thedb_tablespace
of the model, if any. If the backend doesn’tsupport tablespaces for indexes, this option is ignored.
default
Field.
default
- The default value for the field. This can be a value or a callable object. Ifcallable it will be called every time a new object is created.
The default can’t be a mutable object (model instance, list
, set
, etc.),as a reference to the same instance of that object would be used as the defaultvalue in all new model instances. Instead, wrap the desired default in acallable. For example, if you want to specify a default dict
forJSONField
, use a function:
- def contact_default():
- return {"email": "to1@example.com"}
- contact_info = JSONField("ContactInfo", default=contact_default)
lambda
s can’t be used for field options like default
because theycan’t be serialized by migrations. See thatdocumentation for other caveats.
For fields like ForeignKey
that map to model instances, defaultsshould be the value of the field they reference (pk
unlessto_field
is set) instead of model instances.
The default value is used when new model instances are created and a valueisn’t provided for the field. When the field is a primary key, the default isalso used when the field is set to None
.
editable
Field.
editable
- If
False
, the field will not be displayed in the admin or any otherModelForm
. They are also skipped during modelvalidation. Default isTrue
.
error_messages
Field.
error_messages
- The
error_messages
argument lets you override the default messages that thefield will raise. Pass in a dictionary with keys matching the error messages youwant to override.
Error message keys include null
, blank
, invalid
, invalid_choice
,unique
, and unique_for_date
. Additional error message keys arespecified for each field in the Field types section below.
These error messages often don’t propagate to forms. SeeConsiderations regarding model’s error_messages.
help_text
Field.
help_text
- Extra “help” text to be displayed with the form widget. It’s useful fordocumentation even if your field isn’t used on a form.
Note that this value is not HTML-escaped in automatically-generatedforms. This lets you include HTML in help_text
if you sodesire. For example:
- help_text="Please use the following format: <em>YYYY-MM-DD</em>."
Alternatively you can use plain text anddjango.utils.html.escape()
to escape any HTML special characters. Ensurethat you escape any help text that may come from untrusted users to avoid across-site scripting attack.
primary_key
If you don’t specify primary_key=True
for any field in your model, Djangowill automatically add an AutoField
to hold the primary key, so youdon’t need to set primary_key=True
on any of your fields unless you want tooverride the default primary-key behavior. For more, seeAutomatic primary key fields.
primary_key=True
implies null=False
andunique=True
. Only one primary key is allowed on anobject.
The primary key field is read-only. If you change the value of the primarykey on an existing object and then save it, a new object will be createdalongside the old one.
unique
This is enforced at the database level and by model validation. Ifyou try to save a model with a duplicate value in a unique
field, a django.db.IntegrityError
will be raised by the model’ssave()
method.
This option is valid on all field types except ManyToManyField
andOneToOneField
.
Note that when unique
is True
, you don’t need to specifydb_index
, because unique
implies the creation of an index.
unique_for_date
Field.
unique_for_date
- Set this to the name of a
DateField
orDateTimeField
torequire that this field be unique for the value of the date field.
For example, if you have a field title
that hasunique_for_date="pub_date"
, then Django wouldn’t allow the entry of tworecords with the same title
and pub_date
.
Note that if you set this to point to a DateTimeField
, only the dateportion of the field will be considered. Besides, when USE_TZ
isTrue
, the check will be performed in the current time zone at the time the object gets saved.
This is enforced by Model.validate_unique()
during model validationbut not at the database level. If any unique_for_date
constraintinvolves fields that are not part of a ModelForm
(forexample, if one of the fields is listed in exclude
or haseditable=False
), Model.validate_unique()
willskip validation for that particular constraint.
unique_for_month
Field.
unique_for_month
- Like
unique_for_date
, but requires the field to be unique withrespect to the month.
unique_for_year
Field.
unique_for_year
- Like
unique_for_date
andunique_for_month
.
verbose_name
Field.
verbose_name
- A human-readable name for the field. If the verbose name isn’t given, Djangowill automatically create it using the field’s attribute name, convertingunderscores to spaces. See Verbose field names.
validators
Field.
validators
- A list of validators to run for this field. See the validatorsdocumentation for more information.
Registering and fetching lookups
Field
implements the lookup registration API.The API can be used to customize which lookups are available for a field class, andhow lookups are fetched from a field.
Field types
AutoField
- class
AutoField
(**options) - An
IntegerField
that automatically incrementsaccording to available IDs. You usually won’t need to use this directly; aprimary key field will automatically be added to your model if you don’t specifyotherwise. See Automatic primary key fields.
BigAutoField
- class
BigAutoField
(**options) - A 64-bit integer, much like an
AutoField
except that it isguaranteed to fit numbers from1
to9223372036854775807
.
BigIntegerField
- class
BigIntegerField
(**options) - A 64-bit integer, much like an
IntegerField
except that it isguaranteed to fit numbers from-9223372036854775808
to9223372036854775807
. The default form widget for this field is aTextInput
.
BinaryField
- class
BinaryField
(max_length=None, **options) - A field to store raw binary data. It can be assigned
bytes
,bytearray
, ormemoryview
.
By default, BinaryField
sets editable
to False
, in whichcase it can’t be included in a ModelForm
.
BinaryField
has one extra optional argument:
BinaryField.
max_length
- The maximum length (in characters) of the field. The maximum length isenforced in Django’s validation using
MaxLengthValidator
.
Abusing BinaryField
Although you might think about storing files in the database, consider thatit is bad design in 99% of the cases. This field is not a replacement forproper static files handling.
BooleanField
The default form widget for this field is CheckboxInput
,or NullBooleanSelect
if null=True
.
The default value of BooleanField
is None
when Field.default
isn’t defined.
CharField
For large amounts of text, use TextField
.
The default form widget for this field is a TextInput
.
CharField
has one extra required argument:
CharField.
max_length
- The maximum length (in characters) of the field. The max_length is enforcedat the database level and in Django’s validation using
MaxLengthValidator
.
Note
If you are writing an application that must be portable to multipledatabase backends, you should be aware that there are restrictions onmax_length
for some backends. Refer to the database backendnotes for details.
DateField
- class
DateField
(auto_now=False, auto_now_add=False, **options) A date, represented in Python by a
datetime.date
instance. Has a few extra,optional arguments:- Automatically set the field to now every time the object is saved. Usefulfor “last-modified” timestamps. Note that the current date is _always_used; it’s not just a default value that you can override.
The field is only automatically updated when calling Model.save()
. The field isn’t updated when making updatesto other fields in other ways such as QuerySet.update()
, though you can specify a customvalue for the field in an update like that.
DateField.
auto_now_add
Automatically set the field to now when the object is first created. Usefulfor creation of timestamps. Note that the current date is always used;it’s not just a default value that you can override. So even if youset a value for this field when creating the object, it will be ignored.If you want to be able to modify this field, set the following instead of
auto_now_add=True
:- For
DateField
:default=date.today
- fromdatetime.date.today()
- For
DateTimeField
:default=timezone.now
- fromdjango.utils.timezone.now()
The default form widget for this field is aTextInput
. The admin adds a JavaScript calendar,and a shortcut for “Today”. Includes an additionalinvalid_date
errormessage key.
- For
The options auto_now_add
, auto_now
, and default
are mutually exclusive.Any combination of these options will result in an error.
Note
As currently implemented, setting auto_now
or auto_now_add
toTrue
will cause the field to have editable=False
and blank=True
set.
Note
The auto_now
and auto_now_add
options will always use the date inthe default timezone at the moment ofcreation or update. If you need something different, you may want toconsider using your own callable default or overriding save()
insteadof using auto_now
or auto_now_add
; or using a DateTimeField
instead of a DateField
and deciding how to handle the conversion fromdatetime to date at display time.
DateTimeField
- class
DateTimeField
(auto_now=False, auto_now_add=False, **options) - A date and time, represented in Python by a
datetime.datetime
instance.Takes the same extra arguments asDateField
.
The default form widget for this field is a singleTextInput
. The admin uses two separateTextInput
widgets with JavaScript shortcuts.
DecimalField
- class
DecimalField
(max_digits=None, decimal_places=None, **options) - A fixed-precision decimal number, represented in Python by a
Decimal
instance. It validates the input usingDecimalValidator
.
Has two required arguments:
DecimalField.
max_digits
The maximum number of digits allowed in the number. Note that this numbermust be greater than or equal to
decimal_places
.- The number of decimal places to store with the number.
For example, to store numbers up to 999
with a resolution of 2 decimalplaces, you’d use:
- models.DecimalField(..., max_digits=5, decimal_places=2)
And to store numbers up to approximately one billion with a resolution of 10decimal places:
- models.DecimalField(..., max_digits=19, decimal_places=10)
The default form widget for this field is a NumberInput
when localize
is False
orTextInput
otherwise.
Note
For more information about the differences between theFloatField
and DecimalField
classes, pleasesee FloatField vs. DecimalField.
DurationField
- class
DurationField
(**options) - A field for storing periods of time - modeled in Python by
timedelta
. When used on PostgreSQL, the data typeused is aninterval
and on Oracle the data type isINTERVAL DAY(9) TOSECOND(6)
. Otherwise abigint
of microseconds is used.
Note
Arithmetic with DurationField
works in most cases. However on alldatabases other than PostgreSQL, comparing the value of a DurationField
to arithmetic on DateTimeField
instances will not work as expected.
EmailField
- class
EmailField
(max_length=254, **options) - A
CharField
that checks that the value is a valid email address usingEmailValidator
.
FileField
Note
The primary_key
argument isn’t supported and will raise an error ifused.
Has two optional arguments:
FileField.
upload_to
- This attribute provides a way of setting the upload directory and file name,and can be set in two ways. In both cases, the value is passed to the
Storage.save()
method.
If you specify a string value or a Path
, it may containstrftime()
formatting, which will be replaced by the date/timeof the file upload (so that uploaded files don’t fill up the givendirectory). For example:
- class MyModel(models.Model):
- # file will be uploaded to MEDIA_ROOT/uploads
- upload = models.FileField(upload_to='uploads/')
- # or...
- # file will be saved to MEDIA_ROOT/uploads/2015/01/30
- upload = models.FileField(upload_to='uploads/%Y/%m/%d/')
If you are using the defaultFileSystemStorage
, the string valuewill be appended to your MEDIA_ROOT
path to form the location onthe local filesystem where uploaded files will be stored. If you are usinga different storage, check that storage’s documentation to see how ithandles upload_to
.
upload_to
may also be a callable, such as a function. This will becalled to obtain the upload path, including the filename. This callable mustaccept two arguments and return a Unix-style path (with forward slashes)to be passed along to the storage system. The two arguments are:
ArgumentDescriptioninstance
An instance of the model where theFileField
is defined. More specifically,this is the particular instance where thecurrent file is being attached.
In most cases, this object will not have beensaved to the database yet, so if it uses thedefault AutoField
, it might not yet have avalue for its primary key field.filename
The filename that was originally given to thefile. This may or may not be taken into accountwhen determining the final destination path.
For example:
- def user_directory_path(instance, filename):
- # file will be uploaded to MEDIA_ROOT/user_<id>/<filename>
- return 'user_{0}/{1}'.format(instance.user.id, filename)
- class MyModel(models.Model):
- upload = models.FileField(upload_to=user_directory_path)
Changed in Django 3.0:Support for pathlib.Path
was added.
FileField.
storage
- A storage object, which handles the storage and retrieval of yourfiles. See Managing files for details on how to provide this object.
The default form widget for this field is aClearableFileInput
.
Using a FileField
or an ImageField
(see below) in a modeltakes a few steps:
- In your settings file, you’ll need to define
MEDIA_ROOT
as thefull path to a directory where you’d like Django to store uploaded files.(For performance, these files are not stored in the database.) DefineMEDIA_URL
as the base public URL of that directory. Make surethat this directory is writable by the Web server’s user account. - Add the
FileField
orImageField
to your model, definingtheupload_to
option to specify a subdirectory ofMEDIA_ROOT
to use for uploaded files. - All that will be stored in your database is a path to the file(relative to
MEDIA_ROOT
). You’ll most likely want to use theconvenienceurl
attributeprovided by Django. For example, if yourImageField
is calledmug_shot
, you can get the absolute path to your image in a template with{{ object.mug_shot.url }}
.For example, say yourMEDIA_ROOT
is set to'/home/media'
, andupload_to
is set to'photos/%Y/%m/%d'
. The'%Y/%m/%d'
part ofupload_to
isstrftime()
formatting;'%Y'
is the four-digit year,'%m'
is the two-digit month and'%d'
isthe two-digit day. If you upload a file on Jan. 15, 2007, it will be saved inthe directory/home/media/photos/2007/01/15
.
If you wanted to retrieve the uploaded file’s on-disk filename, or the file’ssize, you could use the name
andsize
attributes respectively; for moreinformation on the available attributes and methods, see theFile
class reference and the Managing filestopic guide.
Note
The file is saved as part of saving the model in the database, so the actualfile name used on disk cannot be relied on until after the model has beensaved.
The uploaded file’s relative URL can be obtained using theurl
attribute. Internally,this calls the url()
method of theunderlying Storage
class.
Note that whenever you deal with uploaded files, you should pay close attentionto where you’re uploading them and what type of files they are, to avoidsecurity holes. Validate all uploaded files so that you’re sure the files arewhat you think they are. For example, if you blindly let somebody upload files,without validation, to a directory that’s within your Web server’s documentroot, then somebody could upload a CGI or PHP script and execute that script byvisiting its URL on your site. Don’t allow that.
Also note that even an uploaded HTML file, since it can be executed by thebrowser (though not by the server), can pose security threats that areequivalent to XSS or CSRF attacks.
FileField
instances are created in your database as varchar
columns with a default max length of 100 characters. As with other fields, youcan change the maximum length using the max_length
argument.
FileField and FieldFile
- class
FieldFile
- When you access a
FileField
on a model, you aregiven an instance ofFieldFile
as a proxy for accessing the underlyingfile.
The API of FieldFile
mirrors that of File
,with one key difference: The object wrapped by the class is not necessarily awrapper around Python’s built-in file object. Instead, it is a wrapper aroundthe result of the Storage.open()
method, which may be a File
object, or it may be acustom storage’s implementation of the File
API.
In addition to the API inherited from File
such asread()
and write()
, FieldFile
includes several methods thatcan be used to interact with the underlying file:
Warning
Two methods of this class, save()
anddelete()
, default to saving the model object of theassociated FieldFile
in the database.
FieldFile.
name
The name of the file including the relative path from the root of the
Storage
of the associatedFileField
.The result of the underlying
Storage.size()
method.A read-only property to access the file’s relative URL by calling the
url()
method of the underlyingStorage
class.- Opens or reopens the file associated with this instance in the specified
mode
. Unlike the standard Pythonopen()
method, it doesn’t return afile descriptor.
Since the underlying file is opened implicitly when accessing it, it may beunnecessary to call this method except to reset the pointer to the underlyingfile or to change the mode
.
FieldFile.
close
()Behaves like the standard Python
file.close()
method and closes the fileassociated with this instance.- This method takes a filename and file contents and passes them to the storageclass for the field, then associates the stored file with the model field.If you want to manually associate file data with
FileField
instances on your model, thesave()
method is used to persist that file data.
Takes two required arguments: name
which is the name of the file, andcontent
which is an object containing the file’s contents. Theoptional save
argument controls whether or not the model instance issaved after the file associated with this field has been altered. Defaults toTrue
.
Note that the content
argument should be an instance ofdjango.core.files.File
, not Python’s built-in file object.You can construct a File
from an existingPython file object like this:
- from django.core.files import File
- # Open an existing file using Python's built-in open()
- f = open('/path/to/hello.world')
- myfile = File(f)
Or you can construct one from a Python string like this:
- from django.core.files.base import ContentFile
- myfile = ContentFile("hello world")
For more information, see Managing files.
FieldFile.
delete
(save=True)- Deletes the file associated with this instance and clears all attributes onthe field. Note: This method will close the file if it happens to be open when
delete()
is called.
The optional save
argument controls whether or not the model instance issaved after the file associated with this field has been deleted. Defaults toTrue
.
Note that when a model is deleted, related files are not deleted. If you needto cleanup orphaned files, you’ll need to handle it yourself (for instance,with a custom management command that can be run manually or scheduled to runperiodically via e.g. cron).
FilePathField
- class
FilePathField
(path=None, match=None, recursive=False, max_length=100, **options) A
CharField
whose choices are limited to the filenames in a certaindirectory on the filesystem. Has three special arguments, of which the first isrequired:- Required. The absolute filesystem path to a directory from which this
FilePathField
should get its choices. Example:"/home/images"
.
path
may also be a callable, such as a function to dynamically set thepath at runtime. Example:
- import os
- from django.conf import settings
- from django.db import models
- def images_path():
- return os.path.join(settings.LOCAL_FILE_DIR, 'images')
- class MyModel(models.Model):
- file = models.FilePathField(path=images_path)
Changed in Django 3.0:path
can now be a callable.
FilePathField.
match
Optional. A regular expression, as a string, that
FilePathField
will use to filter filenames. Note that the regex will be applied to thebase filename, not the full path. Example:"foo.*.txt$"
, which willmatch a file calledfoo23.txt
but notbar.txt
orfoo23.png
.Optional. Either
True
orFalse
. Default isFalse
. Specifieswhether all subdirectories ofpath
should be includedOptional. Either
True
orFalse
. Default isTrue
. Specifieswhether files in the specified location should be included. Either this orallow_folders
must beTrue
.- Optional. Either
True
orFalse
. Default isFalse
. Specifieswhether folders in the specified location should be included. Either thisorallow_files
must beTrue
.
Of course, these arguments can be used together.
The one potential gotcha is that match
applies to thebase filename, not the full path. So, this example:
- FilePathField(path="/home/images", match="foo.*", recursive=True)
…will match /home/images/foo.png
but not /home/images/foo/bar.png
because the match
applies to the base filename(foo.png
and bar.png
).
FilePathField
instances are created in your database as varchar
columns with a default max length of 100 characters. As with other fields, youcan change the maximum length using the max_length
argument.
FloatField
The default form widget for this field is a NumberInput
when localize
is False
orTextInput
otherwise.
FloatField
vs. DecimalField
The FloatField
class is sometimes mixed up with theDecimalField
class. Although they both represent real numbers, theyrepresent those numbers differently. FloatField
uses Python’s float
type internally, while DecimalField
uses Python’s Decimal
type. Forinformation on the difference between the two, see Python’s documentationfor the decimal
module.
ImageField
- class
ImageField
(upload_to=None, height_field=None, width_field=None, max_length=100, **options) - Inherits all attributes and methods from
FileField
, but alsovalidates that the uploaded object is a valid image.
In addition to the special attributes that are available for FileField
,an ImageField
also has height
and width
attributes.
To facilitate querying on those attributes, ImageField
has two extraoptional arguments:
ImageField.
height_field
Name of a model field which will be auto-populated with the height of theimage each time the model instance is saved.
- Name of a model field which will be auto-populated with the width of theimage each time the model instance is saved.
Requires the Pillow library.
ImageField
instances are created in your database as varchar
columns with a default max length of 100 characters. As with other fields, youcan change the maximum length using the max_length
argument.
The default form widget for this field is aClearableFileInput
.
IntegerField
- class
IntegerField
(**options) - An integer. Values from
-2147483648
to2147483647
are safe in alldatabases supported by Django.
It uses MinValueValidator
andMaxValueValidator
to validate the input basedon the values that the default database supports.
The default form widget for this field is a NumberInput
when localize
is False
orTextInput
otherwise.
GenericIPAddressField
- class
GenericIPAddressField
(protocol='both', unpack_ipv4=False, **options) - An IPv4 or IPv6 address, in string format (e.g.
192.0.2.30
or2a02:42fe::4
). The default form widget for this field is aTextInput
.
The IPv6 address normalization follows RFC 4291#section-2.2 section 2.2,including using the IPv4 format suggested in paragraph 3 of that section, like::ffff:192.0.2.0
. For example, 2001:0::0:01
would be normalized to2001::1
, and ::ffff:0a0a:0a0a
to ::ffff:10.10.10.10
. All charactersare converted to lowercase.
GenericIPAddressField.
protocol
Limits valid inputs to the specified protocol.Accepted values are
'both'
(default),'IPv4'
or'IPv6'
. Matching is case insensitive.- Unpacks IPv4 mapped addresses like
::ffff:192.0.2.1
.If this option is enabled that address would be unpacked to192.0.2.1
. Default is disabled. Can only be usedwhenprotocol
is set to'both'
.
If you allow for blank values, you have to allow for null values since blankvalues are stored as null.
NullBooleanField
- class
NullBooleanField
(**options) - Like
BooleanField
withnull=True
. Use that instead of this fieldas it’s likely to be deprecated in a future version of Django.
PositiveIntegerField
- class
PositiveIntegerField
(**options) - Like an
IntegerField
, but must be either positive or zero (0
).Values from0
to2147483647
are safe in all databases supported byDjango. The value0
is accepted for backward compatibility reasons.
PositiveSmallIntegerField
- class
PositiveSmallIntegerField
(**options) - Like a
PositiveIntegerField
, but only allows values under a certain(database-dependent) point. Values from0
to32767
are safe in alldatabases supported by Django.
SlugField
- class
SlugField
(max_length=50, **options) - Slug is a newspaper term. A slug is a short label for something,containing only letters, numbers, underscores or hyphens. They’re generally usedin URLs.
Like a CharField, you can specify max_length
(read the noteabout database portability and max_length
in that section,too). If max_length
is not specified, Django will use adefault length of 50.
Implies setting Field.db_index
to True
.
It is often useful to automatically prepopulate a SlugField based on the valueof some other value. You can do this automatically in the admin usingprepopulated_fields
.
It uses validate_slug
orvalidate_unicode_slug
for validation.
SlugField.
allow_unicode
- If
True
, the field accepts Unicode letters in addition to ASCIIletters. Defaults toFalse
.
SmallAutoField
Like an AutoField
, but only allows values under a certain(database-dependent) limit. Values from 1
to 32767
are safe in alldatabases supported by Django.
SmallIntegerField
- class
SmallIntegerField
(**options) - Like an
IntegerField
, but only allows values under a certain(database-dependent) point. Values from-32768
to32767
are safe in alldatabases supported by Django.
TextField
- class
TextField
(**options) - A large text field. The default form widget for this field is a
Textarea
.
If you specify a max_length
attribute, it will be reflected in theTextarea
widget of the auto-generated form field.However it is not enforced at the model or database level. Use aCharField
for that.
TimeField
- class
TimeField
(auto_now=False, auto_now_add=False, **options) - A time, represented in Python by a
datetime.time
instance. Accepts the sameauto-population options asDateField
.
The default form widget for this field is a TextInput
.The admin adds some JavaScript shortcuts.
URLField
- class
URLField
(max_length=200, **options) - A
CharField
for a URL, validated byURLValidator
.
The default form widget for this field is a TextInput
.
Like all CharField
subclasses, URLField
takes the optionalmax_length
argument. If you don’t specifymax_length
, a default of 200 is used.
UUIDField
- class
UUIDField
(**options) - A field for storing universally unique identifiers. Uses Python’s
UUID
class. When used on PostgreSQL, this stores in auuid
datatype, otherwise in achar(32)
.
Universally unique identifiers are a good alternative to AutoField
forprimary_key
. The database will not generate the UUID for you, soit is recommended to use default
:
- import uuid
- from django.db import models
- class MyUUIDModel(models.Model):
- id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
- # other fields
Note that a callable (with the parentheses omitted) is passed to default
,not an instance of UUID
.
Relationship fields
Django also defines a set of fields that represent relations.
ForeignKey
- class
ForeignKey
(to, on_delete, **options) - A many-to-one relationship. Requires two positional arguments: the class towhich the model is related and the
on_delete
option.
To create a recursive relationship – an object that has a many-to-onerelationship with itself – use models.ForeignKey('self',on_delete=models.CASCADE)
.
If you need to create a relationship on a model that has not yet been defined,you can use the name of the model, rather than the model object itself:
- from django.db import models
- class Car(models.Model):
- manufacturer = models.ForeignKey(
- 'Manufacturer',
- on_delete=models.CASCADE,
- )
- # ...
- class Manufacturer(models.Model):
- # ...
- pass
Relationships defined this way on abstract models are resolved when the model is subclassed as aconcrete model and are not relative to the abstract model’s app_label
:
- from django.db import models
- class AbstractCar(models.Model):
- manufacturer = models.ForeignKey('Manufacturer', on_delete=models.CASCADE)
- class Meta:
- abstract = True
- from django.db import models
- from products.models import AbstractCar
- class Manufacturer(models.Model):
- pass
- class Car(AbstractCar):
- pass
- # Car.manufacturer will point to `production.Manufacturer` here.
To refer to models defined in another application, you can explicitly specifya model with the full application label. For example, if the Manufacturer
model above is defined in another application called production
, you’dneed to use:
- class Car(models.Model):
- manufacturer = models.ForeignKey(
- 'production.Manufacturer',
- on_delete=models.CASCADE,
- )
This sort of reference, called a lazy relationship, can be useful whenresolving circular import dependencies between two applications.
A database index is automatically created on the ForeignKey
. You candisable this by setting db_index
to False
. You may want toavoid the overhead of an index if you are creating a foreign key forconsistency rather than joins, or if you will be creating an alternative indexlike a partial or multiple column index.
Database Representation
Behind the scenes, Django appends "_id"
to the field name to create itsdatabase column name. In the above example, the database table for the Car
model will have a manufacturer_id
column. (You can change this explicitly byspecifying db_column
) However, your code should never have todeal with the database column name, unless you write custom SQL. You’ll alwaysdeal with the field names of your model object.
Arguments
ForeignKey
accepts other arguments that define the details of how therelation works.
ForeignKey.
on_delete
- When an object referenced by a
ForeignKey
is deleted, Django willemulate the behavior of the SQL constraint specified by theon_delete
argument. For example, if you have a nullableForeignKey
and you want it to be set null when the referencedobject is deleted:
- user = models.ForeignKey(
- User,
- models.SET_NULL,
- blank=True,
- null=True,
- )
on_delete
doesn’t create a SQL constraint in the database. Support fordatabase-level cascade options may be implemented later.
The possible values for on_delete
are found indjango.db.models
:
Model.delete()
isn’t called on related models, but thepre_delete
andpost_delete
signals are sent for alldeleted objects.
PROTECT
- Prevent deletion of the referenced object by raising
ProtectedError
, a subclass ofdjango.db.IntegrityError
.
SET_NULL
- Set the
ForeignKey
null; this is only possible ifnull
isTrue
.
SET_DEFAULT
- Set the
ForeignKey
to its default value; a default for theForeignKey
must be set.
SET
()- Set the
ForeignKey
to the value passed toSET()
, or if a callable is passed in,the result of calling it. In most cases, passing a callable will benecessary to avoid executing queries at the time your models.py isimported:
- from django.conf import settings
- from django.contrib.auth import get_user_model
- from django.db import models
- def get_sentinel_user():
- return get_user_model().objects.get_or_create(username='deleted')[0]
- class MyModel(models.Model):
- user = models.ForeignKey(
- settings.AUTH_USER_MODEL,
- on_delete=models.SET(get_sentinel_user),
- )
DO_NOTHING
- Take no action. If your database backend enforces referentialintegrity, this will cause an
IntegrityError
unlessyou manually add an SQLON DELETE
constraint to the database field.
- Sets a limit to the available choices for this field when this field isrendered using a
ModelForm
or the admin (by default, all objectsin the queryset are available to choose). Either a dictionary, aQ
object, or a callable returning adictionary orQ
object can be used.
For example:
- staff_member = models.ForeignKey(
- User,
- on_delete=models.CASCADE,
- limit_choices_to={'is_staff': True},
- )
causes the corresponding field on the ModelForm
to list only Users
that have is_staff=True
. This may be helpful in the Django admin.
The callable form can be helpful, for instance, when used in conjunctionwith the Python datetime
module to limit selections by date range. Forexample:
- def limit_pub_date_choices():
- return {'pub_date__lte': datetime.date.utcnow()}
- limit_choices_to = limit_pub_date_choices
If limit_choices_to
is or returns a Q object
, which is useful for complex queries, then it will only have an effect on the choicesavailable in the admin when the field is not listed inraw_id_fields
in theModelAdmin
for the model.
Note
If a callable is used for limit_choices_to
, it will be invokedevery time a new form is instantiated. It may also be invoked when amodel is validated, for example by management commands or the admin.The admin constructs querysets to validate its form inputs in variousedge cases multiple times, so there is a possibility your callable maybe invoked several times.
ForeignKey.
related_name
- The name to use for the relation from the related object back to this one.It’s also the default value for
related_query_name
(the name to usefor the reverse filter name from the target model). See the relatedobjects documentation for a full explanationand example. Note that you must set this value when defining relations onabstract models; and when you do sosome special syntax is available.
If you’d prefer Django not to create a backwards relation, setrelated_name
to '+'
or end it with '+'
. For example, this willensure that the User
model won’t have a backwards relation to thismodel:
- user = models.ForeignKey(
- User,
- on_delete=models.CASCADE,
- related_name='+',
- )
ForeignKey.
related_query_name
- The name to use for the reverse filter name from the target model. Itdefaults to the value of
related_name
ordefault_related_name
if set, otherwise itdefaults to the name of the model:
- # Declare the ForeignKey with related_query_name
- class Tag(models.Model):
- article = models.ForeignKey(
- Article,
- on_delete=models.CASCADE,
- related_name="tags",
- related_query_name="tag",
- )
- name = models.CharField(max_length=255)
- # That's now the name of the reverse filter
- Article.objects.filter(tag__name="important")
Like related_name
, related_query_name
supports app label andclass interpolation via some special syntax.
ForeignKey.
to_field
The field on the related object that the relation is to. By default, Djangouses the primary key of the related object. If you reference a differentfield, that field must have
unique=True
.Controls whether or not a constraint should be created in the database forthis foreign key. The default is
True
, and that’s almost certainly whatyou want; setting this toFalse
can be very bad for data integrity.That said, here are some scenarios where you might want to do this:- You have legacy data that is not valid.
- You’re sharding your database.If this is set to
False
, accessing a related object that doesn’t existwill raise itsDoesNotExist
exception.
- Controls the migration framework’s reaction if this
ForeignKey
is pointing at a swappable model. If it isTrue
- the default -then if theForeignKey
is pointing at a model which matchesthe current value ofsettings.AUTH_USER_MODEL
(or another swappablemodel setting) the relationship will be stored in the migration usinga reference to the setting, not to the model directly.
You only want to override this to be False
if you are sure yourmodel should always point towards the swapped-in model - for example,if it is a profile model designed specifically for your custom user model.
Setting it to False
does not mean you can reference a swappable modeleven if it is swapped out - False
means that the migrations madewith this ForeignKey will always reference the exact model you specify(so it will fail hard if the user tries to run with a User model you don’tsupport, for example).
If in doubt, leave it to its default of True
.
ManyToManyField
- class
ManyToManyField
(to, **options) - A many-to-many relationship. Requires a positional argument: the class towhich the model is related, which works exactly the same as it does for
ForeignKey
, including recursive andlazy relationships.
Related objects can be added, removed, or created with the field’sRelatedManager
.
Database Representation
Behind the scenes, Django creates an intermediary join table to represent themany-to-many relationship. By default, this table name is generated using thename of the many-to-many field and the name of the table for the model thatcontains it. Since some databases don’t support table names above a certainlength, these table names will be automatically truncated and a uniqueness hashwill be used, e.g. author_books_9cdf
. You can manually provide the name ofthe join table using the db_table
option.
Arguments
ManyToManyField
accepts an extra set of arguments – all optional –that control how the relationship functions.
ManyToManyField.
related_name
Same as
ForeignKey.related_name
.Same as
ForeignKey.related_query_name
.- Same as
ForeignKey.limit_choices_to
.
limit_choices_to
has no effect when used on a ManyToManyField
with acustom intermediate table specified using thethrough
parameter.
ManyToManyField.
symmetrical
- Only used in the definition of ManyToManyFields on self. Consider thefollowing model:
- from django.db import models
- class Person(models.Model):
- friends = models.ManyToManyField("self")
When Django processes this model, it identifies that it has aManyToManyField
on itself, and as a result, it doesn’t add aperson_set
attribute to the Person
class. Instead, theManyToManyField
is assumed to be symmetrical – that is, if I amyour friend, then you are my friend.
If you do not want symmetry in many-to-many relationships with self
, setsymmetrical
to False
. This will force Django toadd the descriptor for the reverse relationship, allowingManyToManyField
relationships to be non-symmetrical.
Changed in Django 3.0:Specifying symmetrical=True
for recursive many-to-manyrelationships using an intermediary model was allowed.
ManyToManyField.
through
- Django will automatically generate a table to manage many-to-manyrelationships. However, if you want to manually specify the intermediarytable, you can use the
through
option to specifythe Django model that represents the intermediate table that you want touse.
The most common use for this option is when you want to associateextra data with a many-to-many relationship.
Note
Recursive relationships using an intermediary model and defined assymmetrical (that is, with symmetrical=True
, which is the default) can’t determinethe reverse accessors names, as they would be the same. You need to seta related_name
to at least one of them. If you’dprefer Django not to create a backwards relation, set related_name
to '+'
.
If you don’t specify an explicit through
model, there is still animplicit through
model class you can use to directly access the tablecreated to hold the association. It has three fields to link the models.
If the source and target models differ, the following fields aregenerated:
id
: the primary key of the relation.<containing_model>_id
: theid
of the model that declares theManyToManyField
.<other_model>_id
: theid
of the model that theManyToManyField
points to.If theManyToManyField
points from and to the same model, the followingfields are generated:id
: the primary key of the relation.from_<model>_id
: theid
of the instance which points at themodel (i.e. the source instance).to_<model>_id
: theid
of the instance to which the relationshippoints (i.e. the target model instance).This class can be used to query associated records for a given modelinstance like a normal model.
ManyToManyField.
through_fields
- Only used when a custom intermediary model is specified. Django willnormally determine which fields of the intermediary model to use in orderto establish a many-to-many relationship automatically. However,consider the following models:
- from django.db import models
- class Person(models.Model):
- name = models.CharField(max_length=50)
- class Group(models.Model):
- name = models.CharField(max_length=128)
- members = models.ManyToManyField(
- Person,
- through='Membership',
- through_fields=('group', 'person'),
- )
- class Membership(models.Model):
- group = models.ForeignKey(Group, on_delete=models.CASCADE)
- person = models.ForeignKey(Person, on_delete=models.CASCADE)
- inviter = models.ForeignKey(
- Person,
- on_delete=models.CASCADE,
- related_name="membership_invites",
- )
- invite_reason = models.CharField(max_length=64)
Membership
has two foreign keys to Person
(person
andinviter
), which makes the relationship ambiguous and Django can’t knowwhich one to use. In this case, you must explicitly specify whichforeign keys Django should use using through_fields
, as in the exampleabove.
through_fields
accepts a 2-tuple ('field1', 'field2')
, wherefield1
is the name of the foreign key to the model theManyToManyField
is defined on (group
in this case), andfield2
the name of the foreign key to the target model (person
in this case).
When you have more than one foreign key on an intermediary model to any(or even both) of the models participating in a many-to-many relationship,you must specify through_fields
. This also applies torecursive relationshipswhen an intermediary model is used and there are more than twoforeign keys to the model, or you want to explicitly specify which twoDjango should use.
ManyToManyField.
db_table
The name of the table to create for storing the many-to-many data. If thisis not provided, Django will assume a default name based upon the names of:the table for the model defining the relationship and the name of the fielditself.
Controls whether or not constraints should be created in the database forthe foreign keys in the intermediary table. The default is
True
, andthat’s almost certainly what you want; setting this toFalse
can bevery bad for data integrity. That said, here are some scenarios where youmight want to do this:- You have legacy data that is not valid.
- You’re sharding your database.It is an error to pass both
db_constraint
andthrough
.
- Controls the migration framework’s reaction if this
ManyToManyField
is pointing at a swappable model. If it isTrue
- the default -then if theManyToManyField
is pointing at a model which matchesthe current value ofsettings.AUTH_USER_MODEL
(or another swappablemodel setting) the relationship will be stored in the migration usinga reference to the setting, not to the model directly.
You only want to override this to be False
if you are sure yourmodel should always point towards the swapped-in model - for example,if it is a profile model designed specifically for your custom user model.
If in doubt, leave it to its default of True
.
ManyToManyField
does not support validators
.
null
has no effect since there is no way to require arelationship at the database level.
OneToOneField
- class
OneToOneField
(to, on_delete, parent_link=False, **options) - A one-to-one relationship. Conceptually, this is similar to a
ForeignKey
withunique=True
, but the“reverse” side of the relation will directly return a single object.
This is most useful as the primary key of a model which “extends”another model in some way; Multi-table inheritance isimplemented by adding an implicit one-to-one relation from the childmodel to the parent model, for example.
One positional argument is required: the class to which the model will berelated. This works exactly the same as it does for ForeignKey
,including all the options regarding recursiveand lazy relationships.
If you do not specify the related_name
argument for theOneToOneField
, Django will use the lowercase name of the current model asdefault value.
With the following example:
- from django.conf import settings
- from django.db import models
- class MySpecialUser(models.Model):
- user = models.OneToOneField(
- settings.AUTH_USER_MODEL,
- on_delete=models.CASCADE,
- )
- supervisor = models.OneToOneField(
- settings.AUTH_USER_MODEL,
- on_delete=models.CASCADE,
- related_name='supervisor_of',
- )
your resulting User
model will have the following attributes:
- >>> user = User.objects.get(pk=1)
- >>> hasattr(user, 'myspecialuser')
- True
- >>> hasattr(user, 'supervisor_of')
- True
A DoesNotExist
exception is raised when accessing the reverse relationshipif an entry in the related table doesn’t exist. For example, if a user doesn’thave a supervisor designated by MySpecialUser
:
- >>> user.supervisor_of
- Traceback (most recent call last):
- ...
- DoesNotExist: User matching query does not exist.
Additionally, OneToOneField
accepts all of the extra argumentsaccepted by ForeignKey
, plus one extra argument:
OneToOneField.
parent_link
- When
True
and used in a model which inherits from anotherconcrete model, indicates that this field should be used as thelink back to the parent class, rather than the extraOneToOneField
which would normally be implicitly created bysubclassing.
See One-to-one relationships for usageexamples of OneToOneField
.
Field API reference
- class
Field
Field
is an abstract class that represents a database table column.Django uses fields to create the database table (db_type()
), to mapPython types to database (get_prep_value()
) and vice-versa(from_db_value()
).
A field is thus a fundamental piece in different Django APIs, notably,models
and querysets
.
In models, a field is instantiated as a class attribute and represents aparticular table column, see Models. It has attributessuch as null
and unique
, and methods that Django uses tomap the field value to database-specific values.
A Field
is a subclass ofRegisterLookupMixin
and thus bothTransform
andLookup
can be registered on it to be usedin QuerySet
s (e.g. field_name__exact="foo"
). All built-inlookups are registered by default.
All of Django’s built-in fields, such as CharField
, are particularimplementations of Field
. If you need a custom field, you can eithersubclass any of the built-in fields or write a Field
from scratch. Ineither case, see Writing custom model fields.
description
- A verbose description of the field, e.g. for the
django.contrib.admindocs
application.
The description can be of the form:
- description = _("String (up to %(max_length)s)")
where the arguments are interpolated from the field’s dict
.
A class implementing the descriptor protocolthat is instantiated and assigned to the model instance attribute. Theconstructor must accept a single argument, the Field
instance.Overriding this class attribute allows for customizing the get and setbehavior.
To map a Field
to a database-specific type, Django exposes severalmethods:
get_internal_type
()- Returns a string naming this field for backend specific purposes.By default, it returns the class name.
See Emulating built-in field types for usage in custom fields.
dbtype
(_connection)- Returns the database column data type for the
Field
, takinginto account theconnection
.
See Custom database types for usage in custom fields.
reldb_type
(_connection)- Returns the database column data type for fields such as
ForeignKey
andOneToOneField
that point to theField
, takinginto account theconnection
.
See Custom database types for usage in custom fields.
There are three main situations where Django needs to interact with thedatabase backend and fields:
- when it queries the database (Python value -> database backend value)
- when it loads data from the database (database backend value -> Pythonvalue)
when it saves to the database (Python value -> database backend value)When querying,
get_db_prep_value()
andget_prep_value()
are used:value
is the current value of the model’s attribute, and the methodshould return data in a format that has been prepared for use as aparameter in a query.
See Converting Python objects to query values for usage.
getdb_prep_value
(_value, connection, prepared=False)- Converts
value
to a backend-specific value. By default it returnsvalue
ifprepared=True
andget_prep_value()
if isFalse
.
See Converting query values to database values for usage.
When loading data, from_db_value()
is used:
fromdb_value
(_value, expression, connection)- Converts a value as returned by the database to a Python object. It isthe reverse of
get_prep_value()
.
This method is not used for most built-in fields as the databasebackend already returns the correct Python type, or the backend itselfdoes the conversion.
See Converting values to Python objects for usage.
Note
For performance reasons, from_db_value
is not implemented as ano-op on fields which do not require it (all Django fields).Consequently you may not call super
in your definition.
When saving, pre_save()
and get_db_prep_save()
are used:
getdb_prep_save
(_value, connection)Same as the
get_db_prep_value()
, but called when the field valuemust be saved to the database. By default returnsget_db_prep_value()
.- Method called prior to
get_db_prep_save()
to prepare the valuebefore being saved (e.g. forDateField.auto_now
).
model_instance
is the instance this field belongs to and add
is whether the instance is being saved to the database for the firsttime.
It should return the value of the appropriate attribute frommodel_instance
for this field. The attribute name is inself.attname
(this is set up by Field
).
See Preprocessing values before saving for usage.
Fields often receive their values as a different type, either fromserialization or from forms.
topython
(_value)- Converts the value into the correct Python object. It acts as thereverse of
value_to_string()
, and is also called inclean()
.
See Converting values to Python objects for usage.
Besides saving to the database, the field also needs to know how toserialize its value:
This method is often used by value_to_string()
.
See Converting field data for serialization for usage.
When using model forms
, the Field
needs to know which form field it should be represented by:
formfield
(form_class=None, choices_form_class=None, **kwargs)- Returns the default
django.forms.Field
of this field forModelForm
.
By default, if both form_class
and choices_form_class
areNone
, it uses CharField
. If the field haschoices
and choices_form_class
isn’t specified, it uses TypedChoiceField
.
See Specifying the form field for a model field for usage.
deconstruct
()Returns a 4-tuple with enough information to recreate the field:
- The name of the field on the model.
- The import path of the field (e.g.
"django.db.models.IntegerField"
).This should be the most portable version, so less specific may be better. - A list of positional arguments.
- A dict of keyword arguments.This method must be added to fields prior to 1.7 to migrate its datausing Migrations.
Field attribute reference
Every Field
instance contains several attributes that allowintrospecting its behavior. Use these attributes instead of isinstance
checks when you need to write code that depends on a field’s functionality.These attributes can be used together with the Model._meta API to narrow down a search for specific field types.Custom model fields should implement these flags.
Attributes for fields
Field.
auto_created
Boolean flag that indicates if the field was automatically created, suchas the
OneToOneField
used by model inheritance.Boolean flag that indicates if the field has a database column associatedwith it.
- Boolean flag that indicates if a field is used to back another non-hiddenfield’s functionality (e.g. the
content_type
andobject_id
fieldsthat make up aGenericForeignKey
). Thehidden
flag is used todistinguish what constitutes the public subset of fields on the model fromall the fields on the model.
Note
Options.get_fields()
excludes hidden fields by default. Pass in include_hidden=True
toreturn hidden fields in the results.
Field.
is_relation
Boolean flag that indicates if a field contains references to one ormore other models for its functionality (e.g.
ForeignKey
,ManyToManyField
,OneToOneField
, etc.).- Returns the model on which the field is defined. If a field is defined ona superclass of a model,
model
will refer to the superclass, not theclass of the instance.
Attributes for fields with relations
These attributes are used to query for the cardinality and other details of arelation. These attribute are present on all fields; however, they will onlyhave boolean values (rather than None
) if the field is a relation type(Field.is_relation=True
).
Field.
many_to_many
Boolean flag that is
True
if the field has a many-to-many relation;False
otherwise. The only field included with Django where this isTrue
isManyToManyField
.Boolean flag that is
True
if the field has a many-to-one relation, suchas aForeignKey
;False
otherwise.Boolean flag that is
True
if the field has a one-to-many relation, suchas aGenericRelation
or the reverse of aForeignKey
;False
otherwise.Boolean flag that is
True
if the field has a one-to-one relation, suchas aOneToOneField
;False
otherwise.- Points to the model the field relates to. For example,
Author
inForeignKey(Author, on_delete=models.CASCADE)
. Therelated_model
foraGenericForeignKey
is alwaysNone
.