django 直接执行SQL

来源:互联网 发布:杨肃江自动画线源码 编辑:程序博客网 时间:2024/05/16 08:51
 from django.db import connection def dictfetchall(self, cursor):        """Return all rows from a cursor as a dict"""        columns = [col[0] for col in cursor.description]        return [            dict(zip(columns, row))            for row in cursor.fetchall()        ]    def dict_to_list(self, mdict_list):        records = []        for mdict in mdict_list:            mstrs = [' : '.join([smart_str(k), smart_str(v)]) for k, v in mdict.items()]            records.append(', '.join(mstrs))        return records with connection.cursor() as c:     mcursor = c.execute(sql_statement)     mdict_list = self.dictfetchall(mcursor)     results = self.dict_to_list(mdict_list)

参考:https://docs.djangoproject.com/en/stable/topics/db/sql/

0 0