Exclude fields from nested models with SQLAlchemyDTO

[Alurith]

Hi,
I have some issue excluding some fields from my SQLAlchemyDTO. Let's say I have this code:

class ChildModel(Base):
    __tablename__ = "child"

    id: Mapped[int] = mapped_column(primary_key=True)
    name: Mapped[str]
    # other columns    
    parent_id: Mapped[int] = mapped_column(ForeignKey("parent.id"))
    parent: Mapped["ParentModel"] = relationship(
        back_populates="children", lazy="joined"
    )


class ParentModel(Base):
    __tablename__ = "parent"

    id: Mapped[int] = mapped_column(primary_key=True)
    name: Mapped[str]
    # other colums
    children: Mapped[List["ChildModel"]] = relationship(back_populates="parent")

class ParentModelDTO(SQLAlchemyDTO[ParentModel]):
    config = DTOConfig(exclude={"id", "children.0.parent_id" "children.0.id"})


class ChildModelDTO(SQLAlchemyDTO[ChildModel]):
    config = DTOConfig(exclude={"id", "parent_id", "parent"})

In my controller I set the dto and return_dto to ParentModelDTO like the following:

class ParentHandler(Controller):
    path = "/parent"
    dto = ParentModelDTO
    return_dto = ParentModelDTO

    @get(path="")
    async def get_parents(self, transaction: AsyncSession) -> List[ParentModel]:
        query = select(ParentModel).options(selectinload(ParentModel.children))
        result = await transaction.execute(query)
        return result.scalars().all()

I was expecting the resulting json to be outputed without id and parent_id, but that's not the case.

What am I doing wrong?

Should I rename those field in my ChildModel with the underscore _id and _parent_id setting them as private? Or is there another way?

Thanks

[Alc-Alc]

Heya, there is a typo here

config = DTOConfig(exclude={"id", "children.0.parent_id" "children.0.id"})

it must be

config = DTOConfig(exclude={"id", "children.0.parent_id", "children.0.id"})

[Alurith]

I am so dumb! I didn't notice the missing comma, now it works correctly.

Thanks!