shot_ordering.py

def build_lexical_condition(
    ordering_components: list[gql.ShotsOrderingComponent],
) -> sa.sql.elements.BooleanClauseList:
    if not ordering_components:
        return False

    this_component = ordering_components[0]
    _, field, ordering = this_component.get_component_with_column()
    this_condition = (
        field < ordering.starting_at
        if ordering.descending
        else field > ordering.starting_at
    )

    remaining_components = ordering_components[1:]
    rest_conditions = [field == ordering.starting_at]
    if remaining_components:
        rest_conditions.append(build_lexical_condition(remaining_components))
    return sa.or_(
        this_condition,
        (sa.and_(*rest_conditions)),
    )