Theoretical Paper
- Computer Organization
- Data Structure
- Digital Electronics
- Object Oriented Programming
- Discrete Mathematics
- Graph Theory
- Operating Systems
- Software Engineering
- Computer Graphics
- Database Management System
- Operation Research
- Computer Networking
- Image Processing
- Internet Technologies
- Micro Processor
- E-Commerce & ERP
Practical Paper
Industrial Training
Django Models
A Django model is the built-in feature that Django uses to create tables, their fields, and various constraints. In short, Django Models is the SQL of Database one uses with Django. SQL (Structured Query Language) is complex and involves a lot of different queries for creating, deleting, updating or any other stuff related to database. Django models simplify the tasks and organize tables into models. Generally, each model maps to a single database table. This article revolves about how one can use Django models to store data in the database conveniently. Moreover, we can use admin panel of Django to create, update, delete or retrieve fields of a model and various similar operations. Django models provide simplicity, consistency, version control and advanced metadata handling. Basics of a model include –
- Each model is a Python class that subclasses django.db.models.Model.
- Each attribute of the model represents a database field.
- With all of this, Django gives you an automatically-generated database-access API; see Making queries.
from django.db import models # Create your models here. class McatutorialsModel(models.Model): title = models.CharField(max_length = 200) description = models.TextField()
Django maps the fields defined in Django models into table fields of the database as shown below.
To use Django Models, one needs to have a project and an app working in it. After you start an app you can create models in app/models.py. Before starting to use a model let’s check how to start a project and create an app named mcatutorials.py
Refer to the following articles to check how to create a project and an app in Django.
Creating a Model Syntax
from django.db import models class ModelName(models.Model): field_name = models.Field(**options)
To create a model, in mcatutorials/models.py Enter the code,
# import the standard Django Model # from built-in library from django.db import models # declare a new model with a name "McatutorialsModel" class McatutorialsModel(models.Model): # fields of the model title = models.CharField(max_length = 200) description = models.TextField() last_modified = models.DateTimeField(auto_now_add = True) img = models.ImageField(upload_to = "images/") # renames the instances of the model # with their title name def __str__(self): return self.title
Whenever we create a Model, Delete a Model, or update anything in any of models.py of our project. We need to run two commands makemigrations and migrate. makemigrations basically generates the SQL commands for preinstalled apps (which can be viewed in installed apps in settings.py) and your newly created app’s model which you add in installed apps whereas migrate executes those SQL commands in the database file. So when we run,
Python manage.py makemigrations
SQL Query to create above Model as a Table is created and
Python manage.py migrate
creates the table in the database.
Now we have created a model we can perform various operations such as creating a Row for the table or in terms of Django Creating an instance of Model. To know more visit – Django Basic App Model – Makemigrations and Migrate
Render a model in Django Admin InterfaceTo render a model in Django admin, we need to modify app/admin.py. Go to admin.py in mcatutorials app and enter the following code. Import the corresponding model from models.py and register it to the admin interface.
from django.contrib import admin # Register your models here. from .models import McatutorialsModel admin.site.register(McatutorialsModel)
Now we can check whether the model has been rendered in Django Admin. Django Admin Interface can be used to graphically implement CRUD (Create, Retrieve, Update, Delete).
To check more on rendering models in django admin, visit – Render Model in Django Admin Interface
Django CRUD – Inserting, Updating and Deleting DataDjango lets us interact with its database models, i.e. add, delete, modify and query objects, using a database-abstraction API called ORM(Object Relational Mapper). We can access the Django ORM by running the following command inside our project directory.
python manage.py shellAdding objects.
To create an object of model Album and save it into the database, we need to write the following command:
>>> a = McatutorialsModel( title = “McatutorialsForMcatutorials”, description = “A description here”, img = “Mcatutorials/abc.png” ) >>> a.save()Retrieving objects
To retrieve all the objects of a model, we write the following command:
>>> McatutorialsModel.objects.all() < QuerySet [< McatutorialsModel: Divide>, < McatutorialsModel: Abbey Road>, < McatutorialsModel: Revolver>]>Modifying existing objects
We can modify an existing object as follows:
>>> a = McatutorialsModel.objects.get(id = 3) >>> a.title = "Pop" >>> a.save()Deleting objects
To delete a single object, we need to write the following commands:
>>> a = Album.objects.get(id = 2) >>> a.delete()
To check detailed post of Django’s ORM (Object) visit Django ORM – Inserting, Updating & Deleting Data
Validation on Fields in a ModelBuilt-in Field Validations in Django models are the default validations that come predefined to all Django fields. Every field comes in with built-in validations from Django validators. For example, IntegerField comes with built-in validation that it can only store integer values and that too in a particular range.
Enter the following code into models.py file of mcatutorials app.
from django.db import models from django.db.models import Model # Create your models here. class McatutorialsModel(Model): mcatutorials_field = models.IntegerField() def __str__(self): return self.mcatutorials_field
After running makemigrations and migrate on Django and rendering above model, let us try to create an instance using string “GfG is Best“.
You can see in the admin interface, one can not enter a string in an IntegerField. Similarly every field has its own validations. To know more about validations visit, Built-in Field Validations – Django Models
More on Django Models –- Change Object Display Name using __str__ function – Django Models
- Custom Field Validations in Django Models
- Django python manage.py migrate command
- Django App Model – Python manage.py makemigrations command
- Django model data types and fields list
- How to use Django Field Choices ?
- Overriding the save method – Django Models
The most important part of a model and the only required part of a model is the list of database fields it defines. Fields are specified by class attributes. Here is a list of all Field types used in Django.
FIELD NAME | DESCRIPTION |
AutoField | It An IntegerField that automatically increments. |
BigAutoField | It is a 64-bit integer, much like an AutoField except that it is guaranteed to fit numbers from 1 to 9223372036854775807. |
BigIntegerField | It is a 64-bit integer, much like an IntegerField except that it is guaranteed to fit numbers from -9223372036854775808 to 9223372036854775807. |
BinaryField | A field to store raw binary data. |
BooleanField | A true/false field. |
CharField | It is a date, represented in Python by a datetime.date instance. |
DateField | A date, represented in Python by a datetime.date instance |
It is used for date and time, represented in Python by a datetime.datetime instance. |
|
DecimalField | It is a fixed-precision decimal number, represented in Python by a Decimal instance. |
DurationField | A field for storing periods of time. |
EmailField | It is a CharField that checks that the value is a valid email address. |
FileField | It is a file-upload field. |
FloatField | It is a floating-point number represented in Python by a float instance. |
ImageField | It inherits all attributes and methods from FileField, but also validates that the uploaded object is a valid image. |
IntegerField | It is an integer field. Values from -2147483648 to 2147483647 are safe in all databases supported by Django. |
GenericIPAddressField | An IPv4 or IPv6 address, in string format (e.g. 192.0.2.30 or 2a02:42fe::4). |
NullBooleanField | Like a BooleanField, but allows NULL as one of the options. |
PositiveIntegerField | Like an IntegerField, but must be either positive or zero (0). |
PositiveSmallIntegerField | Like a PositiveIntegerField, but only allows values under a certain (database-dependent) point. |
SlugField | Slug is a newspaper term. A slug is a short label for something, containing only letters, numbers, underscores or hyphens. They’re generally used in URLs. |
SmallIntegerField | It is like an IntegerField, but only allows values under a certain (database-dependent) point. |
TextField | A large text field. The default form widget for this field is a Textarea. |
TimeField | A time, represented in Python by a datetime.time instance. |
URLField | A CharField for a URL, validated by URLValidator. |
UUIDField | A field for storing universally unique identifiers. Uses Python’s UUID class. When used on PostgreSQL, this stores in a uuid datatype, otherwise in a char(32). |
Django also defines a set of fields that represent relations.
FIELD NAME | DESCRIPTION |
ForeignKey | A many-to-one relationship. Requires two positional arguments: the class to which the model is related and the on_delete option. |
ManyToManyField | A many-to-many relationship. Requires a positional argument: the class to which the model is related, which works exactly the same as it does for ForeignKey, including recursive and lazy relationships. |
OneToOneField | A one-to-one relationship. Conceptually, this is similar to a ForeignKey with unique=True, but the “reverse” side of the relation will directly return a single object. |
Field Options are the arguments given to each field for applying some constraint or imparting a particular characteristic to a particular Field. For example, adding an argument null = True to CharField will enable it to store empty values for that table in relational database. Here are the field options and attributes that an CharField can use.
FIELD OPTIONS | DESCRIPTION |
Null | If True, Django will store empty values as NULL in the database. Default is False. |
Blank | If True, the field is allowed to be blank. Default is False. |
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. |
Default | The default value for the field. This can be a value or a callable object. If callable it will be called every time a new object is created. |
help_text | Extra “help” text to be displayed with the form widget. It’s useful for documentation even if your field isn’t used on a form. |
primary_key | If True, this field is the primary key for the model. |
editable | If False, the field will not be displayed in the admin or any other ModelForm. They are also skipped during model validation. Default is True. |
error_messages | The error_messages argument lets you override the default messages that the field will raise. Pass in a dictionary with keys matching the error messages you want to override. |
help_text | Extra “help” text to be displayed with the form widget. It’s useful for documentation even if your field isn’t used on a form. |
verbose_name | A human-readable name for the field. If the verbose name isn’t given, Django will automatically create it using the field’s attribute name, converting underscores to spaces. |
validators | A list of validators to run for this field. See the validators documentation for more information. |
Unique | If True, this field must be unique throughout the table. |