fastapi-pagination icon indicating copy to clipboard operation
fastapi-pagination copied to clipboard

FastAPI pagination 📖

logo

license test codecov downloads pypi black

Introduction

fastapi-pagination is a library that provides pagination feature for FastAPI applications.


For more information about library please see documentation.


Installation

pip install fastapi-pagination

Quickstart

All you need to do is to use Page class as a return type for your endpoint and call paginate function on data you want to paginate.

from fastapi import FastAPI
from pydantic import BaseModel, Field

# import all you need from fastapi-pagination
from fastapi_pagination import Page, add_pagination, paginate

app = FastAPI()  # create FastAPI app


class UserOut(BaseModel):  # define your model
    name: str = Field(..., example="Steve")
    surname: str = Field(..., example="Rogers")


users = [  # create some data
    # ...
]


@app.get('/users', response_model=Page[UserOut])  # use Page[UserOut] as response model
async def get_users():
    return paginate(users)  # use paginate function to paginate your data


add_pagination(app)  # important! add pagination to your app

Please, be careful when you work with databases, because default paginate will require to load all data in memory.

For instance, if you use SQLAlchemy you can use paginate from fastapi_pagination.ext.sqlalchemy module.

from fastapi_pagination.ext.sqlalchemy import paginate


@app.get('/users', response_model=Page[UserOut])
def get_users(db: Session = Depends(get_db)):
    return paginate(db.query(User).order_by(User.created_at))

For SQLAlchemy 2.0 style you can use paginate from fastapi_pagination.ext.sqlalchemy_future module.

from sqlalchemy import select
from fastapi_pagination.ext.sqlalchemy_future import paginate


@app.get('/users', response_model=Page[UserOut])
def get_users(db: Session = Depends(get_db)):
    return paginate(db, select(User).order_by(User.created_at))

Currently, fastapi-pagination supports:

Library paginate function
SQLAlchemy fastapi_pagination.ext.sqlalchemy.paginate
SQLAlchemy 2.0 style fastapi_pagination.ext.sqlalchemy_future.paginate
Async SQLAlchemy 2.0 style fastapi_pagination.ext.async_sqlalchemy.paginate
SQLModel fastapi_pagination.ext.sqlmodel.paginate
Async SQLModel fastapi_pagination.ext.async_sqlmodel.paginate
AsyncPG fastapi_pagination.ext.asyncpg.paginate
Databases fastapi_pagination.ext.databases.paginate
Django ORM fastapi_pagination.ext.django.paginate
GINO fastapi_pagination.ext.gino.paginate
ORM fastapi_pagination.ext.orm.paginate
ormar fastapi_pagination.ext.ormar.paginate
Piccolo fastapi_pagination.ext.piccolo.paginate
Pony ORM fastapi_pagination.ext.pony.paginate
Tortoise ORM fastapi_pagination.ext.tortoise.paginate
Beanie fastapi_pagination.ext.beanie.paginate
PyMongo fastapi_pagination.ext.pymongo.paginate
MongoEngine fastapi_pagination.ext.mongoengine.paginate
Motor fastapi_pagination.ext.motor.paginate

Code from Quickstart will generate OpenAPI schema as bellow:

app-example