django直接使用sql的时候 转换成字典

django直接使用sql的时候 转换成字典
[ccn lang="sql" tab_size="4" theme="blackboard" width="800" ]
from django.db import connection
cursor = connection.cursor()

cursor.execute('''SELECT CAST(AVG( complete_speed ) as decimal(10,2)) as complete_speed,
CAST(AVG( complete_quality ) as decimal(10,2)) as complete_quality ,
CAST(AVG( work_bearing ) as decimal(10,2)) as work_bearing ,
be_marked_user_id , u.first_name , CAST(AVG((complete_speed+complete_quality+work_bearing)/3) as decimal(10,2)) as average
FROM mark_pointresult r left join auth_user u
on u.id=r.be_marked_user_id
GROUP BY be_marked_user_id''')
desc = cursor.description
data = [dict(zip([col[0] for col in desc], row)) for row in cursor.fetchall()]
[/ccn]