7.5. ORM All

7.5.1. All

>>> Address.objects.all()
<QuerySet [<Address: Mark Watney - NASA Pkwy, Houston, Texas USA>, <Address: Melissa Lewis - Powstańców Wielkopolskich, Krakow, malopolskie Poland>]>

>>> Address.objects.all()
<QuerySet [<Address: Mark Watney - NASA Pkwy, Houston, Texas USA>, <Address: Melissa Lewis - Powstańców Wielkopolskich, Krakow, malopolskie Poland>]>

7.5.2. Order

>>> Customer.objects.all().order_by('lastname')
<QuerySet [<Customer: Mark Watney>, <Customer: Melissa Lewis>, <Customer: Rick Martinez>, <Customer: Mark W>, <Customer: Mark Watney>]>

>>> Customer.objects.all().order_by('-lastname')
<QuerySet [<Customer: Mark Watney>, <Customer: Mark W>, <Customer: Rick Martinez>, <Customer: Melissa Lewis>, <Customer: Mark Watney>]>

>>> Customer.objects.all().order_by('-lastname', 'firstname')
<QuerySet [<Customer: Mark Watney>, <Customer: Mark W>, <Customer: Rick Martinez>, <Customer: Melissa Lewis>, <Customer: Mark Watney>]>

7.5.3. Values

>>> Customer.objects.all().values('firstname')
<QuerySet [{'firstname': 'Mark'}, {'firstname': 'Rick'}, {'firstname': 'Melissa'}, {'firstname': 'Mark'}, {'firstname': 'Watney'}, {'firstname': 'Mark'}]>

>>> Customer.objects.all().values('firstname').distinct()
<QuerySet [{'firstname': 'Mark'}, {'firstname': 'Rick'}, {'firstname': 'Melissa'}, {'firstname': 'Mark'}]>

>>> c = Customer.objects.all()
>>> fname = c.values('firstname')
>>> lname = c.values('lastname')
>>>
>>> fname
<QuerySet [{'firstname': 'Mark'}, {'firstname': 'Rick'}, {'firstname': 'Melissa'}, {'firstname': 'Mark'}, {'firstname': 'Mark'}]>
>>>
>>> lname
<QuerySet [{'lastname': 'Watney'}, {'lastname': 'Lewis'}, {'lastname': 'Martinez'}, {'lastname': 'W'}, {'lastname': 'Watney'}]>

7.5.4. Debug

>>> str(Customer.objects.all().query)
'SELECT "shop_customer"."id", "shop_customer"."created_date", "shop_customer"."created_author_id", "shop_customer"."modified_date", "shop_customer"."modified_author_id", "shop_customer"."firstname", "shop_customer"."lastname", "shop_customer"."salary", "shop_customer"."job", "shop_customer"."birthdate", "shop_customer"."age", "shop_customer"."gender", "shop_customer"."is_adult", "shop_customer"."weight", "shop_customer"."height", "shop_customer"."email", "shop_customer"."homepage", "shop_customer"."phone_country_code", "shop_customer"."phone_number", "shop_customer"."picture", "shop_customer"."attachment", "shop_customer"."notes" FROM "shop_customer"'

>>> str(Customer.objects.all().values('firstname').query)
'SELECT "shop_customer"."firstname" FROM "shop_customer"'

>>> str(Customer.objects.all().values('firstname', 'lastname').query)
'SELECT "shop_customer"."firstname", "shop_customer"."lastname" FROM "shop_customer"'