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 vote130 views1 answer
Python Django Models Unique Rows
Python Django
0 vote100 views1 answer
1 12 123 python
Python
0 vote102 views1 answer
How to implement ctrl + C in terminal by using code
Python
0 vote104 views2 answers
%Y-%m-%dT%H:%M:%SZ convert to date time object
Python
0 vote92 views1 answer
Cast image to float32
Python
3 votes94 views4 answers
Install tensorflow gpu
Python
0 vote110 views1 answer
Couldn't recognize data in image file
Python
0 vote102 views1 answer
How do i add new items to a dictionary within a for loop python
Python
9 votes108 views2 answers
How to delete specific char in string python
Python
2 votes88 views1 answer
Replacing spaces in a string python
Python