Skip to main content

A small pagination package

Project description

Welcome to villain-pagination


First of all, you need to install villain-pagination on your local to start.

pip install villain-pagination

Minimal Example

Villain Paginator uses SQLAlchemy ORM.

Let's start with a simple example below. You need to import page and paginator function from villain-pagination.

  • page : is a class which used as response_model in your route declaration.
  • paginator : is main functions that will paginate your data.

To use paginate, 5 params required.

  • db : is a SQLAlchemy session.
  • model : is a object which you want to paginate.
  • order_by : is a column of the model.
  • page : is a number of a page requested to show.
  • size : is a number of data which will shown in one page.

And Here is an example.

from typing import Iterator, Any
from faker import Faker
from fastapi import Depends, FastAPI
from sqlalchemy import Column, Integer, String, create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import Session, sessionmaker

from villain import page, paginator

engine = create_engine("sqlite:///.db", connect_args={"check_same_thread": False})
SessionLocal = sessionmaker(autocommit=True, autoflush=True, bind=engine)

Base = declarative_base(bind=engine)

fake = Faker()

class User(Base):
    __tablename__ = "users"

    id = Column(Integer, primary_key=True, autoincrement=True)
    name = Column(String, nullable=False)


app = FastAPI()

def on_startup() -> None:
    session = SessionLocal()
    session.add_all([User( for _ in range(100)])

def get_db() -> Iterator[Session]:
    db = SessionLocal()
        yield db

@app.get("/users/", response_model=page.Page)
def get_users(db: Session = Depends(get_db)) -> Any:
    return paginator.paginate(db = db, model = User, order_by=, page = 0, size = 10 )

Project details

Download files

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

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page