Django query for vendors who supply all parts -

given model (vendors supplying parts, many-to-many relation):

from django.db import models  class part(models.model):     pass  class vendor(models.model):     name = models.charfield(max_length=100)     parts = models.manytomanyfield(part)     def __str__(self):         return "%s" % self.name 

is possible write django query vendors supply of parts? i'm interested in query produce single sql statement.

---

for example, following data:

p1 = part() p2 = part() p3 = part() v1 = vendor(name="supply nothing") v2 = vendor(name="supply parts") v3 = vendor(name="supply parts") p1.save() p2.save() p3.save() v1.save() v2.save() v3.save() v2.parts.add(p1,p2) v3.parts.add(p1,p2,p3) 

i want get:

[<vendor: supply parts>] 

you first query parts:

parts = part.objects.all() 

and filter vendors:

vendors = vendor.objects.filter(parts=parts)