HTML tutorial
CSS3 tutorial
Bootstrap tutorial
JavaScript tutorial
JQuery tutorial
AngularJS tutorial
React tutorial
NodeJS tutorial
PHP tutorial
Python tutorial
Python3 tutorial
Django tutorial
Linux tutorial
Docker tutorial
Ruby tutorial
Java tutorial
C tutorial
C ++ tutorial
Perl tutorial
JSP tutorial
Lua tutorial
Scala tutorial
Go tutorial
ASP.NET tutorial
C # tutorial
A QuerySet is a collection of data from a database
A QuerySet is a collection of data from a database.
A QuerySet is built up as a list of objects.
QuerySets makes it easier to get the data you actually need, by allowing you to filter and order the data.
In this tutorial we will be querying data from the Members table.
Members
:
id | firstname | lastname |
---|---|---|
1 | Emil | Refsnes |
2 | Tobias | Refsnes |
3 | Linus | Refsnes |
4 | Lene | Refsnes |
5 | Stalikken | Refsnes |
In views.py
, we have a view for testing called
testing
where we will test different queries.
In the example below we use the .all()
method to get all the records and fields of the Members model:
members/views.py
:
from django.http import HttpResponse
from django.template import loader
from .models import Members
def testing(request):
mydata = Members.objects.all()
template = loader.get_template('template.html')
context = {
'mymembers': mydata,
}
return HttpResponse(template.render(context, request))
The object is placed in a variable called mydata
, and is sent to the template
via the context
object as
mymembers
, and looks like this:
<QuerySet [
<Members: Members object (1)>,
<Members:
Members object (2)>,
<Members: Members object (3)>,
<Members: Members object (4)>,
<Members: Members object (5)>
]>
As you can see, our Members model contains 5 records, and are listed inside the QuerySet as 5 objects.
In the template you can use the mymembers
object to generate content:
template.html
:
<table border='1'>
<tr>
<th>ID</th>
<th>Firstname</th>
<th>Lastname</th>
</tr>
{% for x in mymembers %}
<tr>
<td>{{ x.id }}</td>
<td>{{ x.firstname }}</td>
<td>{{ x.lastname }}</td>
</tr>
{% endfor %}
</table>