SQLAlchemyViz 0.4

sqlalchemyviz

sqlalchemyviz是创建实体关系图的命令行实用程序 从用SQLAlchemy建模的数据库模式 使用Graphviz。

要求

需要在您的计算机上安装Graphviz，并且 SQLAlchemy和pydot包。

许可证

sqlalchemyviz分布在MIT License下。

快速启动

从sqlalchemy模式对象创建er关系图。

位置参数：

包模块：元数据标识符的元数据导入路径。

可选参数：

-h, --help	show this help message and exit
-f FILE, --file FILE
	Write diagram to specified file {default: diagram.pdf}.
-p PROG, --prog PROG
	Name of the graphviz layout program to use {default: “dot”}. Other choices are: “dot”, “twopi”, “circo” or “fdp”.
-o OPTION, --opt OPTION
	Where OPTION is e.g. “graph_bgcolor=red”. May be supplied multiple times.
-g GRAPHVIZ_PATH, --graphviz GRAPHVIZ_PATH
	Path to folder containing the graphviz executables.
-i INCLUDE_TABLES, --include INCLUDE_TABLES
	Include the given comma separated list of tables or classes. If omitted, create diagram for all.
-x EXCLUDE_TABLES, --exclude EXCLUDE_TABLES
	Exclude the given comma separated list of tables or classes.
--sort-columns	Sort columns by whether they are primary or foreign keys and (case-insensitive) alphabetically.
--unique-relations
	Draw relations between tables only once (if multiple foreign keys reference the same table).
--show-constraints
	Show table constraints.
--max-cols MAX_COLS
	Limit amount of columns shown per table.