How do you join two tables on a foreign key field using django ORM?

by

I’ve been working with django for a while now and I have had a pretty rough time figuring out the table joins, but I think I finally understand and I would like to pass this on to others so they may avoid the frustration that I had with it.

Consider the following model.py:

class EventsMeetinglocation(models.Model):
    id = models.IntegerField(primary_key=True)
    name = models.CharField(max_length=100)
    address = models.CharField(max_length=200)

    class Meta:
        managed = True
        db_table="events_meetinglocation"

class EventsBoardmeeting(models.Model):
    id = models.IntegerField(primary_key=True)
    date = models.DateTimeField()
    agenda_id = models.IntegerField(blank=True, null=True)
    location_id = models.ForeignKey(EventsMeetinglocation)
    minutes_id = models.IntegerField(blank=True, null=True)

    class Meta:
       managed = True
       db_table="events_boardmeeting"

Here we can see that location_id in EventsBoardmeeting is a foreign key for the id in EventsMeetinglocation. This means that we should be able to query the information in EventsMeetinglocation by going through EventsBoardmeeting.

Now consider the following views.py:

def meetings(request):
    meetingData = EventsBoardmeeting.objects.all()
    return render(request, 'board/meetings.html', {'data': meetingData })

As stated many times before in may other posts, django takes care of joins automatically. When we query everything in EventsBoardmeeting we also get any related information by foreign key as well, But the way that we access this in html is a little different. We have to go through the variable used as the foreign key to access the information associated with that join. For example:

{% for x in data %}
   {{ x.location_id.name }}
{% endfor %}

The above references ALL of the names in the table that were the result of the join on foreign key. x is essentially the EventsBoardmeeting table, so when we access x.location_id we are accessing the foreign key which gives us access to the information in EventsMeetinglocation.

More Related Contents:

  1. Use Django ORM as standalone [duplicate]
  2. Filter by property
  3. DatabaseError: current transaction is aborted, commands ignored until end of transaction block?
  4. OperationalError: database is locked
  5. Django JSONField inside ArrayField
  6. Using only the DB part of Django
  7. Django connection to postgres by docker-compose
  8. How to set up a PostgreSQL database in Django
  9. Import psycopg2 Library not loaded: libssl.1.0.0.dylib
  10. multiple databases and multiple models in django
  11. Composite primary key in django
  12. How to make/use a custom database function in Django
  13. How to see the raw SQL queries Django is running?
  14. A QuerySet by aggregate field value
  15. sqlite3.OperationalError: unable to open database file
  16. Case insensitive unique model fields in Django?
  17. Django JSONField filtering
  18. How to make an Inner Join in django?
  19. Docker- django throws error while connecting to postgres: psycopg2.OperationalError: could not connect to server: Connection refused
  20. SQLAlchemy: how to filter date field?
  21. How to find pg_config path
  22. Race conditions in django
  23. What is your favorite solution for managing database migrations in django? [closed]
  24. Django ConnectionAbortedError: [WinError 10053] An established connection was aborted by the software in your host machine
  25. django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
  26. What is the default order of a list returned from a Django filter call?
  27. django makemigrations and migrate on heroku server don’t create tables
  28. Deploying Django to Heroku (Psycopg2 Error)
  29. “Failed building wheel for psycopg2” – MacOSX using virtualenv and pip
  30. How to perform filtering with a Django JSONField?

Leave a Comment