scripts/mk_sqlite_schema.sh


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

#! /usr/bin/env sh

set -e

root="$(dirname "$0")/.."
db="${DATABASE_URL#sqlite://}"
schema_file="$root/target/schema.dot"
schema_svg="$root/target/schema.svg"

mkdb.sh

sqlite3 "$db" -init "$root/scripts/sqlite-schema-diagram.sql" "" >"$schema_file"
dot -Tsvg "$schema_file" >"$schema_svg"

imv "$schema_svg"

# vim: ft=sh