Hi. I think the problem is that get is being run before the exclude when you still have two results and fails as it can only handle a single result. In this case you can't use get but should use filter().exclude()[0] to get the result.
On Apr 16, 10:01 pm, zayatzz <alan.kesselm...@gmail.com> wrote: > I need help with making queries. I keep > readinghttp://docs.djangoproject.com/en/dev/ref/models/querysets/http://docs.djangoproject.com/en/dev/topics/db/queries/ > > but neither of those pages has exactly what i want nor explains why i > cant get what i want with existing queries. > > Ill first post existing models here: > > class Trans(models.Model): > keel = models.ForeignKey(lang) > content_type = models.ForeignKey(ContentType) > object_id = models.PositiveIntegerField() > content_object = generic.GenericForeignKey("content_type", > "object_id") > name= models.CharField(max_length=500) > def __unicode__(self): > return unicode(self.name) > > class Poll(models.Model): > name = generic.GenericRelation(Trans) > pub_date = models.DateTimeField('date published') > active = models.BooleanField() > def __unicode__(self): > return unicode(self.name) > > What im trying to achieve with query is to retrieve the actual > translation (from trans model) instead of poll name. > > I wrote model manager for it - > > def tname(self): > q = ContentType.objects.get_for_model(self) > z = Trans.objects.get(content_type__pk=q.id, > object_id=self.id).exclude(keel=2) > t = z.name > return t > > What i fail to understand is how this query can retrieve 2 objects not > one, because i keep getting this error: > > Caught an exception while rendering: get() returned more than one > Trans -- it returned 2! Lookup parameters were {'object_id': 1, > 'content_type__pk': 11} > > Doesnt the exclude work? > > There is 2 translations for each poll. one with language 1 and one > with language 2. > > This also gives me 2 results > z = Trans.objects.filter(poll = self) > q = z.get(keel = 1) > t = q.name > > Error was : Caught an exception while rendering: get() returned more > than one Trans -- it returned 2! Lookup parameters were {'keel': 1} > > What i fail to understand is, that when i use enough filters to filter > results down to 1 - then i cant get .name value from the result, but > when i use get instead of filter i get too many results even though i > use exclude or additional parameters like keel = 1. > > Please help me understand how queries are supposed to work and how can > i get what i want. > > Alan. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
