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 votes118 views1 answer
Pychamrfind and replace
Python
1 vote119 views1 answer
Get a column that corresponds to the average of two columns pandas
Python
0 vote126 views2 answers
Unpacking tuples in python
Python
1 vote128 views1 answer
How to read hdf5 file in python
Python
3 votes134 views2 answers
Python execute bat file
Python
28 votes139 views2 answers
Python date add days
Python
0 vote138 views1 answer
List of words from a string and filter them based on a secondary list
Python
0 vote144 views1 answer
Python inject into process
Python
1 vote148 views1 answer
Punctuation list python
Python
11 votes146 views6 answers
Append a list to a list python
Python