prod_reset_db

#!/usr/bin/env bash
# -*- encoding : utf-8 -*-

set -o errexit -o nounset -o pipefail
shopt -s nullglob
cd "${BASH_SOURCE%/*}" || exit 2
. _prod
cd ..
trap 'ERRNO=$?; printf "\n\nERROR %d %s:%d: \$ %s\n\n" "$ERRNO" "$BASH_SOURCE" "$LINENO" "$BASH_COMMAND"; exit $ERRNO' ERR

DATABASE_NAME="votes"
DATABASE_USER="postgres"
DATABASE_FILE="database.sql"

psql --quiet --command "SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = '$DATABASE_NAME'"
psql --quiet --command "DROP DATABASE IF EXISTS $DATABASE_NAME"
psql --quiet --command "CREATE DATABASE $DATABASE_NAME WITH OWNER = $DATABASE_USER"

psql "$DATABASE_NAME" --quiet --variable "VOTES_IMPORTER_PASSWORD=$VOTES_IMPORTER_PASSWORD" --variable "VOTES_APP_PASSWORD=$VOTES_APP_PASSWORD" < "$DATABASE_FILE" >/dev/null