Breaking News: Grepper is joining You.com. Read the official announcement!

How can I see the raw SQL queries Django

Add Answer

visualscrapper answered on June 1, 2020 Popularity 10/10 Helpfulness 1/10

answer How can I see the raw SQL queries Django

related django orm raw sql

related raw query in django

How can I see the raw SQL queries Django

Comment

-1

$ python manage.py sqlmigrate <app_name> <migration_number>

#Ex: $ python manage.py sqlmigrate polls 0001
# It will show the sql quires of specific migrations

Popularity 10/10 Helpfulness 1/10 Language shell

Source: Grepper

Tags: django raw shell sql

Link to this answer
Share Copy Link

Contributed on Jul 23 2021

visualscrapper

0 Answers Avg Quality 2/10

Closely Related Answers

django orm raw sql

Comment

>>> from django.db import connection
>>> cursor = connection.cursor()
>>> cursor.execute('''SELECT count(*) FROM people_person''')
1L
>>> row = cursor.fetchone()
>>> print row
(12L,)
>>> Person.objects.all().count()
12

Popularity 10/10 Helpfulness 5/10 Language sql

Source: stackoverflow.com

Tags: django-orm d

Link to this answer
Share Copy Link

Contributed on Jul 28 2022

Obedient Osprey

0 Answers Avg Quality 2/10

raw query in django

Comment

-1

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

Popularity 10/10 Helpfulness 4/10 Language python

Source: stackoverflow.com

Tags: django dj

Link to this answer
Share Copy Link

Contributed on Jun 01 2020

Fancy Flatworm

0 Answers Avg Quality 2/10

How can I see the raw SQL queries Django

Contents

More Related Answers

How can I see the raw SQL queries Django

Closely Related Answers

django orm raw sql

raw query in django

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.