How to include total for cursor pagination?

[holtgrewe]

How can I enable the "total" field in the result page for sqlalchemy cursor pagination?

[uriyyo]

Hi @holtgrewe,

Currently, you need to define a custom page for this:

from typing import Generic, TypeVar

from fastapi_pagination.bases import CursorRawParams
from fastapi_pagination.cursor import CursorPage, CursorParams

T = TypeVar("T")


class TotalCursorParams(CursorParams):
    def to_raw_params(self) -> CursorRawParams:
        params = super().to_raw_params()
        params.include_total = True

        return params


class TotalCursorPage(CursorPage[T], Generic[T]):
    __params_type__ = TotalCursorParams

[holtgrewe]

Thanks!