django执行原始sql-Jeff
class DB:def __init__(self):
self.cursor = connection.cursor()
#返回list，list中的元素由字典组成，key是查的字段名称
def fetchall(self,sql):
self.cursor.execute(sql)
res = self.cursor.fetchall()
self.col = for desc in self.cursor.description]
list = []
for i in range(len(res)):
data = {}
for j in range(len(res)):
data] = res
list.append(data)
return list
#返回字典，key为查找的字段的名称
def fetchone(self,sql):
self.cursor.execute(sql)
res = self.cursor.fetchone()
self.col = for desc in self.cursor.description]
dict = {}
for i in range(len(res)):
dict] = res
return dict
页:
[1]