From fe04e15c5fdcc99fcf3feeb9df2ed98dbfe97448 Mon Sep 17 00:00:00 2001
From: Benedikt Peetz <benedikt.peetz@b-peetz.de>
Date: Tue, 23 Sep 2025 08:33:46 +0200
Subject: build(scripts/mk_sqlite_schema.sh): Init

---
 scripts/mk_sqlite_schema.sh | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)
 create mode 100755 scripts/mk_sqlite_schema.sh

(limited to 'scripts/mk_sqlite_schema.sh')

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
-- 
cgit 1.4.1