#!/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