Calling paginate manually and enforce a Cursor Page

[maciossek]

Hi,

I am trying to call the paginate function outside of a fastapi handler and receive an error: TypeError: Page should be used with Params.

My context is SQLAlchemy and Strawberry GraphQL.

That's my dummy code:

def get_viewer_catalogue_items(root: "Viewer", info: Info[Context, "Viewer"]) -> LimitCursorPage500[ProductResponse]:
    cursor = CursorParams()

    return paginate(info.context.db, select(Product).where(Product.userId == info.context.user.id).order_by(Product.id), cursor)

How can I pass CursorParams without getting an error, is there another paginate function I need to call or use another Params class?

[uriyyo]

Hi @maciossek,

You should also call set_page if you use paginate outside the route:

from fastapi_pagination import set_page

def get_viewer_catalogue_items(root: "Viewer", info: Info[Context, "Viewer"]) -> LimitCursorPage500[ProductResponse]:
    cursor = CursorParams()
    set_page(LimitCursorPage500[ProductResponse])

    return paginate(info.context.db, select(Product).where(Product.userId == info.context.user.id).order_by(Product.id), cursor)

[maciossek]

Thank you very much!