#!/usr/bin/sh -e
#
# Run the database install/upgrade scripts.
#
# Both scripts are nondestructive, so it's safe to run this as many
# times as you want.  The result will always be a database with the
# latest version of the tables and functions.
#

WHOAMI=$(basename $0)

if [ "$(id -u)" != "0" ]
then
    echo "This command must be run as root."
    exit 1
fi

[ -t 0 -a -t 1 -a -t 2 ] && INTERACTIVE=true || INTERACTIVE=false

$INTERACTIVE && printf "Loading database:\n" || true

$INTERACTIVE && printf '    Administrative...' || true
postgresql-load \
    --log-errors "${WHOAMI}-super" \
    '/usr/share/pscheduler/database-build-super.sql'
$INTERACTIVE && printf ' Done.\n' || true

$INTERACTIVE && printf '    User pscheduler...' || true
postgresql-load \
    --role 'pscheduler' \
    --log-errors "${WHOAMI}-pscheduler"  \
    '/usr/share/pscheduler/database-build.sql'
$INTERACTIVE && printf ' Done.\n' || true
