python - Django View 中的原始 SQL 查询

Question

如何在 views.py 中使用原始 SQL 执行以下操作？

from app.models import Picture

def results(request):
    all = Picture.objects.all()
    yes = Picture.objects.filter(vote='yes').count()
    return render_to_response(
        'results.html', 
        {'picture':picture, 'all':all, 'yes': yes}, 
        context_instance=RequestContext(request)
    )

这个 results 函数会是什么样子？

Answer 1

>>> from django.db import connection
>>> cursor = connection.cursor()
>>> cursor.execute('''SELECT count(*) FROM people_person''')
1L
>>> row = cursor.fetchone()
>>> print row
(12L,)
>>> Person.objects.all().count()
12

使用 WHERE 子句过滤赞成票:

>>> cursor.execute('''SELECT count(*) FROM people_person WHERE vote = "yes"''')
1L