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 django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
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/f9efbb30-9065-410d-b46b-55e2d8f1271c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
