How to use Q objcts in annotate tortoise

Viewed 89

So simply i have my models Announcement, User, FavoriteAnnouncement

class FavoriteAnnouncement(CoreModel):
    user = fields.ForeignKeyField('models.User', related_name='favorites')
    announcement = fields.ForeignKeyField(
        'models.Announcement',
        related_name='favorites'
    )

i want to add an annotated field is_user_fav : Optional[bool]

I found a soluition in django (

queryset = queryset.annotate(is_user_fav=ExpressionWrapper(
            Q(...),
            output_field=BooleanField(),
        ),)

)

How can i do a similar thing in TortoiseORM ?

0 Answers
Related