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>]