20. CRUD Operations in Django

20.1 Inserting Data using save() method

To insert data into the database,

Using save() method

we create an instance of the model and call the save() method on it.

from myapp.models import Person
person = Person(name='Alice', age=25)
person.save()

Here we create a new object of the Person model with the name Alice and age 25 and save it to the database.

Using create() method

We can also use the create() method to create and save an object in a single step.

person = Person.objects.create(name='Alice', age=25)

This return the object that is created.

Note:save() method is used to save the data in database and create() method is used to create and save the data in database.

20.2 Reading Data

20.2.1 Get all data

To get all the data from the database we use the all() method.

from myapp.models import Person
persons = Person.objects.all()

This returns all the objects of the Person model.ie return all the rows of the table.

20.3 Updating Data

To update the data in the database, we first get the object we want to update, change its attributes, and then call the save() method on it.

from myapp.models import Person
person = Person.objects.get(id=1)
person.age = 26
person.save()

20.4 Deleting Data

To delete data from the database, we first get the object we want to delete and then call the delete() method on it.

from myapp.models import Person
person = Person.objects.get(id=1)
person.delete()

20.4 Deleting all data

To delete all the data from the database we use the all() method to get all the objects and then call the delete() method on it.

from myapp.models import Person
persons = Person.objects.all()
persons.delete()

20.5 Filtering Data

We can use the following methods to filter the data in the database.

20.5.1 filter()

The filter() method is used to filter the data based on the given condition.

from myapp.models import Person
persons = Person.objects.filter(age=25)

In the above example, we are filtering the data based on the age of the person.It returns all the objects that have the age equal to 25 in the form of a queryset(List)

20.5.2 exclude()

The exclude() method is used to exclude the data based on the given condition.

from myapp.models import Person
persons = Person.objects.exclude(age=25)

In the above example, we are excluding the data based on the age of the person.It returns all the objects that have the age not equal to 25 in the form of a queryset(List)

20.5.3 get()

The get() method is used to get the single object based on the given condition.

from myapp.models import Person
person = Person.objects.get(id=1)

In the above example, we are getting the object based on the id of the person.It returns the object that has the id equal to 1.

Note:If there are more than one object or no object that satisfies the condition then get() will raise an error but filter() and exclude() will return an empty queryset.

Operation that can be performed on queryset like all(),filter(),exclude()

20.6.order_by()

The order_by() method is used to order the data based on the given field.

from myapp.models import Person
persons = Person.objects.all().order_by('field_name')

In the above example, we are ordering the data based on the field name in ascending order. If you want to order the data in descending order then you can use the - sign before the field name.

from myapp.models import Person
persons = Person.objects.all().order_by('-field_name')

20.7.count()

The count() method is used to count the number of objects in the queryset.

from myapp.models import Person
count = Person.objects.all().count()

20.8 reverse()

The reverse() method is used to reverse the order of the queryset.

from myapp.models import Person
persons = Person.objects.all().reverse()

20.9.first()

The first() method is used to get the first object from the queryset.

from myapp.models import Person
person = Person.objects.all().first()

20.10.last()

The last() method is used to get the last object from the queryset.

from myapp.models import Person
person = Person.objects.all().last()

20.11.exists()

The exists() method is used to check if the queryset contains any objects.

from myapp.models import Person
exists = Person.objects.all().exists()

21. And, Or, Not in filter

We can use & for and, | for or, and ~ for not in the filter method.

Performing and operation in filter

from myapp.models import Person
persons = Person.objects.filter(age=25, name='Alice')

or

from myapp.models import Person
from django.db.models import Q
persons = Person.objects.filter(Q(age=25) & Q(name='Alice'))

Performing or operation in filter

from myapp.models import Person
persons = Person.objects.filter(Q(age=25) | Q(name='Alice'))

Performing not operation in filter

from myapp.models import Person
persons = Person.objects.filter(~Q(age=25))

or

from myapp.models import Person
persons = Person.objects.exclude(age=25)

21.1 Combining and, or, not operation in filter,get,exclude

from myapp.models import Person
from django.db.models import Q
persons = Person.objects.filter(Q(age=25) & Q(name='Alice') | ~Q(age=25))

22. Comparision operators in filter,get,exclude

We can use the following comparision operators in the filter,get,exclude method.

22.1 Comparision operators for integer

1.greater than gt

from myapp.models import Person
persons = Person.objects.filter(age__gt=25)

2.greater than or equal to gte

from myapp.models import Person
persons = Person.objects.filter(age__gte=25)

3.less than lt

from myapp.models import Person
persons = Person.objects.filter(age__lt=25)

4.less than or equal to lte

from myapp.models import Person
persons = Person.objects.filter(age__lte=25)

5.not equal to ne

from myapp.models import Person
persons = Person.objects.filter(age__ne=25)

6.equal

from myapp.models import Person
persons = Person.objects.filter(age=25)

22.2 Comparision operators for string

1.exact

from myapp.models import Person
persons = Person.objects.filter(name__exact='Alice')

2.iexact

from myapp.models import Person
persons = Person.objects.filter(name__iexact='alice')

3.contains

from myapp.models import Person
persons = Person.objects.filter(name__contains='li')

4.icontains

from myapp.models import Person
persons = Person.objects.filter(name__icontains='li')

5.startswith

from myapp.models import Person
persons = Person.objects.filter(name__startswith='A')

6.istartswith

from myapp.models import Person
persons = Person.objects.filter(name__istartswith='a')

7.endswith

from myapp.models import Person
persons = Person.objects.filter(name__endswith='e')

8.iendswith

from myapp.models import Person
persons = Person.objects.filter(name__iendswith='e')

9.in

from myapp.models import Person
persons = Person.objects.filter(name__in=['Alice','Bob'])

Note:i in iexact,icontains,istartswith,iendswith stands for case-insensitive.

23. Limiting Queryset

We can limit the number of objects returned by the queryset using the [:n] syntax.

from myapp.models import Person
persons = Person.objects.all()[:5]

24. Aggregation

Its used to perform some operation on the queryset like counting the number of objects, finding the average, sum, min, max, etc.

24.1 Count

The count() method is used to count the number of objects in the queryset.

from myapp.models import Person
count = Person.objects.all().count()

24.2 Sum

The sum() method is used to find the sum of the field in the queryset.

from myapp.models import Person
sum = Person.objects.all().aggregate(Sum('field_name'))

24.3 Avg

The avg() method is used to find the average of the field in the queryset.

from myapp.models import Person
avg = Person.objects.all().aggregate(Avg('field_name'))

24.4 Min

The min() method is used to find the minimum value of the field in the queryset.

from myapp.models import Person
min = Person.objects.all().aggregate(Min('field_name'))

24.5 Max

The max() method is used to find the maximum value of the field in the queryset.

from myapp.models import Person
max = Person.objects.all().aggregate(Max('field_name'))