esquel 0.1.2

create mermaid charts from sql scripts
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60

# esquel

Create [mermaid](https://mermaid.live/) diagrams from SQL scripts.

```sh
USAGE:
    esquel [OPTIONS] --input <INPUT>

OPTIONS:
    -d, --dialect <DIALECT>    [default: generic] [possible values: ansi, clickhouse, generic, hive,
                               mssql, mysql, postgres, sqlite, snowflake]
    -f, --flow <FLOW>          Direction of the flowchart [default: tb] [possible values: tb, bt,
                               rl, lr]
    -h, --help                 Print help information
    -i, --input <INPUT>        Path to sql script or raw sql
        --no-icons             Do not show icons
    -o, --out <OUT>            Path to output file
    -V, --version              Print version information
```

Uses all **CREATE**, **INSERT**, **DELETE** and **UPDATE** statements that reference other tables.

## Example

The following SQL script

```sql
create table foo as
select * from bar;

create view baz as
select * from foo
inner join qux;

delete from foo
where exists (
  select 1 from qux
  where qux.foo_id = foo.foo_id
);
```

generates this flowchart:

```mermaid
graph TB
    A[bar]
    B[fa:fa-eye baz]
    C[fa:fa-table foo]
    D[qux]
    A --> C
    C --> B
    D --> B
    D --> C
```

## Installation

```sh
cargo install esquel
```