Django connection cursor

from django.db import connection
with connection.cursor() as cursor:
  cursor.execute('TRUNCATE TABLE table_name CASCADE')

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

2 votes104 views1 answer
Kivy changing screen in python
Python
0 vote112 views1 answer
Get the list of column names whose data type is float python
Python
0 vote101 views1 answer
Convert the sklearn.dataset cancer to a DataFrame.
Python
95 votes107 views6 answers
Check if string contains python
Python
-1 vote122 views1 answer
Post an image Flask
Python Flask
1 vote110 views1 answer
Python link to jpg
Python
0 vote108 views1 answer
Vreverse all elemetns of a list in place python
Python
1 vote100 views3 answers
How to use variable from another function in python
Python
0 vote110 views2 answers
Bar plot group by pandas
Python
0 vote100 views1 answer
R how to merge data frames
Python