Untitled

Django three way join using Foreign Keys
Model:

class Product(models.Model):
    productid = models.IntegerField(primary_key=True, db_column='ProductId')
    productname = models.CharField(max_length=120, db_column='ProductName')

class Testcases(models.Model):
    testcaseid = models.IntegerField(primary_key=True, db_column='TestCaseId')
    testcasename = models.CharField(max_length=240, db_column='TestCaseName')

class Testmatrix(models.Model):
    testmatrixid = models.IntegerField(primary_key=True, db_column='TestMatrixId')
    productid = models.ForeignKey(Product, db_column='ProductId')
    testcaseid = models.ForeignKey(Testcases, db_column='TestCaseId')

class Status(models.Model):
    testmatrixid = models.ForeignKey(Testmatrix, db_column='TestMatrixId')
    title = models.CharField(max_length=240, db_column='Title', blank=True)

View:

from django.shortcuts import render_to_response
from mysite.testmatrix.models import Product, Testcases, Testmatrix, Status

def get_products(request):
    tm = list(Testmatrix.objects.filter(productid='abc'))
    return render_to_response('products.html', {'tm': tm})

Template: (products.html)
{% extends "main.html" %}

{% block body %}
<table>
{% for tm in tm %}
    <tr>
            <td>{{ tm.testmatrixid }}</td>
    <td>{{ tm.testcaseid.testcasename }}</td>
    </tr>
{% endfor %}
</table>
{% endblock %}

class Status(models.Model):
    testmatrixid = models.ForeignKey(Testmatrix, db_column='TestMatrixId', related_name='statuses')

test_matrix.statuses.all()