No project description provided
Project description
Paracelsus
Paracelsus generates Entity Relationship Diagrams by reading your SQLAlchemy models.
Features
- ERDs can be injected into documentation as Mermaid Diagrams.
- Paracelsus can be run in CICD to check that databases are up to date.
- ERDs can be created as files in either Dot or Mermaid format.
- DOT files can be used to generate SVG or PNG files, or edited in GraphViz or other editors.
Usage
Installation
The paracelsus package should be installed in the same environment as your code, as it will be reading your SQLAlchemy base class to generate the diagrams.
pip install paracelsus
Basic CLI Usage
Paracelsus is primarily a CLI application.
paracelsus --help
It has three commands:
version
outputs the version of the currently installedparacelsus
cli.graph
generates a graph and outputs it tostdout
.inject
inserts the graph into a markdown file.
Importing Models
SQLAlchemy models have to be imported before they are put into the model registry inside of the base class. This is similar to how Alembic needs models to be imported in order to generate migrations.
The --import-module
flag can be used to import any python module, which presumably will include one or more SQLAlchemy models inside of it.
paracelsus graph example_app.models.base:Base \
--import-module "example_app.models.users" \
--import-module "example_app.models.posts" \
--import-module "example_app.models.comments"
The :*
modify can be used to specify that a wild card import should be used. Make sure to wrap the module name in quotes when using this to prevent shell expansion.
paracelsus graph example_app.models.base:Base --import-module "example_app.models:*"
This is equivalent to running this style of python import:
from example_app.models import *
Generate Mermaid Diagrams
paracelsus graph example_app.models.base:Base --import-module "example_app.models:*"
erDiagram
users {
CHAR(32) id PK
DATETIME created
VARCHAR(100) display_name "nullable"
}
posts {
CHAR(32) id PK
CHAR(32) author FK
TEXT content "nullable"
DATETIME created
BOOLEAN live "nullable"
}
comments {
CHAR(32) id PK
CHAR(32) author FK
CHAR(32) post FK "nullable"
TEXT content "nullable"
DATETIME created
BOOLEAN live "nullable"
}
users ||--o{ posts : author
posts ||--o{ comments : post
users ||--o{ comments : author
When run through a Mermaid viewer, such as the ones installed in the markdown viewers of many version control systems, this will turn into a graphic.
erDiagram
users {
CHAR(32) id PK
DATETIME created
VARCHAR(100) display_name "nullable"
}
posts {
CHAR(32) id PK
CHAR(32) author FK
TEXT content "nullable"
DATETIME created
BOOLEAN live "nullable"
}
comments {
CHAR(32) id PK
CHAR(32) author FK
CHAR(32) post FK "nullable"
TEXT content "nullable"
DATETIME created
BOOLEAN live "nullable"
}
users ||--o{ posts : author
posts ||--o{ comments : post
users ||--o{ comments : author
Inject Mermaid Diagrams
Mermaid Diagrams and Markdown work extremely well together, and it's common to place diagrams inside of project documentation. Paracelsus can be used to inject diagrams directly into markdown configuration. It does so by looking for specific tags and placing a code block inside of them, replacing any existing content between the tags.
## Schema
<!-- BEGIN_SQLALCHEMY_DOCS -->
<!-- END_SQLALCHEMY_DOCS -->
paracelsus inject db/README.md example_app.models.base:Base --import-module "example_app.models:*"
The --check
flag can be used to see if the command would make any changes. If the file is already up to date then it will return a status code of 0
, otherwise it will return 1
if changes are needed. This is useful in CI/CD or precommit hook to enforce that documentation is always current.
paracelsus inject db/README.md example_app.models.base:Base --import-module "example_app.models:*" --check
Creating Images
GraphViz has a command line tool named dot that can be used to turn dot
graphs into images.
To create an SVG file:
paracelsus graph example_app.models.base:Base --import-module "example_app.models:*" --format dot | dot -Tsvg > output.svg
To create a PNG file:
paracelsus graph example_app.models.base:Base --import-module "example_app.models:*" --format dot | dot -Tpng > output.png
pyproject.toml
The settings for your project can be saved directly in the pyprojects.toml
file of your project.
[tool.paracelsus]
base = "example.base:Base"
imports = [
"example.models"
]
Sponsorship
This project is developed by Robert Hafner If you find this project useful please consider sponsoring me using Github!
Project details
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
Hashes for paracelsus-0.5.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4a7ffe822863744a936757ce5a755c0c1746ddb88919006ea753146817da799f |
|
MD5 | 25724661a491de55ad7937205171cf4d |
|
BLAKE2b-256 | b37db0b5a6969b1585458b7ded32e1302c00ce89bc8510938ffa0dffc38f145f |