Skip to main content

Django query for database operation using Python Shell



Django provides a NoSQL query means it does not support SQL, We will write queries in Object patterns using Python script.

Now I am discussing queries in Django that can be used to implement database operations.

First Create a Model Class and define columns according to requirements.


class Student(models.Model):
   rno = Model.CharField(max_length=50)
  sname = Model.CharField(max_length=50)

command 

python manage.py makemigrations appname 
python manage.py migrate

If you want to run the query using Python Shell then first use the following command?

python manage.py shell


1)  Django query for data insertion:-

   ref =  ModelClass(fieldname1=value,fieldname2=value)
   ref.save()


for the Student Model class, the insert query would be.

 obj = Student(rno='1001',sname='xyz')
 obj.save()


2)  Django query for data updation:

for updation, we will perform two operations first find the row  then update the row

 ref = ModelClassName.objects.get(pk=value)  # find row to update
 ref.columnname = value
 ...
 ref.save()

Example for Student Model Class:-

s =  Student.objects.get(pk=value)
s.rno=newvalue
s.sname=newvalue
s.save() 

3)  Django query for data deletion:-

    for deletion, we will perform two operations first find the row then delete the row

    ref = ModelClassname.objects.get(pk=value)
    ref.delete()

   for Student Class, this Query will be implemented this way:-

    s = Student.objects.get(pk=value)      #  display data in Object
    s.delete()


4)  Django query for data selection:-
    
ref = ModelClassName.objects.all()    #for Selection

Example of Student Class

s = Student.objects.all()   # display data in QuerySet

5)  Django query to select record based on condition

ref = ModelClassName.objects.filter(columnname=value)

for Student Class

s = Student.objects.filter(rno=1001)   #display Data in QuerySet



6) Django Query to find a record based on pattern matching similar to LIKE Operator of SQL:-

ref = ModelClassName.objects.filter(colunname__startsWith='char')


for Student Class

obj = Student.objects.filter(sname__startsWith='s')


7) Django Query to find a record based on pattern matching similar to LIKE Operator of SQL:-

ref = ModelClassName.objects.filter(colunname__endsWith='char')

for Student Class

obj = Student.objects.filter(sname__endsWith='s')

8) Django Query to display records using Order based on ascending and descending order?

ref = ModelClassName.objects.order_by('-columnname')[:2]

to implement Student Model

obj = Student.objects.order_by('-fees')[:2]






   
       

Comments

Popular posts from this blog

Uncontrolled form input in React-JS

  Uncontrolled form input in React-JS? If we want to take input from users without any separate event handling then we can uncontrolled the data binding technique. The uncontrolled input is similar to the traditional HTML form inputs. The DOM itself handles the form data. Here, the HTML elements maintain their own state that will be updated when the input value changes. To write an uncontrolled component, you need to use a ref to get form values from the DOM. In other words, there is no need to write an event handler for every state update. You can use a ref to access the input field value of the form from the DOM. Example of Uncontrolled Form Input:- import React from "react" ; export class Info extends React . Component {     constructor ( props )     {         super ( props );         this . fun = this . fun . bind ( this ); //event method binding         this . input = React . createRef ();...

JDBC using JSP and Servlet

JDBC means Java Database Connectivity ,It is intermediates from Application to database. JDBC has different type of divers and provides to communicate from database server. JDBC contain four different type of approach to communicate with Database Type 1:- JDBC-ODBC Driver Type2:- JDBC Vendor specific Type3 :- JDBC Network Specific Type4:- JDBC Client-Server based Driver  or JAVA thin driver:- Mostly we prefer Type 4 type of Driver to communicate with database server. Step for JDBC:- 1  Create Database using MYSQL ,ORACLE ,MS-SQL or any other database 2   Create Table using database server 3   Create Form according to database table 4  Submit Form and get form data into servlet 5  write JDBC Code:-     5.1)   import package    import java.sql.*     5.2)  Add JDBC Driver according to database ide tools     5.3)  call driver in program         ...

JSP Page design using Internal CSS

  JSP is used to design the user interface of an application, CSS is used to provide set of properties. Jsp provide proper page template to create user interface of dynamic web application. We can write CSS using three different ways 1)  inline CSS:-   we will write CSS tag under HTML elements <div style="width:200px; height:100px; background-color:green;"></div> 2)  Internal CSS:-  we will write CSS under <style> block. <style type="text/css"> #abc { width:200px;  height:100px;  background-color:green; } </style> <div id="abc"></div> 3) External CSS:-  we will write CSS to create a separate file and link it into HTML Web pages. create a separate file and named it style.css #abc { width:200px;  height:100px;  background-color:green; } go into Jsp page and link style.css <link href="style.css"  type="text/css" rel="stylesheet"   /> <div id="abc"> </div> Exam...