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 ?