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

6 votes327 views2 answers
Get_or_create django
Python Django
3 votes391 views1 answer
Django admin prefetch_related
Python Django
14 votes358 views6 answers
Installing django on windows
Python Django
0 vote369 views1 answer
Template tag django
Python Django
5 votes355 views2 answers
Django password field
Python Django
0 vote380 views1 answer
How to log errors while debug is false in django
Python Django
31 votes405 views1 answer
Flask vs django
Python Django
0 vote369 views1 answer
Float number field django models
Python Django
-2 votes363 views1 answer
Django modelform datetime
Python Django
0 vote353 views1 answer
Django admin required decorator
Python Django