pypaginate.adapters.sqlalchemy.sorting

SQLAlchemy sort backend translating SortSpec to ORDER BY clauses.

Maps SortDirection and NullsPosition to SQLAlchemy column modifiers.

Classes

SQLAlchemySortBackend

Translates SortSpec to SQLAlchemy ORDER BY clauses.

Module Contents

class pypaginate.adapters.sqlalchemy.sorting.SQLAlchemySortBackend

Translates SortSpec to SQLAlchemy ORDER BY clauses.

Satisfies SortBackend protocol.

static apply_sorting(query: object, sorting: collections.abc.Sequence[pypaginate.domain.specs.SortSpec]) → object

Apply sort specs to a SQLAlchemy Select.

Parameters:

• query – A SQLAlchemy Select statement.

• sorting – Sort specifications (applied in order).

Returns:

Modified Select with ORDER BY clauses.