Loading lesson path
Concept visual
There are different methods to get data from a model into a QuerySet.
method allows you to return each object as a Python dictionary, with the names and values as key/value pairs:Example views.py
from django.http import HttpResponse from django.template import loader from .models import Member
def testing(request):Formula
mydata = Member.objects.all().values()
template = loader.get_template('template.html')context = {
'mymembers': mydata,
}
return HttpResponse(template.render(context, request))The values_list()
method allows you to return only the columns that you specify.views.py
from django.http import HttpResponse from django.template import loader from .models import Member
def testing(request):Formula
mydata = Member.objects.values_list('firstname')
template = loader.get_template('template.html')context = {
'mymembers': mydata,
}
return HttpResponse(template.render(context, request))Formula
You can filter the search to only return specific rows/records, by using the filter()method.
'Emil' views.py
from django.http import HttpResponse from django.template import loader from .models import Member
def testing(request):Formula
mydata = Member.objects.filter(firstname ='Emil').values()
template = loader.get_template('template.html')context = {
'mymembers': mydata,
}
return HttpResponse(template.render(context, request))method in the next chapter.