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 vote370 views1 answer
Django multi column index
Python Django
2 votes344 views2 answers
Django request.data
Python Django
1 vote300 views1 answer
Localhost postgres settings django
Python Django
2 votes381 views3 answers
Django queryset to list
Python Django
1 vote310 views1 answer
Django print settings
Python Django
0 vote350 views1 answer
Django model different schema
Python Django
1 vote332 views1 answer
Django clear db
Python Django
2 votes370 views1 answer
Django static media
Python Django
0 vote412 views1 answer
Request.build_absolute_uri django
Python Django
0 vote364 views1 answer
.comments.all order django
Python Django