#!/bin/bash
set -e

gultig=""

function lese_version {
	read version
	if [ -e etc/firma-$version.dump ]
	then
		gultig=1
	fi
}
	
echo "Diese Datenbanken sind verfügbar:"
ls etc/firma*

echo "Bitte gewünschte Version eingeben"
while [ -z "$gultig" ]
do
	lese_version
done

echo "GUI herunterfahren ..."
systemctl stop apache2

echo "Lösche bestende Datenbanken ..."
su postgres -c "psql -c 'DROP DATABASE IF EXISTS kivitendo_auth;'"
su postgres -c "psql -c 'DROP DATABASE IF EXISTS firma;'"

echo "Datenbanken anlegen ..."
su postgres -c "psql -c 'CREATE DATABASE kivitendo_auth OWNER=kivitendo;'"
su postgres -c "psql -c 'CREATE DATABASE firma OWNER=kivitendo;'"

echo "Daten laden ..."
su postgres -c "psql kivitendo_auth <etc/auth.dump >/dev/null"
su postgres -c "psql firma <etc/firma-$version.dump >/dev/null"

echo "GUI starten ..."
systemctl start apache2

echo "ok."