Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I access the properties of a many-to-many "through" table from a django template?

From the Django documentation...

When you're only dealing with simple many-to-many relationships such as mixing and matching pizzas and toppings, a standard ManyToManyField is all you need. However, sometimes you may need to associate data with the relationship between two models.

For example, consider the case of an application tracking the musical groups which musicians belong to. There is a many-to-many relationship between a person and the groups of which they are a member, so you could use a ManyToManyField to represent this relationship. However, there is a lot of detail about the membership that you might want to collect, such as the date at which the person joined the group.

For these situations, Django allows you to specify the model that will be used to govern the many-to-many relationship. You can then put extra fields on the intermediate model. The intermediate model is associated with the ManyToManyField using the through argument to point to the model that will act as an intermediary. For our musician example, the code would look something like this:

class Person(models.Model):     name = models.CharField(max_length=128)      def __unicode__(self):         return self.name  class Group(models.Model):     name = models.CharField(max_length=128)     members = models.ManyToManyField(Person, through='Membership')      def __unicode__(self):         return self.name  class Membership(models.Model):     person = models.ForeignKey(Person)     group = models.ForeignKey(Group)     date_joined = models.DateField()     invite_reason = models.CharField(max_length=64) 

Now that you have set up your ManyToManyField to use your intermediary model (Membership, in this case), you're ready to start creating some many-to-many relationships. You do this by creating instances of the intermediate model:

ringo = Person.objects.create(name="Ringo Starr") paul = Person.objects.create(name="Paul McCartney") beatles = Group.objects.create(name="The Beatles")  m1 = Membership(person=ringo, group=beatles, ...     date_joined=date(1962, 8, 16), ...     invite_reason= "Needed a new drummer.")  m1.save()  beatles.members.all() [<Person: Ringo Starr>]  ringo.group_set.all() [<Group: The Beatles>]  m2 = Membership.objects.create(person=paul, group=beatles, ...     date_joined=date(1960, 8, 1), ...     invite_reason= "Wanted to form a band.")  beatles.members.all() [<Person: Ringo Starr>, <Person: Paul McCartney>] 

source: http://docs.djangoproject.com/en/dev/topics/db/models/#intermediary-manytomany

My question is, how do I set up my view and template to access these additional attributes. Say I have a band page and I want to display the band name, iterate through the membership records and display names and date_joined.

Should I pass a band object to the template? Or do I pass the membership objects somehow?

And how would I create the for loops in in the template?

Thanks.

like image 594
Alex Avatar asked Jul 30 '10 02:07

Alex


People also ask

How is many-to-many field stored in Django?

To store a many to many relationship the database creates a third table which stores the ids of the objects. So if you want to relate a user to a folder as a many to many relationship, both of them should have their own ids before they can be related as many to many.

What is Forloop counter in Django?

Django for loop counter All the variables related to the counter are listed below. forloop. counter: By using this, the iteration of the loop starts from index 1. forloop. counter0: By using this, the iteration of the loop starts from index 0.

What {% include %} does in Django?

From the documentation: {% extends variable %} uses the value of variable. If the variable evaluates to a string, Django will use that string as the name of the parent template. If the variable evaluates to a Template object, Django will use that object as the parent template.


Video Answer


1 Answers

The easiest way is just to pass the band to the template. Templates are capable of navigating the relationships between models and there is both members and membership_set queryset managers on Group. So here is how I would do it:

view:

def group_details(request, group_id):     group = get_object_or_404(Group, pk=group_id)     return render_to_response('group_details.html',                               {'group': group}) 

template:

<h2>{{ group.name }}</h2> {% for membership in group.membership_set.all %}     <h3>{{ membership.person }}</h3>     {{ membership.date_joined }} {% endfor %} 
like image 168
Rory Hart Avatar answered Sep 24 '22 02:09

Rory Hart