Open oyish opened 2 years ago
post_prefetch = Prefetch(relation='posts', queryset=Post.all().limit(5))
user_posts = await User.all().prefetch_related(post_prefetch)
It's not necessary to use OuterRef
But OuterRef need to case like this
customers = await Customer.all().annotate(
earliest_delivery_time=Subquery(
Order.filter(customer_id=OuterRef('id')).limit(1).values_list('delivery_time')
)
).group_by('earliest_delivery_time')
I can't annotate field from related model by using prefetch
post_prefetch = Prefetch(relation='posts', queryset=Post.all().limit(5)) user_posts = await User.all().prefetch_related(post_prefetch)
This thing does not work by the way. .limit(5) limits prefetch query globally, so you would have only 5 posts for all of your users.
Bumping this issue cause I need to fetch a limited set of related records too, but haven't found a way for this
Is OuterRef
already available in tortoise-orm
or not?
We need it to write better Subquery
using tortoise-orm
?
Is your feature request related to a problem? Please describe. A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]
i need outerref to create prefetch & limit
Describe the solution you'd like A clear and concise description of what you want to happen.
result:
Describe alternatives you've considered A clear and concise description of any alternative solutions or features you've considered.
Additional context Add any other context about the feature request here.