From ead4bcd581bcaace363f9647b46c37c850e2fa5c Mon Sep 17 00:00:00 2001
From: Michael Wagner <michael@wagnertech.de>
Date: Thu, 18 Feb 2021 20:24:52 +0100
Subject: [PATCH] epic-ts

---
 .../AaNeuInstallation/content.txt             |  9 -------
 .../AaNeuInstallation/properties.xml          | 14 ----------
 .../AbAktualisierung/content.txt              |  8 ------
 .../AbAktualisierung/properties.xml           | 11 --------
 .../.dummy                                    |  0
 .../.dummy                                    |  0
 Test/FitnessePages/AlAktualisierung/.dummy    |  0
 Test/bin/remove-database                      | 27 +++++++++++++++++++
 8 files changed, 27 insertions(+), 42 deletions(-)
 delete mode 100644 Test/FitnessePages/AaNeuInstallation/content.txt
 delete mode 100644 Test/FitnessePages/AaNeuInstallation/properties.xml
 delete mode 100644 Test/FitnessePages/AbAktualisierung/content.txt
 delete mode 100644 Test/FitnessePages/AbAktualisierung/properties.xml
 rename Test/FitnessePages/{AaNeuInstallation => AbDeinstallieren}/.dummy (100%)
 rename Test/FitnessePages/{AbAktualisierung => AdNeuInstallation}/.dummy (100%)
 create mode 100644 Test/FitnessePages/AlAktualisierung/.dummy
 create mode 100755 Test/bin/remove-database

diff --git a/Test/FitnessePages/AaNeuInstallation/content.txt b/Test/FitnessePages/AaNeuInstallation/content.txt
deleted file mode 100644
index 657840fe2..000000000
--- a/Test/FitnessePages/AaNeuInstallation/content.txt
+++ /dev/null
@@ -1,9 +0,0 @@
-#!|test.util.CallScript|
-#|call script|sudo apt-get update|
-#|call script|sudo apt-get install kivitendo|
-
-Folgende Skripte im Verzeichnis Test ausführen:
-sudo apt-get update
-sudo apt-get install kivitendo
-
-Während der Installation werden auf der Kommandozeile diverse Passwörter gefragt. Immer "kivitendo" eingeben!
\ No newline at end of file
diff --git a/Test/FitnessePages/AaNeuInstallation/properties.xml b/Test/FitnessePages/AaNeuInstallation/properties.xml
deleted file mode 100644
index e9c80b95a..000000000
--- a/Test/FitnessePages/AaNeuInstallation/properties.xml
+++ /dev/null
@@ -1,14 +0,0 @@
-<?xml version="1.0"?>
-<properties>
-	<Edit/>
-	<Files/>
-	<Help/>
-	<Properties/>
-	<RecentChanges/>
-	<Refactor/>
-	<Search/>
-	<Static/>
-	<Suites/>
-	<Versions/>
-	<WhereUsed/>
-</properties>
diff --git a/Test/FitnessePages/AbAktualisierung/content.txt b/Test/FitnessePages/AbAktualisierung/content.txt
deleted file mode 100644
index b6aefd9ab..000000000
--- a/Test/FitnessePages/AbAktualisierung/content.txt
+++ /dev/null
@@ -1,8 +0,0 @@
-Zur Aktualisierung der kivitendo-Installation sind folgende Kommandos auszuführen:
-
-sudo apt-get update
-sudo apt-get full-update
-
-Kontrolle der Version mit:
-
-apt-cache policy kivitendo
diff --git a/Test/FitnessePages/AbAktualisierung/properties.xml b/Test/FitnessePages/AbAktualisierung/properties.xml
deleted file mode 100644
index 72aa2b6a6..000000000
--- a/Test/FitnessePages/AbAktualisierung/properties.xml
+++ /dev/null
@@ -1,11 +0,0 @@
-<?xml version="1.0"?>
-<properties>
-	<Edit>true</Edit>
-	<Files>true</Files>
-	<Properties>true</Properties>
-	<RecentChanges>true</RecentChanges>
-	<Refactor>true</Refactor>
-	<Search>true</Search>
-	<Versions>true</Versions>
-	<WhereUsed>true</WhereUsed>
-</properties>
diff --git a/Test/FitnessePages/AaNeuInstallation/.dummy b/Test/FitnessePages/AbDeinstallieren/.dummy
similarity index 100%
rename from Test/FitnessePages/AaNeuInstallation/.dummy
rename to Test/FitnessePages/AbDeinstallieren/.dummy
diff --git a/Test/FitnessePages/AbAktualisierung/.dummy b/Test/FitnessePages/AdNeuInstallation/.dummy
similarity index 100%
rename from Test/FitnessePages/AbAktualisierung/.dummy
rename to Test/FitnessePages/AdNeuInstallation/.dummy
diff --git a/Test/FitnessePages/AlAktualisierung/.dummy b/Test/FitnessePages/AlAktualisierung/.dummy
new file mode 100644
index 000000000..e69de29bb
diff --git a/Test/bin/remove-database b/Test/bin/remove-database
new file mode 100755
index 000000000..5d4fcb0b8
--- /dev/null
+++ b/Test/bin/remove-database
@@ -0,0 +1,27 @@
+#!/bin/bash
+set -e
+
+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 "Lösche kivitendo-user"
+su postgres -c "psql -c 'DROP USER kivitendo;'"
+
+echo "GUI starten ..."
+systemctl start apache2
+
+main=$(ls -d /etc/postgresql/*/main/)
+awk '/kivitendo/ {
+		next; }
+	{print;}
+	' $main/pg_hba.conf > /tmp/pg_hba.conf
+mv /tmp/pg_hba.conf $main/pg_hba.conf
+chown postgres:postgres $main/pg_hba.conf
+
+
+echo "ok."
+
-- 
2.20.1