how to do pagination using mongoengine?

django mongodb pagination mongoengine
user493550 picture user493550 · Nov 22, 2012 · Viewed 7.6k times · Source

i have a question about pagination using mongodb and mongoengine. i have a table which will have millions of records in future. and i am doing paging like this.

well i am not sure this is correct approach 

    list = Books.objects.all()
    paginator = DiggPaginator(list, 20, body = 10, tail = 2)

here i open whole table and then do the pagination and we on for next page again above code runs and brings the 2nd or any page.

is this correct approach or there are any better ways to do this.

Answer

Eric picture Eric · Nov 22, 2012

You can use skip and limit from QuerySet to achieve pagination.
For example if you want to show the second page with a limitation of 10 items per page, you can do like this: 

page_nb = 2 
items_per_page = 10 

offset = (page_nb - 1) * items_per_page

list = Books.objects.skip( offset ).limit( items_per_page )

Related questions

PyMongo vs MongoEngine for Django

For one of my projects I prefered using Django+Mongo. Why should I use MongoEngine, but not just PyMongo? What are advantages? Querying with PyMongo gives results that are allready objects, aren't they? So what is the purpose of MongoEngine?

Read More
Mongoengine creation_time attribute in Document

I am trying to add a creation_time attribute to my documents. The following would be an example: import datetime class MyModel(mongoengine.Document): creation_date = mongo.DateTimeField() modified_date = mongo.DateTimeField(default=datetime.datetime.now) Django models have built …

Read More
How to do "insert if not exist else update" with mongoengine?

I'm working with mongoengine in Django, this is my document defination: class Location(mongoengine.Document): user_id = mongoengine.IntField(required=True) point = mongoengine.GeoPointField(required=True) I want to do this: given a user_id and a point: if there …

Read More