ERDIA

erdia is create ER Diagram and Entity schema specification using by TypeORM and mermiad.js

!ts

Why erdia ?

erdia is a cli tool that allows you to automatically generate DB specifications and ER diagram documents using TypeORM. It is very hard to be diligent about updating DB specifications and ER diagrams whenever code and DB changes. erdia automatically generates DB statement and ER diagram documents using information provided by TypeORM whenever the code changes. By automatically generating documents using TypeORM code, you can maintain the freshness of your documents with minimal effort.

Summary,

1. ER diagram generate using mermaid.js syntax.
2. Every document generate using ETA template engine
3. Use TypeORM

Automate your database ER diagram drawing!

Table of Contents

- How it works?
- Getting started
- Installation
- Confuguration
- Generation
- Usage
- Commands
- CLI Options
- Programming Interfaces
- Interfaces
- Function Options
- Requirement
- Example
- Showcase
- Documents
- Output Format
- Template
- TypeScript
- License
- References

erdia support initialization command. And you execute build command.

How it works?

``mermaid
graph LR

A[TypeORM Entity] --> erdia
subgraph erdia
direction TB
C[TypeORM Entity]-->|extract
entity specification|B[erdia]
end
erdia-->|extract
specification|D
D[ETA
template
engine]-->E[html]
D-->F[markdown]
D-->G[pdf]
D-->H[image]
`

Getting started

$3

`bash
npm install erdia --save-dev
`

$3

`bash
npx erdia init
`

$3

`bash
erdia build -d [your dataSource path] -o dist/entity --format html
`

Usage

$3

erdia supports the build, clean, init, and eject commands.

| Command | Description |
| ------- | ----------------------------------------------------------- |
| build | Builds the erdiagram document. |
| init | Generates a configuration file for creating erdiagrams. |
| eject | Generates a template document file for creating erdiagrams. |
| clean | Deletes the previously built erdiagram document. |

$3

- build options
- init options
- eject options
- clean options

Programming Interfaces

$3

| Command | Description |
| ------------ | ----------------------------------------------------------- |
| building | Builds the erdiagram document. |
| initializing | Generates a configuration file for creating erdiagrams. |
| ejecting | Generates a template document file for creating erdiagrams. |
| cleaning | Deletes the previously built erdiagram document. |

$3

- build options
- init options
- eject options
- clean options

Requirement

- TypeORM 0.3.x

Example

$3

!erdia showcase

$3

- ER diagram html format
- ER diagram png image format
- ER diagram & table pdf format

Output Format

erdia support html, markdown, pdf, svg, png. Database entity specification table only support html, markdown, pdf format.

`bash


PDF document generate


erdia build -d [your dataSourcePath] -o dist/entity --format pdf
`

Template

erdia use ETA template for entity specification document and ER diagram. Template easily detach from erdia.

`bash
npx erdia eject
`

Detached template can change and every document customizable. The template can be found here.

TypeScript

If you are using TypeScript, you must use ts-node or tsx to run erdia`. This is because the TypeORM Entity file is written in TypeScript.

- ts-node
- tsx
- scripts

License

This software is licensed under the MIT.

References

- TypeORM
- ER Diagram