From 9d6721bce1ed93e66c589d34e20393c78c7a423b Mon Sep 17 00:00:00 2001
From: Benedikt Peetz <benedikt.peetz@b-peetz.de>
Date: Mon, 17 Feb 2025 19:11:50 +0100
Subject: feat(yt/storage/migrate): Init database migration system

I could have used the `sqlx` migration system, but that seem too much
like a framework to me.
---
 scripts/mkdb.sh | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'scripts/mkdb.sh')

diff --git a/scripts/mkdb.sh b/scripts/mkdb.sh
index afd94b3..6bcebaf 100755
--- a/scripts/mkdb.sh
+++ b/scripts/mkdb.sh
@@ -16,6 +16,9 @@ db="$root/target/database.sqlx"
 [ -f "$db" ] && rm "$db"
 [ -d "$root/target" ] || mkdir "$root/target"
 
-sqlite3 "$db" <"$root/yt/src/storage/video_database/schema.sql"
+fd . "$root/yt/src/storage/migrate/sql" | while read -r sql_file; do
+    echo "Applying sql migration file: $(basename "$sql_file").."
+    sqlite3 "$db" <"$sql_file"
+done
 
 # vim: ft=sh
-- 
cgit 1.4.1