all AI news
Django ORM
May 27, 2023, 12:05 p.m. | Odipo Otieno
DEV Community dev.to
Django provides an Object-Relational Mapping (ORM) layer that allows you to interact with your database using Python code instead of writing raw SQL queries. The ORM provides a high-level, Pythonic API for performing database operations. Here are some common Django ORM commands and their equivalent SQL statements:
Creating Objects:
- Django ORM:
Model.objects.create(**kwargs)
- SQL:
INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...)
- Django ORM:
Saving Objects:
- Django ORM:
object.save()
- SQL:
UPDATE table_name SET column1=value1, column2=value2, ... WHERE condition
- Django ORM:
Querying Objects:
- Django …
api code database django mapping objects operations orm programming python raw sql sql queries tutorial webdev writing
More from dev.to / DEV Community
Jobs in AI, ML, Big Data
Founding AI Engineer, Agents
@ Occam AI | New York
AI Engineer Intern, Agents
@ Occam AI | US
AI Research Scientist
@ Vara | Berlin, Germany and Remote
Data Architect
@ University of Texas at Austin | Austin, TX
Data ETL Engineer
@ University of Texas at Austin | Austin, TX
Lead GNSS Data Scientist
@ Lurra Systems | Melbourne