我将如何使用原始 SQL 执行以下操作views.py
?
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
函数是什么样的?
>>> 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
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)