diff options
| author | Benedikt Peetz <benedikt.peetz@b-peetz.de> | 2025-02-17 19:11:50 +0100 |
|---|---|---|
| committer | Benedikt Peetz <benedikt.peetz@b-peetz.de> | 2025-02-17 19:15:25 +0100 |
| commit | 9d6721bce1ed93e66c589d34e20393c78c7a423b (patch) | |
| tree | 6cba22d3231e2f951729045173e3e5e32da61177 /scripts | |
| parent | build({.envrc,scripts/mkdb}): Mark the `sqlx` database (diff) | |
| download | yt-9d6721bce1ed93e66c589d34e20393c78c7a423b.zip | |
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.
Diffstat (limited to 'scripts')
| -rwxr-xr-x | scripts/mkdb.sh | 5 |
1 files changed, 4 insertions, 1 deletions
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 |