select_related Issue

Question

Here are my models:

class Brand(models.Model):
    name         = models.CharField(max_length=30)
    order        = models.SmallIntegerField()

class FeatureGroup(models.Model):
    name         = models.CharField(max_length=30)

class Feature(models.Model):
    name         = models.CharField(max_length=30, blank=True)
    order        = models.SmallIntegerField()
    group        = models.ForeignKey(FeatureGroup)

class FeatureDetail(models.Model):
    description         = models.TextField()
    feature             = models.ForeignKey(Feature)

class Phone(models.Model):
    name         = models.CharField(max_length=30)
    brand        = models.ForeignKey(Brand)
    features     = models.ManyToManyField(FeatureDetail)

I an trying to get features and feature details of the current phone and loop over data pairs but unable to do so.

I tried this and it only works for getting the brand:

p = get_object_or_404(Phone.objects.select_related('brand', 'feature__featuredetail'), id=id)

And when doing:

print p.featuredetail_set.all()

I get and this error:

Django Version: 1.4.3
Exception Type: AttributeError
Exception Value:    
'Phone' object has no attribute 'featuredetail_set'

What's wrong?

Tianissimo · Accepted Answer · 2013-03-03 08:29:39Z

2

You can't use a class name as a parameter to select_related. The parameter must be a string of your model field.

In your case, it should be 'features__feature'

Another problem is that select_related cannot follow many-to-many relationship. That's why prefetch_related comes.

Therefore, your queryset would be:

Phone.objects.select_related('brand').prefetch_related('features__feature')

Note that prefetch_related creates an additional query and does the joining in Python.

answered Mar 3, 2013 at 8:29

Tianissimo

1,2701 gold badge11 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Daniel Roseman · Accepted Answer · 2013-03-02 22:16:48Z

1

Your relation is called features, not featuredetail_set.

Note this has nothing to do with select_related, which does nothing in this case (it only works on forward ForeignKeys, anyway).

answered Mar 2, 2013 at 22:16

Daniel Roseman

602k68 gold badges911 silver badges924 bronze badges

Collectives™ on Stack Overflow

select_related Issue

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related