开发者

count values from manytomanyfield

开发者 https://www.devze.com 2023-02-01 17:35 出处:网络
I am trying to count the distinct values from a group of objects that have a manytomanyfield e.g. object article has manytomanyfield of tag objects

I am trying to count the distinct values from a group of objects that have a manytomanyfield

e.g.

object article has manytomanyfield of tag objects


one article has tags "tag1" "tag2"

another article has tags "tag2" "tag3"


I would like开发者_如何学Python to figure out something that would return something along the lines of:

"tag1": 1 "tag2": 2 "tag3": 1

I thought I could do something with articles.objects.all().values('tags') or something but I came up empty.


models.py

class Topping(models.Model):
        name = models.CharField(max_length = 20)

class Pizza(models.Model):
        name = models.CharField(max_length = 20)
        toppings = models.ManyToManyField(Topping)

python manage.py shell

>>> from many_to_many.models import Pizza, Topping
>>> t1 = Topping(name = "T1")
>>> t2 = Topping(name = "T2")
>>> t3 = Topping(name = "T3")
>>> t4 = Topping(name = "T4")
>>> p1 = Pizza(name="P1")
>>> p2 = Pizza(name="P2")


>>> p1.toppings.add(t1)
>>> p1.toppings.add(t2)
>>> p2.toppings.add(t2)
>>> p2.toppings.add(t3)


>>> t2.pizza_set.count() 
    2
>>> t1.pizza_set.count() 
    1


You question is related: How to count and display objects in relation ManyToMany in Django

models.py

class Topping(models.Model):
        name = models.CharField(max_length = 20)

class Pizza(models.Model):
        name = models.CharField(max_length = 20)
        toppings = models.ManyToManyField(Topping)

python manage.py shell

>>> for topping in Topping.objects.all():
...     print topping.name, topping.pizza_set.count()
0

精彩评论

暂无评论...
验证码 换一张
取 消