Skip to main content

Pyramid List Pagination contains helpers for pagination of result lists.

Project description

Pyramid Listing contains pyramid resources and helpers for pagination of result lists.

A lot of pyramid applications that use a (SQL) database need to list the result of queries. This result list might get quite long and are split into several pages. This package is offering some help in this.


Lets assume, that you’d like to start a cheese shop and define a simple database model in the pyramid application:

from .meta import Base

class Cheese(Base):
    id = Column(Integer, primary_key=True)
    name = Column(Text, nullable=False)

To get a result list including pagination, just create a sub-class from pyramid_listing.SQLAlchemyListing and define a get_base_query method:

from pyramid_listing import SQLAlchemyListing

class CheeseList(SQLAlchemyListing):

    def get_base_query(self, request)
        return request.dbsession.query(Cheese)

In a view you could then use this class to autmagically get paged results:

def cheese_list_view(request):
    listing = CheeseList(request)
    return {'cheeses': listing.items(), 'pagination': listing.pages}

With this URLs you could access different result pages:

shows page 3:

shows page 1 with 42 items per page:


  • automatically calculate pagination information like first, next or last page from pyradmid.request.GET parameters
  • loading configuration defaults from .ini files
  • easily implement ordering and filtering of results
  • helper method for creating pyradmid.request.GET parameters for different pages
  • base class for listings as location aware pyramid resources

Example Project

To see this in action install the sample project from and take a look at it

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for pyramid_listing, version 0.2.2
Filename, size File type Python version Upload date Hashes
Filename, size pyramid_listing-0.2.2-py3-none-any.whl (13.6 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size pyramid_listing-0.2.2.tar.gz (31.5 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page