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 vote126 views1 answer
Python pyinstler not found
Python
1 vote102 views1 answer
How to convert character to factor in python
Python
1 vote127 views2 answers
TypeError: list indices must be integers or slices, not str
Python
0 vote100 views1 answer
Funny application in python
Python
8 votes133 views3 answers
Python subtract one list from another
Python
32 votes101 views4 answers
Python pip install matplotlib
Python
51 votes98 views3 answers
What is the rgb value of blue
Python
0 vote108 views2 answers
Django serializer method field read write
Python
8 votes104 views4 answers
Python zip folder
Python
0 vote97 views1 answer
Cumulative percentaile pandas
Python