#!/bin/bash
source config.sh

set -e #fail if anything goes wrong

if [ -z "${DBNAME}" ]; then
    echo "Moodle DB is not set up in \$DBNAME"
    exit 1
fi

if [[ ! $(echo "select 1 | mysql -u $DBUSER -p$DBPASSWORD $DBNAME -h $DBHOST") ]]; then
    echo Could not connect to the database, check \$DBUSER, \$DBNAME and \$DBPASSWORD
    exit 1
fi

if [ -z "${MOODLEDIR}" ]; then
    echo "Moodle directory \$MOODLEDIR is not set"
    exit 1
fi

if [ -z "${MOODLEDATA}" ]; then
    echo "Moodle data directory \$MOODLEDATA is not set"
    exit 1
fi

if [ -z "${SOURCEDATA}" ]; then
    echo "Moodle source data directory \$SOURCEDATA is not set"
    exit 1
fi

if [ -z "${SOURCESQL}" ]; then
    echo "Moodle source data directory \$SOURCESQL is not set"
    exit 1
fi

function install_db {
  cd ../../data
  bzip2 -dk $SOURCESQL.sql.bz2 || true #if bzip2 fails than most likely because it's already unpacked
  echo "DROP DATABASE $DBNAME" | mysql -u "$DBUSER" -p"$DBPASSWORD" "$DBNAME" -h "$DBHOST"
  echo "CREATE DATABASE $DBNAME" | mysql -u "$DBUSER" -p"$DBPASSWORD" -h "$DBHOST"
  mysql -u "$DBUSER" -p"$DBPASSWORD" "$DBNAME" -h "$DBHOST" < $SOURCESQL.sql
}

function install_data {
  DIR_PATH=$(readlink -f "${MOODLEDATA}")

  if [[ -d "${DIR_PATH}" ]] ; then
    rm -rf $MOODLEDATA/*
    tar xjf $SOURCEDATA.tar.bz2
    mv $SOURCEDATA/* $MOODLEDATA
  else
    exit 1
  fi
}