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