aboutsummaryrefslogtreecommitdiff
path: root/bin/db
diff options
context:
space:
mode:
Diffstat (limited to 'bin/db')
-rwxr-xr-xbin/db26
1 files changed, 26 insertions, 0 deletions
diff --git a/bin/db b/bin/db
new file mode 100755
index 0000000..431ba78
--- /dev/null
+++ b/bin/db
@@ -0,0 +1,26 @@
+#!/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); do
+ printf "\n- Applying sql/migrations/$MIGRATION\n\n"
+ sqlite3 database.db < "sql/migrations/$MIGRATION"
+ done
+
+ printf "\n- Applying sql/fixtures.sql\n\n"
+ sqlite3 database.db < sql/fixtures.sql
+
+else
+
+ echo "Usage: $0 init"
+ exit 1
+
+fi