#!/bin/bash
#
# Inspired by ownCloud´s before_install.sh script <3
#

WORKDIR=$PWD
DB=$1

echo "Work directory: $WORKDIR"
echo "Database: $DB"

#
# set up mysql
#
if [ "$DB" == "mysql" ] ; then
    echo "Setting up mysql ..."
    mysql -u root -e "CREATE DATABASE userfrosting;"
    mysql -u root -e "CREATE USER 'userfrosting'@'localhost' IDENTIFIED BY 'userfrosting';"
    mysql -u root -e "GRANT ALL ON userfrosting.* TO 'userfrosting'@'localhost';"
    echo "UF_MODE=\"dev\"\nDB_DRIVER=\"mysql\"\nDB_HOST=\"localhost\"\nDB_PORT=\"3306\"\nDB_NAME=\"userfrosting\"\nDB_USER=\"userfrosting\"\nDB_PASSWORD=\"userfrosting\"\n" > app/.env
fi

#
# set up pgsql
#
if [ "$DB" == "pgsql" ] ; then
    echo "Setting up pgsql ..."
    createuser -U travis -s userfrosting
    echo "UF_MODE=\"dev\"\nDB_DRIVER=\"pgsql\"\nDB_HOST=\"localhost\"\nDB_PORT=\"5432\"\nDB_NAME=\"userfrosting\"\nDB_USER=\"travis\"\nDB_PASSWORD=\"\"\n" > app/.env
fi

#
# set up sqlite
#
if [ "$DB" == "sqlite" ] ; then
    echo "Setting up sqlite ..."
    echo "UF_MODE=\"dev\"\nDB_DRIVER=\"sqlite\"\nDB_NAME=\"userfrosting.db\"\n" > app/.env
fi