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

0 vote239 views1 answer
Adding bootstrap grid dynamically django
Python Django
0 vote231 views2 answers
Displaying flash message django
Python Django
1 vote242 views1 answer
How to send json in django response
Python Django
0 vote292 views1 answer
HTTP Error 403: Forbidden django using sendgrid
Python Django
4 votes238 views1 answer
Django forms set class
Python Django
0 vote257 views1 answer
Minimal requirements.txt django
Python Django
4 votes221 views3 answers
Flash messages django
Python Django
0 vote254 views2 answers
Create blog in django
Python Django
17 votes230 views6 answers
Django model
Python Django
4 votes250 views2 answers
Django template for range
Python Django