個(gè)人觀點(diǎn): 個(gè)人認(rèn)為,在Django項(xiàng)目中, 開(kāi)發(fā)團(tuán)隊(duì)為了讓使用該框架的用戶都使用自帶的序列化功能,從而讓框架中的SQL返回值很不直觀,對(duì)于直接使用SQL語(yǔ)句的用戶很犯難.

解決:

from django.db import connection
from collections import OrderedDict

def run(sql):
    cursor = connection.cursor()
    cursor.execute(sql, None)
    desc = cursor.description
    desc = desc if desc else []
    return_li = []
    result_key = [col[0] for col in desc]
    for i in cursor.fetchall():
        order_dict = OrderedDict()
        for index, value in enumerate(i):
            order_dict.update({result_key[index]: value})
        else:
            return_li.append(order_dict)
    print(return_li)  # 返回[{}, {}, ...]類型數(shù)據(jù)