X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/d9b9f30e2069206797d6154cfe6570677b071487..d5fa8afe0bfdcc2800994ec08778a500cf5a55ae:/Test/bin/reset-database

diff --git a/Test/bin/reset-database b/Test/bin/reset-database
new file mode 100755
index 000000000..087716663
--- /dev/null
+++ b/Test/bin/reset-database
@@ -0,0 +1,42 @@
+#!/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."
+