django 查询返回字典

# -*- coding: utf-8 -*-
from itertools import *
import os
import sys
import types

sys.path.insert(0, os.path.abspath(os.path.dirname(__file__)))

os.environ["DJANGO_SETTINGS_MODULE"] = "settings"

from django.db import connections

def query_to_dicts(query_string, params = None ,using = None):  
    """Run a simple query and produce a generator 
    that returns the results as a bunch of dictionaries 
    with keys for the column values selected. 
    """  
    params = params or ()  
    using  = using or "default"  
    cursor = connections[using].cursor()  
    cursor.execute(query_string, params)  
    col_names = [desc[0] for desc in cursor.description]  
    while True:  
        row = cursor.fetchone()  
        if row is None:  
            break  
        row_dict = dict(izip(col_names, row))  
        yield row_dict  


sql = u"""
    select * from user where username like %s
"""
using = "default"
like = ('%zhang%',)
d =  query_to_dicts(sql,like,using)
result = []
for e in d:
    result.append(e)

print len(result)