Hello Mauro,
The following should do
from django.db.models import F
Movimento.objects.values(
'anno','impianto'
).annotate(
dare=Sum('dare),
avere=Sum('avere),
diff=Sum(F('dare') - F('avere)),
)
Cheers,
Simon
Le mercredi 29 mars 2017 16:19:37 UTC-4, Mauro Ziliani a écrit :
>
> Hi all.
> My name's Mauro and I working on a DB (SQLite3 now and Postgres in the
> future).
>
> I have a table Movimento with the fields
> anno integer,impianto integer,dare decimal(10,2),avere decimal(10,2)
>
> BY hands I can run
>
> SELECT anno,impianto, sum(dare), sum(avere) FROM movimento
> GROUP BY anno,impianto
> ORDER BY anno,impianto
>
> With django Api I write
>
> Movimento.objects.values('anno','impianto').annotate(dare=Sum('dare),
> avere=Sum('avere))
>
> And I get the same beaviour.
>
> Now I need to translate the following SQL script
>
> SELECT anno,impianto, sum(dare), sum(avere), sum(dare-avere)
> FROM movimento
> GROUP BY anno,impianto
> ORDER BY anno,impianto
>
> into django API queryset.
>
> Is it possible todo this in one row?
>
> Cna you give me some idea to solve this translaion?
>
> Finally I'll render the results into a table.
>
> Best regards,
> MZ
>
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/9c8f43e7-6d84-4190-9dbc-beb25b3e1a95%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
