#!/bin/sh
# database upgrade script for gnuhealth-server

set -e

# Source the config file from dbconfig-common
. /etc/dbconfig-common/gnuhealth-server.conf

GNUHEALTH_CONFFILE="/etc/gnuhealth/gnuhealth-server.conf"
BACKUP_FILE="/var/lib/gnuhealth/backups/backup_${dbc_dbname}_`date +\%F_\%H-\%M-\%S`.sql"

# Start printing output on a new line
echo

# Make a backup of the database prior to upgrading
sudo -u ${dbc_dbuser} pg_dump gnuhealth > ${BACKUP_FILE}
# Run the pre script provided by upstream
sudo -u ${dbc_dbuser} python /usr/share/gnuhealth/scripts/upgrade/2.0/pre.py --pg="dbname=${dbc_dbname}"
# Upgrade the gnuhealth database
sudo -u ${dbc_dbuser} trytond --database=${dbc_dbname} --update=all --config=${GNUHEALTH_CONFFILE}

exit 0

