From bfe4aa78d882b9d95bd1f954371136f3aa5c38c9 Mon Sep 17 00:00:00 2001 From: Joris Date: Fri, 7 Feb 2025 08:25:28 +0100 Subject: Migrate database at startup --- bin/db | 26 -------------------------- 1 file changed, 26 deletions(-) delete mode 100755 bin/db (limited to 'bin') diff --git a/bin/db b/bin/db deleted file mode 100755 index 186f83d..0000000 --- a/bin/db +++ /dev/null @@ -1,26 +0,0 @@ -#!/usr/bin/env bash -set -euo pipefail -cd $(dirname "$0")/.. - -DB_PATH="database.db" - -if [ "$1" == "init" ]; then - - if [ -f "$DB_PATH" ]; then - rm "$DB_PATH" - fi - - for MIGRATION in $(ls sql/migrations/*.sql); do - printf "\n- Applying $MIGRATION\n\n" - sqlite3 database.db < "$MIGRATION" - done - - printf "\n- Applying sql/fixtures.sql\n\n" - sqlite3 database.db < sql/fixtures.sql - -else - - echo "Usage: $0 init" - exit 1 - -fi -- cgit v1.2.3