rodrigosantosbr

[Django] Get max number from a column

Feb 18th, 2019
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.58 KB | None | 0 0
  1. from django.shortcuts import render
  2. from main.models import Person
  3. from django.db.models import Max
  4.  
  5. # Create your views here.
  6. def home(request):
  7.     p = Person(name="Fred Flintstone", number="1")
  8.     p.save()
  9.     p = Person(name="Gato Felix", number="2")
  10.     p.save()
  11.     last_person = Person.objects.order_by('-number').values('number')[:1]
  12.     last_person2 = Person.objects.aggregate(Max('number'))
  13.     print("="*20)
  14.     print("ULTIMO")
  15.     print(last_person[0]['number'])
  16.     print(last_person2['number__max'])
  17.     print("="*20)
  18.     return render(request, 'main/index.html')
Add Comment
Please, Sign In to add comment