django 中运行原生sql的两种方式

1. RAW方式

class Person(models.Model):
    first_name = models.CharField(...)
    last_name = models.CharField(...)
    birth_date = models.DateField(...)
    
#注意这种方式需要返回主键，否则失效
for p in Person.objects.raw("SELECT * FROM myapp_person"):
	print(p)

2. 游标方式

from django.db import connection

def my_custom_sql(self):
    with connection.cursor() as cursor:
        cursor.execute("UPDATE bar SET foo = 1 WHERE baz = %s", [self.baz])
        cursor.execute("SELECT foo FROM bar WHERE baz = %s", [self.baz])
        row = cursor.fetchone()

    return row

关于游标的方式默认返回的是一个元组，假如你想返回一个字典，则可以这么操作

def dictfetchall(cursor): 
    "Returns all rows from a cursor as a dict" 
    desc = cursor.description 
    return [
            dict(zip([col[0] for col in desc], row)) 
            for row in cursor.fetchall() 
    ]

cursor.execute("SELECT id, parent_id from test LIMIT 2");
dictfetchall(cursor)
[{'parent_id': None, 'id': 54360982L}, {'parent_id': None, 'id': 54360880L}] 

https://docs.djangoproject.com/zh-hans/4.1/topics/db/sql/

https://stackoverflow.com/questions/10888844/using-dict-cursor-in-django