- 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)
- 游标方式
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
版权声明:本文为weixin_43632687原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。