2
20. Multiple many-to-many relationships between the same two tables
4
In this example, an ``Article`` can have many "primary" ``Category`` objects
5
and many "secondary" ``Category`` objects.
7
Set ``related_name`` to designate what the reverse relationship is called.
10
from django.db import models
12
class Category(models.Model):
13
name = models.CharField(max_length=20)
17
def __unicode__(self):
20
class Article(models.Model):
21
headline = models.CharField(max_length=50)
22
pub_date = models.DateTimeField()
23
primary_categories = models.ManyToManyField(Category, related_name='primary_article_set')
24
secondary_categories = models.ManyToManyField(Category, related_name='secondary_article_set')
26
ordering = ('pub_date',)
28
def __unicode__(self):
31
__test__ = {'API_TESTS':"""
32
>>> from datetime import datetime
34
>>> c1 = Category(name='Sports')
36
>>> c2 = Category(name='News')
38
>>> c3 = Category(name='Crime')
40
>>> c4 = Category(name='Life')
43
>>> a1 = Article(headline='Area man steals', pub_date=datetime(2005, 11, 27))
45
>>> a1.primary_categories.add(c2, c3)
46
>>> a1.secondary_categories.add(c4)
48
>>> a2 = Article(headline='Area man runs', pub_date=datetime(2005, 11, 28))
50
>>> a2.primary_categories.add(c1, c2)
51
>>> a2.secondary_categories.add(c4)
53
>>> a1.primary_categories.all()
54
[<Category: Crime>, <Category: News>]
56
>>> a2.primary_categories.all()
57
[<Category: News>, <Category: Sports>]
59
>>> a1.secondary_categories.all()
63
>>> c1.primary_article_set.all()
64
[<Article: Area man runs>]
65
>>> c1.secondary_article_set.all()
67
>>> c2.primary_article_set.all()
68
[<Article: Area man steals>, <Article: Area man runs>]
69
>>> c2.secondary_article_set.all()
71
>>> c3.primary_article_set.all()
72
[<Article: Area man steals>]
73
>>> c3.secondary_article_set.all()
75
>>> c4.primary_article_set.all()
77
>>> c4.secondary_article_set.all()
78
[<Article: Area man steals>, <Article: Area man runs>]