dotty dotty - 1 year ago 104
Python Question

get average from set of objects in django

Hay, i have a simple rating system for a property. You give it a mark out of 5 (stars). The models are defined like this

def Property(models.Model)
# stuff here

def Rating(models.Model)
property = models.ForeignKey(Property)
stars = models.IntegerField()

What i want to do is get a property, find all the Rating objects, collect them, then get the average 'stars' from them.

any ideas how to do this?

Answer Source

You should use Aggregation(doc):

from django.db.models import Avg

p = Property.objects.get(...)
stars_average = p.rating_set.aggregate(Avg('stars')).values()[0]

A little bit unsure about my example though.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download