SQLAlchemyViz Sphinx Extension

This file provides a Sphinx extension to include an Entity-Relationship diagram of SQLAlchemy metadata, generated by the SQLAlchemyViz package. This is a highly unpolished extension which does almost no heavy lifting, and not portable across platforms. The SQLALchemyViz package converts the SQLAlchemy metadata object into a dot file. The extension then uses POSIX/Linux tools via python's subprocess mechanisms to improve the layout of the graph.

To achieve the same effect directly from the shell, the relevant commands would be :

sqlaviz --unique-relations --show-constraints <pkg.module:metadata> -f out.dot
ccomps -x out.dot | dot | gvpack -array3 | neato -Tpng -n2 -o out.png

sqlaviz -p neato --unique-relations <pkg.module:metadata> -f out.dot
ccomps -x out.dot | dot | gvpack -array3 | neato -Tpng -n2 -o out.png

sqlaviz -p neato --unique-relations <pkg.module:metadata> -o node_margin='"0,0"' -f out.dot

Installation & Usage

This extension can be installed from pypi :

pip install sphinxcontrib-sqlalchemyviz

Add the sphinxcontrib.sqlalchemyviz to Sphinx's list of extensions on the conf.py

In the .rst file where the table should appear, insert the Sphinx directive provided by this module :

.. sqlaviz::
    :metadataobject: full.importable.path.of.metadata

For a basic usage example, see:

License

This Sphinx Extension is made available under the BSD 2-clause License. See the LICENSE file for the full text.