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

DSA in C# | Data Structure and Algorithm using C#

  DSA in C# |  Data Structure and Algorithm using C#: Lecture 1: Introduction to Data Structures and Algorithms (1 Hour) 1.1 What are Data Structures? Data Structures are ways to store and organize data so it can be used efficiently. Think of data structures as containers that hold data in a specific format. Types of Data Structures: Primitive Data Structures : These are basic structures built into the language. Example: int , float , char , bool in C#. Example : csharp int age = 25;  // 'age' stores an integer value. bool isStudent = true;  // 'isStudent' stores a boolean value. Non-Primitive Data Structures : These are more complex and are built using primitive types. They are divided into: Linear : Arrays, Lists, Queues, Stacks (data is arranged in a sequence). Non-Linear : Trees, Graphs (data is connected in more complex ways). Example : // Array is a simple linear data structure int[] number...

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...

Conditional Statement in Python

It is used to solve condition-based problems using if and else block-level statement. it provides a separate block for  if statement, else statement, and elif statement . elif statement is similar to elseif statement of C, C++ and Java languages. Type of Conditional Statement:- 1) Simple if:- We can write a single if statement also in python, it will execute when the condition is true. for example, One real-world problem is here?? we want to display the salary of employees when the salary will be above 10000 otherwise not displayed. Syntax:- if(condition):    statements The solution to the above problem sal = int(input("Enter salary")) if sal>10000:     print("Salary is "+str(sal)) Q)  WAP to increase the salary of employees from 500 if entered salary will be less than 10000 otherwise the same salaries will be displayed. Solution:- x = int(input("enter salary")) if x<10000:     x=x+500 print(x)   Q) WAP to display th...