[Python] Problem with multiple Query in view of FastAPI application endpoint

I'm trying to develop filtering/ordering/pagination functionality for FastAPI applications. For now I'm facing difficulty with separating filtering and sorting. The code below generates undesirable swagger:

from fastapi import FastAPI, Query
from pydantic import BaseModel
from sqlalchemy import Select, create_engine, MetaData, select
from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column

app = FastAPI()

url = "postgresql+psycopg2://postgresostgres@localhost:5432/database"
engine = create_engine(url, echo=True)


class Base(DeclarativeBase):
metadata = MetaData()


class User(Base):
__tablename__ = "users"
id: Mapped[int] = mapped_column(primary_key=True)
first_name: Mapped[str]
last_name: Mapped[str]


class FilterSet(BaseModel):
first_name: str | None

def filter_queryset(self, query: Select) -> Select:
conditions = self.model_dump(exclude_unset=True)
# apply ordering
return query


class Ordering(BaseModel):
ordering: list[str] | None = None

def order_queryset(self, query: Select) -> Select:
self.ordering
# apply ordering
return query


@app.get("/")
async def index(filterset: FilterSet = Query(), ordering: Ordering = Query()):
query = select(User)
query = filterset.filter_queryset(query)
query = ordering.order_queryset(query)
# request database


The bad swagger:



Is it possible to fix it without combining FilterSet and Ordering classes into a single class?

Continue reading...