Django 提供第三方包 django-extensions
,可以用来将 Django 中的 Models 生成 E-R 图。
1 安装包
pip install django-extensions
2 配置
在 Django settings.py 文件, INSTALLED_APPS
中添加 django_extensions
INSTALLED_APPS = (
'django_extensions',
)
3 生成 dot 文件和 png 图片
- 生成全部 model 的 E-R 图
python manage.py graph_models -a > all.dot
- 单独某个 Django App (以
django_view_permission
为例) 生成 dot 文件
python manage.py graph_models django_view_permission > django_view_permission.dot
导出的 dot 内容如下:django_view_permission.dot
digraph model_graph {
// Dotfile by Django-Extensions graph_models
// Created: 2018-03-03 14:55
// Cli Options: django_view_permission
fontname = "Helvetica"
fontsize = 8
splines = true
node [
fontname = "Helvetica"
fontsize = 8
shape = "plaintext"
]
edge [
fontname = "Helvetica"
fontsize = 8
]
// Labels
django_view_permission_models_CommonElement [label=<
<TABLE BGCOLOR="palegoldenrod" BORDER="0" CELLBORDER="0" CELLSPACING="0">
<TR><TD COLSPAN="2" CELLPADDING="4" ALIGN="CENTER" BGCOLOR="olivedrab4">
<FONT FACE="Helvetica Bold" COLOR="white">
CommonElement
</FONT></TD></TR>
<TR><TD ALIGN="LEFT" BORDER="0">
<FONT COLOR="#7B7B7B" FACE="Helvetica ">create_time</FONT>
</TD><TD ALIGN="LEFT">
<FONT COLOR="#7B7B7B" FACE="Helvetica ">DateTimeField</FONT>
</TD></TR>
<TR><TD ALIGN="LEFT" BORDER="0">
<FONT COLOR="#7B7B7B" FACE="Helvetica ">doc</FONT>
</TD><TD ALIGN="LEFT">
<FONT COLOR="#7B7B7B" FACE="Helvetica ">TextField</FONT>
</TD></TR>
<TR><TD ALIGN="LEFT" BORDER="0">
<FONT COLOR="#7B7B7B" FACE="Helvetica ">update_time</FONT>
</TD><TD ALIGN="LEFT">
<FONT COLOR="#7B7B7B" FACE="Helvetica ">DateTimeField</FONT>
</TD></TR>
</TABLE>
>]
django_view_permission_models_View [label=<
<TABLE BGCOLOR="palegoldenrod" BORDER="0" CELLBORDER="0" CELLSPACING="0">
<TR><TD COLSPAN="2" CELLPADDING="4" ALIGN="CENTER" BGCOLOR="olivedrab4">
<FONT FACE="Helvetica Bold" COLOR="white">
View<BR/><<FONT FACE="Helvetica Italic">CommonElement</FONT>>
</FONT></TD></TR>
<TR><TD ALIGN="LEFT" BORDER="0">
<FONT FACE="Helvetica Bold">id</FONT>
</TD><TD ALIGN="LEFT">
<FONT FACE="Helvetica Bold">AutoField</FONT>
</TD></TR>
<TR><TD ALIGN="LEFT" BORDER="0">
<FONT COLOR="#7B7B7B" FACE="Helvetica Italic">create_time</FONT>
</TD><TD ALIGN="LEFT">
<FONT COLOR="#7B7B7B" FACE="Helvetica Italic">DateTimeField</FONT>
</TD></TR>
<TR><TD ALIGN="LEFT" BORDER="0">
<FONT COLOR="#7B7B7B" FACE="Helvetica Italic">doc</FONT>
</TD><TD ALIGN="LEFT">
<FONT COLOR="#7B7B7B" FACE="Helvetica Italic">TextField</FONT>
</TD></TR>
<TR><TD ALIGN="LEFT" BORDER="0">
<FONT COLOR="#7B7B7B" FACE="Helvetica ">func</FONT>
</TD><TD ALIGN="LEFT">
<FONT COLOR="#7B7B7B" FACE="Helvetica ">CharField</FONT>
</TD></TR>
<TR><TD ALIGN="LEFT" BORDER="0">
<FONT COLOR="#7B7B7B" FACE="Helvetica ">module</FONT>
</TD><TD ALIGN="LEFT">
<FONT COLOR="#7B7B7B" FACE="Helvetica ">CharField</FONT>
</TD></TR>
<TR><TD ALIGN="LEFT" BORDER="0">
<FONT COLOR="#7B7B7B" FACE="Helvetica ">name</FONT>
</TD><TD ALIGN="LEFT">
<FONT COLOR="#7B7B7B" FACE="Helvetica ">CharField</FONT>
</TD></TR>
<TR><TD ALIGN="LEFT" BORDER="0">
<FONT COLOR="#7B7B7B" FACE="Helvetica Italic">update_time</FONT>
</TD><TD ALIGN="LEFT">
<FONT COLOR="#7B7B7B" FACE="Helvetica Italic">DateTimeField</FONT>
</TD></TR>
</TABLE>
>]
django_view_permission_models_ViewSet [label=<
<TABLE BGCOLOR="palegoldenrod" BORDER="0" CELLBORDER="0" CELLSPACING="0">
<TR><TD COLSPAN="2" CELLPADDING="4" ALIGN="CENTER" BGCOLOR="olivedrab4">
<FONT FACE="Helvetica Bold" COLOR="white">
ViewSet<BR/><<FONT FACE="Helvetica Italic">CommonElement</FONT>>
</FONT></TD></TR>
<TR><TD ALIGN="LEFT" BORDER="0">
<FONT FACE="Helvetica Bold">id</FONT>
</TD><TD ALIGN="LEFT">
<FONT FACE="Helvetica Bold">AutoField</FONT>
</TD></TR>
<TR><TD ALIGN="LEFT" BORDER="0">
<FONT COLOR="#7B7B7B" FACE="Helvetica Italic">create_time</FONT>
</TD><TD ALIGN="LEFT">
<FONT COLOR="#7B7B7B" FACE="Helvetica Italic">DateTimeField</FONT>
</TD></TR>
<TR><TD ALIGN="LEFT" BORDER="0">
<FONT COLOR="#7B7B7B" FACE="Helvetica Italic">doc</FONT>
</TD><TD ALIGN="LEFT">
<FONT COLOR="#7B7B7B" FACE="Helvetica Italic">TextField</FONT>
</TD></TR>
<TR><TD ALIGN="LEFT" BORDER="0">
<FONT FACE="Helvetica ">name</FONT>
</TD><TD ALIGN="LEFT">
<FONT FACE="Helvetica ">CharField</FONT>
</TD></TR>
<TR><TD ALIGN="LEFT" BORDER="0">
<FONT COLOR="#7B7B7B" FACE="Helvetica Italic">update_time</FONT>
</TD><TD ALIGN="LEFT">
<FONT COLOR="#7B7B7B" FACE="Helvetica Italic">DateTimeField</FONT>
</TD></TR>
</TABLE>
>]
django_view_permission_models_ViewPermission [label=<
<TABLE BGCOLOR="palegoldenrod" BORDER="0" CELLBORDER="0" CELLSPACING="0">
<TR><TD COLSPAN="2" CELLPADDING="4" ALIGN="CENTER" BGCOLOR="olivedrab4">
<FONT FACE="Helvetica Bold" COLOR="white">
ViewPermission<BR/><<FONT FACE="Helvetica Italic">CommonElement</FONT>>
</FONT></TD></TR>
<TR><TD ALIGN="LEFT" BORDER="0">
<FONT FACE="Helvetica Bold">id</FONT>
</TD><TD ALIGN="LEFT">
<FONT FACE="Helvetica Bold">AutoField</FONT>
</TD></TR>
<TR><TD ALIGN="LEFT" BORDER="0">
<FONT COLOR="#7B7B7B" FACE="Helvetica Italic">create_time</FONT>
</TD><TD ALIGN="LEFT">
<FONT COLOR="#7B7B7B" FACE="Helvetica Italic">DateTimeField</FONT>
</TD></TR>
<TR><TD ALIGN="LEFT" BORDER="0">
<FONT COLOR="#7B7B7B" FACE="Helvetica Italic">doc</FONT>
</TD><TD ALIGN="LEFT">
<FONT COLOR="#7B7B7B" FACE="Helvetica Italic">TextField</FONT>
</TD></TR>
<TR><TD ALIGN="LEFT" BORDER="0">
<FONT COLOR="#7B7B7B" FACE="Helvetica Italic">update_time</FONT>
</TD><TD ALIGN="LEFT">
<FONT COLOR="#7B7B7B" FACE="Helvetica Italic">DateTimeField</FONT>
</TD></TR>
</TABLE>
>]
// Relations
django_view_permission_models_View -> django_view_permission_models_CommonElement
[label="abstract\ninheritance"] [arrowhead=empty, arrowtail=none, dir=both];
django_view_permission_models_ViewSet -> django_view_permission_models_View
[label="views (viewset)"] [arrowhead=dot arrowtail=dot, dir=both];
django_view_permission_models_ViewSet -> django_view_permission_models_CommonElement
[label="abstract\ninheritance"] [arrowhead=empty, arrowtail=none, dir=both];
account_models_BkUser [label=<
<TABLE BGCOLOR="palegoldenrod" BORDER="0" CELLBORDER="0" CELLSPACING="0">
<TR><TD COLSPAN="2" CELLPADDING="4" ALIGN="CENTER" BGCOLOR="olivedrab4">
<FONT FACE="Helvetica Bold" COLOR="white">BkUser</FONT>
</TD></TR>
</TABLE>
>]
django_view_permission_models_ViewPermission -> account_models_BkUser
[label="users (viewpermission)"] [arrowhead=dot arrowtail=dot, dir=both];
django_view_permission_models_ViewPermission -> django_view_permission_models_View
[label="views (viewpermission)"] [arrowhead=dot arrowtail=dot, dir=both];
django_view_permission_models_ViewPermission -> django_view_permission_models_ViewSet
[label="views_set (viewpermission)"] [arrowhead=dot arrowtail=dot, dir=both];
django_view_permission_models_ViewPermission -> django_view_permission_models_CommonElement
[label="abstract\ninheritance"] [arrowhead=empty, arrowtail=none, dir=both];
}
生成后的文件我没有找到在哪里,就自己建了同名的文件,输入了控制台输出的内容
如果有知道的,欢迎评论区告诉我,或者私信我,不胜感谢
- 生成图片
由于生成的是 dot 格式的图片描述文件,需要使用工具进行转换成常用的 PNG 格式图片。可以下载 graphviz ,并将 /bin/dot.exe 加入系统 PATH 中(安装的时候有添加环境变量提示,勾选即可)。
dot -Tpng django_view_permission.dot > django_view_permission.png
字体默认是 Roboto,可以换成其他的字体