Django CRUD (Create Read Update Delete) Example
To create a Django application that performs CRUD operations, follow the following steps.
1. Create a Project
2. Create an App
3. Project Structure
Initially, our project looks like this:
4. Database Setup
Create a database djangodb in mysql, and configure into the settings.py file of django project. See the example.
// settings.py
5. Create a Model
Put the following code into models.py file.
// models.py
6. Create a ModelForm
// forms.py
7. Create View Functions
// views.py
8. Provide Routing
Provide URL patterns to map with views function.
// urls.py
9. Organize Templates
Create a templates folder inside the employee app and create three (index, edit, show) html files inside the directory. The code for each is given below.
// index.html
// show.html
// edit.html
10. Static Files Handling
Create a folder static/css inside the employee app and put a css inside it. Download the css file here Click Here.
11. Project Structure
12. Create Migrations
Create migrations for the created model employee, use the following command.
After migrations, execute one more command to reflect the migration into the database. But before it, mention name of app (employee) in INSTALLED_APPS of settings.py file.
// settings.py
Run the command to migrate the migrations.
Now, our application has successfully connected and created tables in database. It creates 10 default tables for handling project (session, authentication etc) and one table of our model that we created.
See list of tables created after migrate command.
Run Server
To run server use the following command.
Access to the Browser
Access the application by entering localhost:8000/show, it will show all the available employee records.
Initially, there is no record. So, it shows no record message.
Adding Record
Click on the Add New Record button and fill the details. See the example.
Filling the details.
Submit the record and see, after submitting it shows the saved record.
This section also allows, update and delete records from the actions column.
After saving couple of records, now we have following records.
Update Record
Lets update the record of Mohan by clicking on edit button. It will display record of Mohan in edit mode.
Lets, suppose I update mohan to mohan kumar then click on the update button. It updates the record immediately. See the example.
Click on update button and it redirects to the following page. See name is updated.
Same like, we can delete records too, by clicking the delete link.
Delete Record
Suppose, I want to delete Sohan, it can be done easily by clicking the delete button. See the example.
After deleting, we left with the following records.
Well, we have successfully created a CRUD application using Django.