Reputation: 2248
I need to get a single model object based on a set of fields one of which is a ForeignKey
. So if I have the following models:
class Composer(models.Model):
name = models.CharField()
dates = models.CharField()
nationality = models.CharField()
period = models.CharField()
class Symphony(models.Model):
composer = models.ForeignKey('Composer', related_name="symphonies", null=True)
date = models.CharField()
key = models.CharField()
number = models.IntegerField()
num_movements = models.IntegerField()
how can I then retrieve a specific Symphony
object based on its composer
and number
fields? I originally had composer as a simple models.CharField()
, so I could just do:
Symphony.objects.get(composer='Bruckner', number=7)
So how do I do the equivalent using a ForeignKey
?
Upvotes: 1
Views: 3073