Django - Get Foreign key objects in single query?
django, foreign-key-relationship, python
Solution
You query `Programme` and assign to `programme`, but you never use the result anywhere. Just remove that line.
Problem
I'm finding django foreign keys a bit confusing, is there any way to do the view below, using a single query? ``` # Model class Programme(models.Model): name = models.CharField(max_length = 64) class Actor(models.Model): programme = models.ForeignKey(Programme) name = models.CharField(max_length = 64) # View def list_actors( request, programme_id): programme = Programme.objects.filter(id = programme_id)[0] actors = Actor.objects.filter(programme = programme_id) json = simplejson.dumps( [{ 'name': str(actor.name), 'rating': str(actor.rating),} for actor in actors] ) return HttpResponse(json, mimetype='application/javascript') ```