manage.py sql command for django models - Django

python sql django django-models django-manage.py
RadiantHex picture RadiantHex · Nov 22, 2010 · Viewed 8.4k times · Source

just wondering... but is it possible to generate SQL commands for django's models?

e.g. the session model

python manage.py sql django

Any ideas?

Answer

Martin v. Löwis picture Martin v. Löwis · Nov 22, 2010

You need to mention the name of the specific app that comes with django, such as

 python manage.py sql auth
 python manage.py sql admin

I find it a bit clumsy that you can't give fully-qualified names (such as django.contrib.auth), but using just the last part of the name seems to work fine.

Related questions

sql "LIKE" equivalent in django query

What is the equivalent of this SQL statement in django? SELECT * FROM table_name WHERE string LIKE pattern; How do I implement this in django? I tried result = table.objects.filter( pattern in string ) But that did not work. How …

Read More
LEFT JOIN Django ORM

I have the following models: class Volunteer(models.Model): first_name = models.CharField(max_length=50L) last_name = models.CharField(max_length=50L) email = models.CharField(max_length=50L) gender = models.CharField(max_length=1, choices=GENDER_CHOICES) class Department(models.…

Read More
Getting the SQL from a Django QuerySet

How do I get the SQL that Django will use on the database from a QuerySet object? I'm trying to debug some strange behavior, but I'm not sure what queries are going to the database. Thanks for your help.

Read More