Django ORM 与 PostgreSQL 原始 SQL

使用Django ORM与PostgreSQL原始SQL的强大组合，可以轻松地操作和管理数据库。Django ORM提供了便捷的方法来执行数据库操作，而PostgreSQL原始SQL则允许我们以更灵活的方式与数据库进行交互。在本文中，我们将探讨这两个工具的优势，并通过一些实际案例代码来展示它们的用法。

python
from django.db import models
class Post(models.Model):
    title = models.CharField(max_length=100)
    content = models.TextField()
    pub_date = models.DateTimeField(auto_now_add=True)

python
posts = Post.objects.all()

python
post = Post.objects.get(title="Hello World")

python
post = Post(title="New Post", content="This is a new post.")
post.save()

python
post = Post.objects.get(title="New Post")
post.content = "This is an updated post."
post.save()

python
post = Post.objects.get(title="New Post")
post.delete()

python
from django.db import connection
start_date = "2022-01-01"
end_date = "2022-12-31"
with connection.cursor() as cursor:
    cursor.execute("SELECT * FROM blog_post WHERE pub_date BETWEEN %s AND %s", [start_date, end_date])
    posts = cursor.fetchall()