先设定一个关系模型如下:
- from django.db import models
- class Blog(models.Model):
- name = models.CharField(max_length=100)
- tagline = models.TextField()
- def __str__(self):
- return self.name
-
- class Author(models.Model):
- name = models.CharField(max_length=50)
- email = models.EmailField()
- def __str__(self):
- return self.name
-
- class Entry(models.Model):
- blog = models.ForeignKey(Blog)
- headline = models.CharField(max_length=255)
- body_text = models.TextField()
- authors = models.ManyToManyField(Author)
- def __str__(self):
- return self.headline
上面的数据关系很明晰,Entry中有Blog和Author的外键,如果要在Entry中读取blog和author的数据很容易:
- entry = Entry.objects.all()
- for e in entry:
- blog = e.blog
- author = e.authors
要在Blog和Author中读取Entry也可以:
- blog = Blog.objects.all()
- entry = blog.entry_set.all()
-
- author = Author.objects.all()
- entry = author.entry_set.all()
下面通过entry使blog和author互相读取,比如要知道一个blog的Author只需如下:
- blogs = Blog.objects.all()
- for blog in blogs:
- if blog.name== “我们想要查询的博客的name”
- author = blog. entry_set.authors
要查询一个author的所有blog如下:
- authors = Author.objects.all()
- blogs = []
-
- for author in authors:
- if author.name== “我们想要查询的Author的name”
- for entry in author.entry_set.all():
- blogs.append(entry. blog)