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 vote284 views1 answer
Django model get field verbose name
Python
4 votes279 views2 answers
How to plot two columns graphs in python
Python
0 vote280 views1 answer
Python make an object hashable
Python
0 vote273 views1 answer
DJANGO model instance get by variable
Python Django
0 vote264 views1 answer
CharAt in Python
Python
41 votes330 views6 answers
Check if element in list Python
Python
0 vote272 views2 answers
Friends phoebe
Python
121 votes273 views6 answers
For i in range python
Python
0 vote268 views2 answers
Fun & learn with python turtle
Python
0 vote245 views1 answer
Axes turn of axis matplotlb
Python