Raw query in django

from django.db import connection

sql = 'SELECT * FROM db1.a AS a
       JOIN db2.b AS b 
       ON b.some_id = a.id
       WHERE a.name = %s'
cursor = connection.cursor()
try:
      cursor.execute(sql, ['localhost'])
      row = cursor.fetchall()
except Exception as e:
      cursor.close

-1

Source: stackoverflow.com

Similar codes

5 votes233 views2 answers
How to reset username and password in django admin
Python Django
0 vote250 views1 answer
Django.core.exceptions.FieldError: 'date' cannot be specified for Forum model form as it is a non-editable field
Python Django
23 votes255 views2 answers
Django rest
Python Django
5 votes252 views2 answers
Django admin password reset
Python Django
0 vote233 views1 answer
Django select_related multiple
Python Django
1 vote244 views1 answer
Radiobuttons django
Python Django
11 votes234 views2 answers
How to add static files in django
Python Django
14 votes250 views5 answers
How to create requirements.txt django
Python Django
0 vote240 views1 answer
Validationerror django params
Python Django
5 votes261 views2 answers
Django connexion session time
Python Django