CODEWITHSUNDEEP
djangomongodbpaginationmongoengine
user493550
user493550

Reputation: 217

how to do pagination using mongoengine?

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.

Upvotes: 14

Views: 12740

Answers (3)

Code_Worm
Code_Worm

Reputation: 4470

You can use array-slicing syntax as well which is a bit more decent and readable :

begin = (page - 1) * page_size # offset
end = offset + page_size
list = Books.objects[begin:end]()

Upvotes: 1

Ross
Ross

Reputation: 18111

The flask-mongoengine plugin has an example of a paginator you could adapt to follow the digg paginator.

Upvotes: 2

Eric
Eric

Reputation: 2894

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 )

Upvotes: 31

Related Questions