How to get ForeignKey value for specific field in Django view

Question

I have two models defined in my models.py:

class model1(models.Model):
    name = models.CharField(max_length=100, unique=True)
    desc = models.CharField(max_length=1000, blank=True, null=True)

    def __unicode__(self):
        return u'ID: %s, name - %s, description - %s' % (str(self.pk), self.name, self.desc)

class model2(models.Model):
    description = models.CharField(max_length=500, blank=True, null=True)
    repo_id = models.ForeignKey(model1, to_field='id', db_column="repo_id", null=False)
    content = models.TextField(blank=True)

    def __unicode__(self):
        return u'ID: %s, rpt_repo_id - %s, created_date - %s' % (str(self.pk), str(self.repo_id.pk), self.created_date)

I want to query from model2 to fetch name from model1 where id(pk) of model1 is value from rpt_repo_id of model2. Below query doesn't work here:

saved_reports = models.model2.objects.all()

Although {{ repo_id.name }} works fine in html.

Answer 1

You use the same technique in your view, as you did in your template:

saved_reports = model2.objects.all()
for report in saved_reports:
    print('ID: {} Name: {}'.format(report.repo_id.pk, report.repo_id.name))

If you know the id of the model1 object, and want to use that to fetch the model2 object:

model2.objects.filter(repo_id__pk=1)

Django automatically creates reverse relationships for foreign keys. This means that if you have a model1 object, you can get its related model2 object, even if you only defined the foreign key in the model2 object:

model1.objects.get(pk=1).model2_set.all()  # Fetch me all model2 for this model1