How to make an Inner Join in django?

by

You are probably looking for select_related, which is the natural way to achieve this:

pubs = publication.objects.select_related('country', 'country_state', 'city')

You can check the resulting SQL via str(pubs.query), which should result in output along the following lines (the example is from a postgres backend):

SELECT "publication"."id", "publication"."title", ..., "country"."country_name", ...  
FROM "publication" 
INNER JOIN "country" ON ( "publication"."country_id" = "country"."id" ) 
INNER JOIN "countrystate" ON ( "publication"."countrystate_id" = "countrystate"."id" ) 
INNER JOIN "city" ON ( "publication"."city_id" = "city"."id" )

The returned cursor values are then translated into the appropriate ORM model instances, so that when you loop over these publications, you access the related tables’ values via their own objects. However, these accesses along the pre-selected forward relations will not cause extra db hits:

{% for p in pubs %}
     {{ p.city.city_name}}  # p.city has been populated in the initial query
     # ...
{% endfor %}

More Related Contents:

  1. How do i cast char to integer while querying in django ORM?
  2. Filter by property
  3. Mac OS X – EnvironmentError: mysql_config not found
  4. Setting Django up to use MySQL
  5. How to replace Django’s primary key with a different integer that is unique for that table
  6. MySQL “incorrect string value” error when save unicode string in Django
  7. Install mysql-python (Windows)
  8. Using only the DB part of Django
  9. How to use MySQLdb with Python and Django in OSX 10.6?
  10. Django : Table doesn’t exist
  11. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  12. Error loading MySQLdb Module ‘Did you install mysqlclient or MySQL-python?’
  13. Use Django ORM as standalone [duplicate]
  14. Bulk insert with SQLAlchemy ORM
  15. What is choice_set in this Django app tutorial?
  16. How to run Django’s test database only in memory?
  17. How to filter (or replace) unicode characters that would take more than 3 bytes in UTF-8?
  18. How do you join two tables on a foreign key field using django ORM?
  19. MySQL Improperly Configured Reason: unsafe use of relative path
  20. Using Django database layer outside of Django?
  21. How to move a model between two Django apps (Django 1.7)
  22. Can one use the Django database layer outside of Django?
  23. InterfaceError (0, ”)
  24. Simple Subquery with OuterRef
  25. Using .aggregate() on a value introduced using .extra(select={…}) in a Django Query?
  26. django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
  27. Install mysqlclient for Django Python on Mac OS X Sierra
  28. How to store a dictionary on a Django Model?
  29. Single Django model, multiple tables?
  30. What is PyMySQL and how does it differ from MySQLdb? Can it affect Django deployment?

Leave a Comment