django 不使用 orm

最新推荐文章于 2024-08-20 13:48:12 发布

原创最新推荐文章于 2024-08-20 13:48:12 发布 · 1.8k 阅读

1 ·

CC 4.0 BY-SA版权

django 专栏收录该内容

34 篇文章

订阅专栏

本文介绍了一种将数据库查询结果转换为字典的方法，通过定义函数dictfetchall，实现了从游标中获取所有行并将其转换为字典格式。此外，还展示了如何在Django中使用自定义SQL查询更新和检索数据。

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}]

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):
    "从cursor获取所有行数据转换成一个字典"
    columns = [col[0] for col in cursor.description]
    return [
        dict(zip(columns, row))
        for row in cursor.fetchall()
    ]