Django create same query in several tables

Question

I'm doing the same query for 3 tables and then the all together. But I feel that I am consuming a lot of resources that way since they are a bit complex queries, I would like to be able to create a single query for all three tables, is this possible in Django?

I know that in SQLALCHEMY there is something similar:

SQLAlchemy How to joiun several tables by one query

Code:

# Review Dish
recent_dish_review = restaurant.models.DishReview. \
                               objects.filter(user_id__in=id_follows,
                                              created_at__lte=timezone.now(),
                                              created_at__gte=days
                                              ).order_by('-created_at')[:limit]

# Review Restaurant
recent_restaurant_review = restaurant.models.RestaurantReview. \
                               objects.filter(user_id__in=id_follows,
                                              created_at__lte=timezone.now(),
                                              created_at__gte=days
                                              ).order_by('-created_at')[:limit]

# User Like Dish
recent_like_dish = restaurant.models.DishesLikes. \
                               objects.filter(foodie_id__in=id_follows,
                                              created_at__lte=timezone.now(),
                                              created_at__gte=days
                                              ).order_by('-created_at')[:limit]

return list(sorted(chain(recent_restaurant_review, recent_dish_review, recent_like_dish))

Neeraj Kumar · Accepted Answer · 2017-06-15 19:10:36Z

1

Use zip method of python.

single_queryset = zip(recent_restaurant_review, recent_dish_review, recent_like_dish)
return single_queryset

Note: All queryset should have same count of objects in each.

You can iterate zip queryset like below:

form restaurant, dish, like in single_queryset:
    print restaurant, dish, like

answered Jun 15, 2017 at 19:10

Neeraj Kumar

3,9612 gold badges23 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Django create same query in several tables

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related