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

1 vote363 views1 answer
How to get input in python3
Python
0 vote377 views1 answer
Pandas: How to Drop Rows that Contain a Specific String
Python
2 votes327 views1 answer
How to change windows icon tkinter
Python
51 votes347 views6 answers
Pickle load
Python
0 vote357 views1 answer
Convert \x unicode utf 8 bytes to \u python
Python
20 votes356 views5 answers
Join lists python
Python
1 vote353 views1 answer
Python code to plot pretty figures
Python
1 vote330 views1 answer
Add directory to pythonpath(in ~/.bashrc
Python
0 vote331 views1 answer
Django import settings variables
Python
0 vote365 views1 answer
Django-filter field name greater than
Python Django