Simple entity relation (ER) diagrams generation
Project description
ERAlchemy generates Entity Relation (ER) diagram (like the one below) from databases or from SQLAlchemy models.
Example
Example for a graph
Quick Start
Install on a mac
The simplest way to install eralchemy on OSX is by using Homebrew
$ brew install eralchemy
Install
To install ERAlchemy, just do:
$ pip install eralchemy
ERAlchemy requires GraphViz to generate the graphs and Python. Both are available for Windows, Mac and Linux.
Usage from Command Line
From a database
$ eralchemy -i sqlite:///relative/path/to/db.db -o erd_from_sqlite.pdf
The database is specified as a SQLAlchemy database url.
From a markdown file.
$ curl 'https://raw.githubusercontent.com/Alexis-benoist/eralchemy/master/example/newsmeme.er' > markdown_file.er $ eralchemy -i 'markdown_file.er' -o erd_from_markdown_file.pdf
From a Postgresql DB to a markdown file excluding tables named temp and audit
$ eralchemy -i 'postgresql+psycopg2://username:password@hostname:5432/databasename' -o filtered.er --exclude-tables temp audit
From a Postgresql DB to a markdown file excluding columns named created_at and updated_at from all tables
$ eralchemy -i 'postgresql+psycopg2://username:password@hostname:5432/databasename' -o filtered.er --exclude-columns created_at updated_at
From a Postgresql DB to a markdown file for the schema schema
$ eralchemy -i 'postgresql+psycopg2://username:password@hostname:5432/databasename' -s schema
Usage from Python
from eralchemy import render_er
## Draw from SQLAlchemy base
render_er(Base, 'erd_from_sqlalchemy.png')
## Draw from database
render_er("sqlite:///relative/path/to/db.db", 'erd_from_sqlite.png')Architecture
Architecture schema
Thanks to it’s modular architecture, it can be connected to other ORMs/ODMs/OGMs/O*Ms.
Contribute
Every feedback is welcome on the GitHub issues.
To run the tests, use : $ py.test. Some tests require a local postgres database with a schema named test in a database named test all owned by a user named postgres with a password of postgres.
All tested PR are welcome.
Notes
ERAlchemy was inspired by erd, though it is able to render the ER diagram directly from the database and not just only from the ER markup language.
Released under an Apache License 2.0
Creator: Alexis Benoist Alexis_Benoist
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file ERAlchemy-1.2.8.tar.gz.
File metadata
- Download URL: ERAlchemy-1.2.8.tar.gz
- Upload date:
- Size: 10.7 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 9e3a538458775a92420318e3510a136cbcb13487f11ad83c67c97f7f2fba37bd |
|
| MD5 | 6eaf9ac7ae54b2d18606a3186f517d7c |
|
| BLAKE2b-256 | e4e8d5449b9c8f934d7e3c79fe7c6ea795898270f35f4d468260e80da95425e2 |
File details
Details for the file ERAlchemy-1.2.8-py2.py3-none-any.whl.
File metadata
- Download URL: ERAlchemy-1.2.8-py2.py3-none-any.whl
- Upload date:
- Size: 14.2 kB
- Tags: Python 2, Python 3
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 682b6f34ef6fadf446e9db80c3571005adbedd372895aeb987c727b6402beb90 |
|
| MD5 | fc9d7315dd11478e69ead7aad2b703d0 |
|
| BLAKE2b-256 | b256403e475592e14137563feec8d212be2c6e6405485f014fa6d1421c375ee5 |
