Python Django Unknown Command 'SQL'

Question

I'm following this tutorial http://www.sitepoint.com/building-simple-rest-api-mobile-applications/

I'm trying to run SQL by

$ python manage.py sql fishes

However it says

Unknown Command: 'sql'

If I type

$ python manage.py help

I get this, and SQL doesn't appear in the list.

Available subcommands:

[auth]
    changepassword
    createsuperuser

[django]
    check
    compilemessages
    createcachetable
    dbshell
    diffsettings
    dumpdata
    flush
    inspectdb
    loaddata
    makemessages
    makemigrations
    migrate
    sendtestemail
    shell
    showmigrations
    sqlflush
    sqlmigrate
    sqlsequencereset
    squashmigrations
    startapp
    startproject
    test
    testserver

[sessions]
    clearsessions

[staticfiles]
    collectstatic
    findstatic
    runserver

Yes, indeed that command does not exist any more. You should use a more up-to-date tutorial. — Daniel Roseman
– Daniel Roseman, Commented Mar 17, 2016 at 16:38
The tutorial says "Run python manage.py sql fishes to see a preview", so you can probably just ignore that line and carry on the tutorial. It's a good idea to find a more up-to-date tutorial anyway - there might be other things that don't work if you are using a different version of Django to the tutorial. — Alasdair
– Alasdair, Commented Mar 17, 2016 at 16:54

Jmons · Accepted Answer · 2016-03-17 16:50:33Z

3

Unfortunately that doesn't exist any more, however the command manage.py dbshell does.

Generally speaking however, you should try to use models, with load_data etc to preserve the data integrity (as validations etc may happen in models rather then relying on underlying data bits). Or write management commands for any clean up tasks.

answered Mar 17, 2016 at 16:50

Jmons

1,81618 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Naveen Kumar M · Accepted Answer · 2018-01-16 07:49:50Z

0

Yes it is possible, using the inspectdb command:

python manage.py inspectdb

or

python manage.py inspectdb > models.py

to get them in into the file

This will look at the database configured in your settings.py and outputs model classes to standard output.

As Ignacio pointed out, there is a guide for your situation in the documentation.

Source : link

answered Jan 16, 2018 at 7:49

Naveen Kumar M

7,5577 gold badges64 silver badges76 bronze badges

Collectives™ on Stack Overflow

Python Django Unknown Command 'SQL'

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related