about summary refs log tree commit diff stats
path: root/scripts/mk_sqlite_schema.sh
diff options
context:
space:
mode:
authorBenedikt Peetz <benedikt.peetz@b-peetz.de>2025-09-23 08:33:46 +0200
committerBenedikt Peetz <benedikt.peetz@b-peetz.de>2025-09-23 08:34:46 +0200
commitfe04e15c5fdcc99fcf3feeb9df2ed98dbfe97448 (patch)
treeb04aecffc5b712365d9424870b8fb9dc07b42549 /scripts/mk_sqlite_schema.sh
parentfeat(treewide): Add tests and barcode buying/consuming (diff)
downloadserver-fe04e15c5fdcc99fcf3feeb9df2ed98dbfe97448.zip
build(scripts/mk_sqlite_schema.sh): Init
Diffstat (limited to '')
-rwxr-xr-xscripts/mk_sqlite_schema.sh18
1 files changed, 18 insertions, 0 deletions
diff --git a/scripts/mk_sqlite_schema.sh b/scripts/mk_sqlite_schema.sh
new file mode 100755
index 0000000..7995af7
--- /dev/null
+++ b/scripts/mk_sqlite_schema.sh
@@ -0,0 +1,18 @@
+#! /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