Sort¶

Basic sort¶

from pyrsql import Sort

Sort.parse("name")                 # ascending (default)
Sort.parse("name,asc")             # explicit ascending
Sort.parse("name,desc")            # descending

Multi-field¶

Sort.parse("name,asc;company.name,desc")

Ignore case¶

Sort.parse("name,desc,ic")         # case-insensitive descending

Function selectors¶

Sort.parse(
    "@upper[name],asc",
    options=SortOptions(procedure_whitelist=("upper",)),
)

Sort limits¶

from pyrsql.sorting.limits import SortLimits

Sort.parse("...", options=SortOptions(
    sort_limits=SortLimits(max_fields=5, max_sort_length=256),
))