Django中的外键反向导航(Foreign key backward navigation in Django)
对于这个例子:
class Blog(models.Model): name = models.CharField(max_length=100) tagline = models.TextField() def __unicode__(self): return self.name class Author(models.Model): name = models.CharField(max_length=50) email = models.EmailField() def __unicode__(self): return self.name class Entry(models.Model): blog = models.ForeignKey(Blog, related_name='entries') headline = models.CharField(max_length=255) body_text = models.TextField() pub_date = models.DateTimeField() mod_date = models.DateTimeField() authors = models.ManyToManyField(Author) n_comments = models.IntegerField() n_pingbacks = models.IntegerField() rating = models.IntegerField() def __unicode__(self): return self.headline那么,如何查找所有带有条目的博客?
我想做这样的事情
q = Blog.objects.all().entries.filter(...)但它给了我一个错误。 那么Django只支持将后向导航属性仅用于一个对象而不是一组对象吗?
For this example:
class Blog(models.Model): name = models.CharField(max_length=100) tagline = models.TextField() def __unicode__(self): return self.name class Author(models.Model): name = models.CharField(max_length=50) email = models.EmailField() def __unicode__(self): return self.name class Entry(models.Model): blog = models.ForeignKey(Blog, related_name='entries') headline = models.CharField(max_length=255) body_text = models.TextField() pub_date = models.DateTimeField() mod_date = models.DateTimeField() authors = models.ManyToManyField(Author) n_comments = models.IntegerField() n_pingbacks = models.IntegerField() rating = models.IntegerField() def __unicode__(self): return self.headlineSo, how to find all Blogs with its Entries?
I want to do something like this
q = Blog.objects.all().entries.filter(...)But it gave me an error. So does Django only supports to use the backward navigation properties for only one object rather than a set of objects?
最满意答案
假设您要过滤所有博客的条目,并获取您需要的条目的博客:
Blog.objects.filter(entry__headline__icontains="cats").distinct()这里有一个博客到多个条目的关系,但是此查询有效并且为您提供了标题中包含猫的条目的博客。
Let's say you want to filter on the entries of all blogs, and get the blogs that have entries you require:
Blog.objects.filter(entry__headline__icontains="cats").distinct()There is a one blog to many entries relationship here, but this query works and gives you the blogs that have entries with cats in headlines.
更多推荐
发布评论