RadiantHex
RadiantHex

Reputation: 25597

manage.py sql command for django models - Django

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?

Upvotes: 3

Views: 9334

Answers (2)

Joe Jasinski
Joe Jasinski

Reputation: 10811

This is no longer possible with django migrations (django>=1.7). The sql management command is no longer available.

Though it operates slightly differently, the sqlmigrate management command can be used to find the sql commands for individual migrations.

./manage.py sqlmigrate auth  0001
./manage.py sqlmigrate auth  0002
...

Upvotes: 2

Martin v. Löwis
Martin v. Löwis

Reputation: 127567

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.

Upvotes: 8

Related Questions