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 vote235 views1 answer
Python set workdir
Python
15 votes223 views3 answers
Max int python
Python
0 vote256 views1 answer
How to use str()
Python
1 vote230 views1 answer
Get self file name in python
Python
39 votes230 views3 answers
Increase figure size in matplotlib
Python
0 vote233 views1 answer
Oversampling using smote
Python
0 vote236 views1 answer
Python set with counts
Python
1 vote227 views1 answer
How to make a breakable loop in python
Python
0 vote234 views1 answer
Opencv write text
Python
4 votes233 views2 answers
Python soup get href
Python