Using nested DTOs

[ste-pool]

Hello 😄

I'm following along with your litestar examples. However, one issue is confusing me: Using your SQLALchemyDTO with a nested type.

In the litestar_repo_only example it says
# we will explicitly define the schema instead of using DTO objects for clarity. which is fine, but I cannot seem to get it to work with using DTOs and it's driving me crazy.

I added

AuthorDTO = SQLAlchemyDTO[AuthorModel]
....
@get(... return_dto=AuthorDTO)

But it complains that the Book is an unsupported type when trying to serialise the response. How would I get it to work?

advanced_alchemy==0.14.1
litestar==2.9.0
SQLAlchemy==2.0.31

[ste-pool]

Okay, I figured it out. I stumbed upon one of the pull requests #148 which helped! I was making the model parent be one of the DeclarativeBase of sqlalchemy rather than the UUIDBase.

It needs the:

class Base(DeclarativeBase):
    registry = orm_registry 

For it to work. I feel like an idiot, but it's solved at least! 🙌