#!/bin/bash
echo "<INFO> - Creating cloudify_db, stage and composer..."
set -e

db_name="cloudify_db"
stage_db_name="stage"
composer_db_name="composer"
user="cloudify"
password="cloudify"

function run_psql() {
    cmd=$1
    echo "Going to run: ${cmd}"
    psql -c "${cmd}"
}

function clean_database_and_user() {
    run_psql "DROP DATABASE IF EXISTS $db_name;"
    run_psql "DROP DATABASE IF EXISTS $stage_db_name;"
    run_psql "DROP DATABASE IF EXISTS $composer_db_name;"
    run_psql "DROP USER IF EXISTS $user;"
}

function create_database() {
    run_psql "CREATE DATABASE $db_name"
}

function create_admin_user() {
    run_psql "CREATE USER $user WITH PASSWORD '$password';"
    run_psql "GRANT ALL PRIVILEGES ON DATABASE $db_name TO $user;"
    run_psql "ALTER USER $user CREATEDB;"
    run_psql "ALTER DATABASE $db_name OWNER TO $user;"
}

function create_stage_database() {
    run_psql "CREATE DATABASE $stage_db_name"
    run_psql "GRANT ALL PRIVILEGES ON DATABASE $stage_db_name TO $user;"
    run_psql "ALTER DATABASE $stage_db_name OWNER TO $user;"
}

function create_composer_database() {
    run_psql "CREATE DATABASE $composer_db_name"
    run_psql "GRANT ALL PRIVILEGES ON DATABASE $composer_db_name TO $user;"
    run_psql "ALTER DATABASE $composer_db_name OWNER TO $user;"
}

clean_database_and_user
create_database
create_admin_user
create_stage_database
create_composer_database

echo "Successfully created dafault DBs!"