Django ORM - Inserting, Updating and Deleting Data

Understanding Django ORM

Django’s Object-Relational Mapping (ORM) system is a powerful feature that allows developers to interact with the database using Python code instead of writing raw SQL queries. With Django ORM, managing database records becomes more intuitive and maintainable.

Inserting Data into the Database

Adding new records is one of the most common operations in any web application. In Django, this can be done easily by creating an instance of a model and saving it. For example:

from myapp.models import Student

new_student = Student(name="Aditi", age=21, department="Computer Science")
new_student.save()

This code creates a new student record and inserts it into the database without writing a single line of SQL.

Updating Existing Records

Updating records is just as simple. First, you retrieve the object you want to modify using the model's manager (usually objects), make the necessary changes, and then call save() again:

student = Student.objects.get(id=1)
student.age = 22
student.save()

This updates the student’s age in the database. You can also perform bulk updates using the update() method on a queryset.

Deleting Records

To remove data, Django provides a straightforward method. Once you've identified the object you wish to delete, you simply call its delete() method:

student = Student.objects.get(id=1)
student.delete()

This permanently deletes the selected record from the database. For bulk deletions, you can filter a queryset and call delete() directly:

Student.objects.filter(department="Physics").delete()

Working with QuerySets Efficiently

Django ORM’s true power lies in its ability to handle complex queries using QuerySets. Whether you’re filtering records, ordering them, or limiting results, everything can be done using Python methods. This makes your code cleaner and easier to debug.

Things to Keep in Mind

• Always validate user input before inserting or updating records.
• Be cautious with delete() as it cannot be undone.
• Use Django’s built-in field types and constraints to enforce data integrity.

Conclusion

Django ORM – Inserting, Updating and Deleting Data showcases just how efficient and Pythonic database operations can be within a Django project. By abstracting the SQL layer, Django empowers developers to focus more on application logic while maintaining full control over data handling.

---