Merge and sum counts of two annotate django

Question

I have the following two QuerySets

movies_actor=[<Movie: DJango>, <Movie: Paloma de papel>, <Movie: Asu Mare: la película>, <Movie: Mariposa negra>, <Movie: Mañana te cuento>, <Movie: No se lo digas a nadie>]

movies_genres=[<Movie: Dias de Santiago>, <Movie: Ciudad M>, <Movie: DJango>, <Movie: Mariposa negra>, <Movie: No se lo digas a nadie>, <Movie: La Gran Sangre: La Pelicula>, <Movie: La Ciudad y Los Perros>, <Movie: Paloma de papel>]

Each element of the two query sets has the attribute counter. For example movie_actor[0].counter=2. I need to merge and sum this atributte in another QuerySet. Could you help me to obtain that please?

what do you mean by merge? Can you be little more clear? An example would really help — Harkirat Saluja, Apr 14 '16 at 04:53
Seems like you could try this answer http://stackoverflow.com/a/4412293/1816414 — Marco A., Apr 14 '16 at 06:54

score 0 · Answer 1 · edited May 23 '17 at 10:33

0

Following this answer you could first merge your querysets:

    merged_queryset = movies_actor | movies_genres

and then do the aggregation:

    total = merged_queryset.agggregate(Sum('counter'))

I have tried it with similar models on Django 1.8 and it works perfectly.

edited May 23 '17 at 10:33

Community

1
1

answered Apr 22 '16 at 12:57

Marco A.

535
2
10

Tim · Answer 2 · 2016-04-20T07:59:03.643

-1

you can use Aggregation:

sum_movies_actor = movies_actor.aggregate(Sum('counter'))
sum_movies = movies.aggregate(Sum('counter'))
total = sum_movies_actor['counter__sum'] + sum_movies['counter__sum']

edited Apr 20 '16 at 07:59

answered Apr 14 '16 at 07:01

Tim

1,272
11
28

Merge and sum counts of two annotate django

2 Answers2