[ACCEPTED]-Generate Database Schema using Python-schema

Accepted answer

Score: 14

If your talking about needing to see the 5 SQL schema, run ./manage.py sqlall <appname>

If you want a visualisation 4 of the schema you can get django-extensions and run ./manage.py graph_models -a -g -o my_project.png. This 3 will produce a pretty schema graph for you, but 2 generally omits border conditions. you may 1 want to check the options to add more data. http://readthedocs.org/docs/django-extensions/en/latest/graph_models.html

Score: 5

manage.py sql <appname appname ...> (docs)

Score: 2

Using Your DB

As mentioned in the tutorial, you can use your database's 7 command line client to get the schema.

Example 6 using sqlite:

python manage.py dbshell
> .schema

You may need to install sqlite3 5 for this to work.

Using Django

You used to be able to 4 use python manage.py sql ..., but it has been deprecated in 1.9 3 in favor of migrations. You can check out 2 the initial migration scripts using:

python manage.py sqlmigrate myapp 0001_initial

(From 1 Answer: Equivalent of sqlall in Django 1.9?)

Source: stackoverflow.com

fetch column names for specific table

Is there a performance decrease if there are too many columns in a table?

Changing schemas in mongoDB/mongoose

intellij idea data sources doesn't see existing table in the database

Schema for music lists + playlists web app

Plot tables and relationships from Postgresql tables

Max length of "tzname" field / timezone identifier name

Many tables or rows, which one is more efficient in SQL?

Validate dicts in Python

add_column for references (Rails)

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.