Each Answer to this Q is separated by one/two green lines.
I have :
class Award(models.Model) : name = models.CharField(max_length=100, db_index=True) class Alias(models.Model) : awards = models.ManyToManyField('Award', through="Achiever") class Achiever(models.Model): award = models.ForeignKey(Award) alias = models.ForeignKey(Alias) count = models.IntegerField(default=1)
How can I have an
Alias which has all its
>>> db.reset_queries() >>> Alias.objects.filter(id="450867").select_related("achiever_set__award").get().achiever_set.all().award.name u'Perma-Peddle' >>> len(db.connection.queries) 3 >>> db.reset_queries() >>> Alias.objects.filter(id="450867").select_related("awards").get().awards.all().name u'Dwarfageddon (10 player)' >>> len(db.connection.queries) 2
I’m going to need a lot of access to the award that an alias has already gotten (both the intermediate table and the awards themselves). How can I batch all of these?
If you’re not on Django 1.4, there’s also the django-batch-select library, which works basically the same way as prefetch_related.