#!/bin/bash

set -e

BACKUP_PATH="$1"
SOURCE_DB="h_edu_sro1252" && [[ ! -z "$2" ]] && SOURCE_DB="$2"
TARGET_DB="bo-dev" && [[ ! -z "$3" ]] && TARGET_DB="$3"
TARGET_HOST=localhost
TARGET_USER=bo
TARGET_PORT=5432

function execute_sql {
    echo $1 | psql --dbname $TARGET_DB --host $TARGET_HOST --username $TARGET_USER --no-password
}

set -xu
export VERBOSITY=verbose
execute_sql "DROP SCHEMA IF EXISTS $SOURCE_DB CASCADE;"
set +e
pg_restore --dbname $TARGET_DB --host $TARGET_HOST --port $TARGET_PORT --username $TARGET_USER --verbose --format custom --clean --create --no-privileges --no-owner --no-password $BACKUP_PATH 
set -e
execute_sql "DROP SCHEMA IF EXISTS public CASCADE; ALTER SCHEMA $SOURCE_DB RENAME TO public;"