My Blog

Insert Data

Written by

saqibkhan

in

Django has its own Object Relation Model (ORM) that maps a Python class with a table in a relational database. The ORM mechanism helps in performing CRUD operations in object-oriented manner. In this chapter, we shall learn about different methods of inserting a new data.

By default, Django uses a SQLite database. A model in Django is a class inherited from the “django.db.models” class.

Let us use the following Dreamreal model in “models.py” file for learning how to insert data in the mapped table −

from django.db import models

classDreamreal(models.Model):
   website = models.CharField(max_length=50)
   mail = models.CharField(max_length=50)
   name = models.CharField(max_length=50)
   phonenumber = models.IntegerField()classMeta:

  db_table ="dreamreal"</code></pre>




After declaring a model, we need to perform the migrations −





python manage.py makemigrations
python manage.py migrate






Insert Object From Shell





Django has a useful feature with which you can invoke a Python shell inside the Django project’s environment. Use the shell command with the manage.py script −





python manage.py shell






In front of the Python prompt, import the Dreamreal model −





>>>from myapp.models import Dreamreal






We can construct an object of this class and call its save() method so that the corresponding row is added in the table





>>> obj = Dreamreal(website="www.polo.com", mail="[email protected]", name="sorex", phonenumber="002376970")>>> obj.save()





We can confirm this by opening the database in any SQLite viewer.





You can also use the create() method of the objects attribute of the model class to insert the record.





>>> obj = Dreamreal.objects.create(website="www.polo.com", 
mail="[email protected]", name="sorex", phonenumber="002376970")





Perform Insert Operation by Calling a View Function





Let us now perform the insert operation by calling a View function. Define addnew() function in views.py file as follows −





from myapp.models import Dreamreal

defaddnew(request):
   obj = Dreamreal(website="www.polo.com", mail="[email protected]", name="sorex", phonenumber="002376970")
   obj.save()return HttpResponse("<h2>Record Added Successfully")





We need to register this View with the URLpatterns list.





from django.urls import path
from.import views

urlpatterns =[
   path("", views.index, name="index"),
   path("addnew/", views.addnew, name='addnew')]





Instead of using the hard-coded values as in the above example, we would like the data to be accepted from the user. For this purpose, create an HTML form in myform.html file.





<html><body><form action="../addnew/" method="post">

  {% csrf_token %}
  &lt;p&gt;&lt;label for="website"&gt;WebSite: &lt;/label&gt;&lt;input id="website" type="text" name="website"&gt;&lt;/p&gt;&lt;p&gt;&lt;label for="mail"&gt;Email: &lt;/label&gt;&lt;input id="mail" type="text" name="mail"&gt;&lt;/p&gt;&lt;p&gt;&lt;label for="name"&gt;Name: &lt;/label&gt;&lt;input id="name" type="text" name="name"&gt;&lt;/p&gt;&lt;p&gt;&lt;label for="phonenumber"&gt;Phone Number: &lt;/label&gt;&lt;input id="phonenumber" type="text" name="phonenumber"&gt;&lt;/p&gt;&lt;input type="submit" value="OK"&gt;&lt;/form&gt;&lt;/body&gt;&lt;/html&gt;</code></pre>




The HTML template file must be stored in a directory defined in the TEMPLATES setting −





TEMPLATES =[{'BACKEND':'django.template.backends.django.DjangoTemplates','DIRS':[BASE_DIR/'templates'],....,]





Let us use the render() function to display the form template −





from django.shortcuts import render
from myapp.models import Dreamreal

defaddnew(request):if request.method =="POST":

  ws = request.POST&#91;'website']
  mail = request.POST&#91;'mail']
  nm = request.POST&#91;'name']
  ph = request.POST&#91;'phonenumber']
  obj = Dreamreal(website=ws, mail=mail, name=nm, phonenumber=ph)
  obj.save()return HttpResponse("&lt;h2&gt;Record Added Successfully&lt;/h2&gt;")return render(request,"myform.html")</code></pre>




Note that the form’s action attribute is also set to the same URL mapping the addnew() function. Hence, we need to check the request.method. If it’s GET method, the blank form is rendered. If it’s POST method, the form data is parsed and used for inserting a new record.





Django Insert Data 1





The Model Form





Django has a ModelForm class that automatically renders a HTML form with its structure matching with the attributes of a model class.





We define a DreamRealForm class in forms.py file under the app folder that uses the Dreamreal model as the basis.





from django import forms
from.models import Dreamreal

classDreamrealForm(forms.ModelForm):classMeta:

  model = Dreamreal
  fields ="__all__"</code></pre>




An object of the model form is rendered on the HTML form. In case the request method is POST, the save() method of the ModelForm class automatically validates the form and saves a new record.





from.forms import DreamrealForm
defaddnew(request):if request.method =='POST':

  form = DreamrealForm(request.POST)if form.is_valid():
     form.save()return HttpResponse("&lt;h2&gt;Book added successfully&lt;/h2&gt;")

   context={'form': DreamrealForm}return render(request,"myform.html", context)





Django Insert Data 2





The CreateView Class





Django defines a collection of generic view classes. The CreateView class is specially designed for performing the INSERT query operation.





We define a subclass of CreateView class and set its template_name property to myform.html that we have already created.





Add the following code in views.py file −





from django.views.generic import CreateView
classDRCreateView(CreateView):
   model = Dreamreal
   fields ="__all__"
   template_name ='myform.html'
   success_url ='../success/'





On successful insertion, the browser is redirected to the success() view function.





defsuccess(request):return HttpResponse("<h2>Book added successfully</h2>")





Both the above views must be included in the URL pattern list of urls.py file. The generic view classes are registered with their as_view() method.





from django.urls import path
from.import views
from.views import DRCreateView

urlpatterns =[
   path("", views.index, name="index"),
   path("addnew/", views.addnew, name='addnew'),
   path("add/", DRCreateView.as_view(), name='add'),
   path("success/", views.success, name='success'),]





In this chapter, we learned the different ways to insert data in a Django model.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

More posts