How i can filtered QuerySet inside Pydantic model (Tortoise + FastAPI + PyDantic)?

[Kyle-krn]

I have 2 models:

class Category(Model):
    id: int = fields.IntField(pk=True)
    name: str = fields.CharField(max_length=200, unique=True)
    parent: fields.ForeignKeyNullableRelation\["Category"\] = fields.ForeignKeyField(
    "models.Category", related_name="children", null=True, on_delete="SET NULL"
    )
    slug: str = fields.CharField(max_length=200, unique=True)
    children: fields.ReverseRelation\["Category"\]
    products: fields.ReverseRelation\["Product"\]
    filters = fields.JSONField(null=True)
    updated_at = fields.DatetimeField(auto_now=True)
    created_at = fields.DatetimeField(auto_now_add=True)

class PydanticMeta:
        # computed = ["count_active_product"]
        exclude = ["updated_at", "created_at", "products.category", "children.parent",     "parent.children", "parent.products", "parent.filters"]
        allow_cycles = True
        max_recursion = 2`
    
    
  class Product(Model):
      id: int = fields.IntField(pk=True)
      name: str = fields.CharField(max_length=200, unique=True)
      price: Decimal = fields.DecimalField(max_digits=1000, decimal_places=2)
      discount: Decimal = fields.DecimalField(max_digits=1000, decimal_places=2, default=0.0)
      category: fields.ForeignKeyNullableRelation["Category"] = fields.ForeignKeyField("models.Category", related_name="products", null=True, on_delete="SET    NULL")description: str = fields.TextField(default="")
      slug: str = fields.CharField(max_length=200, unique=True)photo = fields.JSONField(default=[])
      is_active = fields.BooleanField(default=False)
      quantity: int = fields.IntField(default=0)attributes = fields.JSONField()
      updated_at = fields.DatetimeField(auto_now=True)created_at =  fields.DatetimeField(auto_now_add=True)`


GetCategory = pydantic_model_creator(Category, name="Category")
GetOnlyCategory = pydantic_model_creator(Category, name="CategoryForCatalog", exclude=("children.children.children", "children.children.products"))

GetProduct = pydantic_model_creator(Product, name="Product")

and exemple route:

@category_router.get("/{category_id}", response_model=GetOnlyCategory, responses={404: {"model": HTTPNotFoundError}})
async def get_category(category_id: int, user: UserDB = Depends(current_active_user)):
    category = await Category.get(id=category_id)
    return await GetOnlyCategory.from_tortoise_orm(category)

I want to return GetOnlyCategory. But i want see inside Pydantic model in .products = await category.products(is_active=True). How can i do this? Thanks

I try in PydanticMeta computed = ["active_product"] but i not can call await inside method active_product.

I try
@propery
async def active_products(self)

but Pydantic not see this is field.

Help me pls

[Kyle-krn]

I try:

category = await Category.get(id=category_id).prefetch_related(Prefetch('products', queryset=Product.filter(is_active=True)))
    x = await GetOnlyCategory.from_tortoise_orm(category)
    for item in x.products:
        print(item.is_active)

but his retrun Full model:
First print - False
Second print - True