How to sum variable in a django model

Asked Sep 10 '21 at 13:51

Active Sep 10 '21 at 15:42

Viewed 96 times

In this example i have the following model in django:

class Test(models.Model):

    name = models.models.ForeignKey('auth.user')
    amount = models.IntegerField()

in this example i have 4 instances:
test1 = Test("John",10)
test2 = Test("John",20)
test3 = Test("Eric, 30)
test4 = Test("Eric, 40)

what i want is to get a list of tuple, with the user and the total sum of amount.

testlist = (("john", 30), ("Eric", 70))

i tried the aggregate method but then i get the total amount of all the instances

asked Sep 10 '21 at 13:51

Sander

2

https://stackoverflow.com/questions/13403609/how-to-group-by-and-aggregate-with-django – Basalex Sep 10 '21 at 14:02
tx, it helped me to the solution, problem solved. – Sander Sep 10 '21 at 14:55

How to sum variable in a django model

0 Answers0