about summary refs log tree commit diff stats
path: root/scripts/mk_sqlite_schema.sh
blob: 89575f5c38f6ec70850519e5f0c6509c34d9062f (plain) (blame)
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
#! /usr/bin/env sh

# rocie - An enterprise grocery management system
#
# Copyright (C) 2026 Benedikt Peetz <benedikt.peetz@b-peetz.de>
# SPDX-License-Identifier: GPL-3.0-or-later
#
# This file is part of Rocie.
#
# You should have received a copy of the License along with this program.
# If not, see <https://www.gnu.org/licenses/gpl-3.0.txt>.

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