Django - ORM

crud_operations.py

# Common CRUD Operations using Django


# ----------------------------------------
#   in an app's models.py…

from django.db import models

class Person(models.Model):
    first_name = models.CharField(max_length=100)
    last_name = models.CharField(max_length=100)
    address = models.TextField()


# ----------------------------------------
#   in views.py…


# ----------------------------------------
#   Create / Insert Query

from .models import Person

    # Save directly onto a Person instance
obj1 = Person(
    first_name="Rob", 
    last_name="Kistner", 
    address="1060 West Addison"
)
obj1.save()

    # using the objects.create function
obj2 = Person.objects.create(
    first_name="Rob",
    last_name="Kistner",
    address="1060 West Addison"
)


# ----------------------------------------
#   Get Query

    # assuming known the id
obj1 = Person.objects.get(id=1)


# ----------------------------------------
#   Update Query

obj1 = Person.objects.get(id=1)
obj1.first_name = "Adam"
obj1.save()


# ----------------------------------------
#   Delete Query

    # accessing via .get
obj1 = Person.objects.get(id=1)
obj1.delete()

    # accessing using .fitler
Person.objects.filter(id=1).delete()


# ----------------------------------------
#   Filtering

    # filter query
    # icontains is case-insensitive
obj_list = Person.objects.filter(first_name__icontains="adam")