Test in branch test eingefügt

[kivitendo-erp.git] / Test / bin / reset-database

diff --git a/Test/bin/reset-database b/Test/bin/reset-database
new file mode 100755 (executable)
index 0000000..0877166
--- /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."
+