Hi, I have a problem with a query and I think it might be a bug.
Lets say I want to get some Entries that have authors from a City.
I use a filter like with authors__city__name='Someville'
The problem is that I get one Entry for every Author that lives in
'Someville' and when one Entry has more than one Author meeting the
condition I get duplicates for the same Entry.
Can somebody please confirm I'm not doing something wrong. I'm on v1.0
final btw.
Thanks a lot.
Below is some example code.
Models::
from django.db import models
class Blog(models.Model):
name = models.CharField(max_length=100)
tagline = models.TextField()
def __unicode__(self):
return self.name
class City(models.Model):
name = models.CharField(max_length=50)
def __unicode__(self):
return self.name
class Author(models.Model):
name = models.CharField(max_length=50)
email = models.EmailField()
city = models.ForeignKey(City)
def __unicode__(self):
return self.name
class Entry(models.Model):
blog = models.ForeignKey(Blog)
headline = models.CharField(max_length=255)
body_text = models.TextField()
pub_date = models.DateTimeField()
authors = models.ManyToManyField(Author)
def __unicode__(self):
return self.headline
Example code::
In [1]: from narf import pru
In [2]: b = pru.models.Blog(name='B', tagline='bb')
In [3]: b.save()
In [4]: ush = pru.models.City(name='Ushuaia')
In [5]: fte = pru.models.City(name='Calafate')
In [6]: ush.save()
In [7]: fte.save()
In [8]: jo = pru.models.Author(name='Jo',
email='j...@example.com', city=ush)
In [9]: jo.save()
In [10]: bob = pru.models.Author(name='Bob',
email='b...@example.com', city=ush)
In [11]: bob.save()
In [12]: e1 = pru.models.Entry(blog=b, headline='1', body_text='11',
pub_date='2009-09-09')
In [13]: e1.save()
In [14]: e1.authors.add(jo)
In [15]: e1.save()
In [16]: e2 = pru.models.Entry(blog=b, headline='2', body_text='22',
pub_date='2009-09-09')
In [17]: e2.save()
In [18]: e2.authors.add(jo)
In [19]: e2.authors.add(bob)
In [20]: e2.save()
In [22]: pru.models.Entry.objects.filter(authors__city__name='Ushuaia')
Out[22]: [<Entry: Entry object>, <Entry: Entry object>, <Entry:
Entry object>]
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
