Wednesday, January 30, 2019

RE: Get very last object of database

You can try Mydb.objects.last()

You can also try reversing the order and using first:  Mydb.objects.order_by('-pk').first()

 

And for some terminology clarification, a database consists of tables.  In Django, a model maps to a table, not a database.  A table has fields; a database has tables but not fields.

 

From: django-users@googlegroups.com [mailto:django-users@googlegroups.com] On Behalf Of Stéphane Manguette
Sent: Wednesday, January 30, 2019 4:02 PM
To: Django users
Subject: Get very last object of database

 

Hello guys, 

 

My issue is pretty simple. I want to get the very last record of my database (which is populated with thousands of entries)

 

So far ->very easy. But I want to make sure that the access to the database is as light as possible. Don't want django to parse everything in my database.

 

Kindly note that my DB has Primary key field.

 

I tried 

Mydb.objects.all()[:1]

Mydb.objects.all()[1:]

 

 

but both return the first filed instead of the last one.

 

Thanks for your help

 

Stephane

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/32533a94-d27f-4091-9910-6644cd11ea49%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment