How to use DTO to "return relations"

[YuriAlessandro]

Hello. I'm using the Tortoise plugin and I want to know how can I return the values of a relation in the controller.

If i have a relation between two models, for example:

class User(Model):
  id = fields.IntField(pk=True)
  name = fields.CharField(max_length=255)

class Photo(Model):
  id = fields.IntField(pk=True)
  number = fields.CharField(max_length=255)
  status = fields.CharField(max_length=255)

  user = fields.ForeignKeyField('models.User', related_name='users')

UserDTO = dto_factory("UserDTO", User)

In the controller i'm doing:

@get()
async def list_users() -> list[UserDTO]:
  users = await User.all()
  return cast("list[UserDTO]", users )

But this returns only { id: 1, number: 0, status: 'completed'}. How can I include the return of "users" in the model User?

[jtraub]

It doesn't show up there because when DTO factories are created Tortoise is not aware of relations. Internally the plugin uses tortoise.contrib.pydantic.pydantic_model_creator which can work with relations if models have been initialized before its invocation.

Please refer to Tortoise docs