开发者

Is there a DESCRIBE function for Django Models?

I want to know the columns in a table. Is there a开发者_如何学JAVA DESCRIBE table; in django?


You can use model._meta.get_all_field_names() to get a list of all the fields in a model class.


You can use ./manage.py sqlall <app name> to print the SQL used to create the table for a given app. For the tutorial project's polls app the output is:

tutorial% ./manage.py sqlall polls
BEGIN;
CREATE TABLE "polls_poll" (
    "id" integer NOT NULL PRIMARY KEY,
    "question" varchar(200) NOT NULL,
    "pub_date" datetime NOT NULL
)
;
CREATE TABLE "polls_choice" (
    "id" integer NOT NULL PRIMARY KEY,
    "poll_id" integer NOT NULL REFERENCES "polls_poll" ("id"),
    "choice" varchar(200) NOT NULL,
    "votes" integer NOT NULL
)
;
CREATE INDEX "polls_choice_763e883" ON "polls_choice" ("poll_id");
COMMIT;

Which you might find useful.


The easiest way I found is to use print Class.__doc__, for example:

>>> from network.models import Network
>>> print Network.__doc__
Network(id, network, name, location)


You can also browse your models' fields and documentation through the admindocs app ( https://docs.djangoproject.com/en/dev/ref/contrib/admin/admindocs/ ) :

Django’s admindocs app pulls documentation from the docstrings of models, views, template tags, and template filters for any app in INSTALLED_APPS and makes that documentation available from the Django admin.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜