From 962d2097adde8f690ef9768231122ede732a3681 Mon Sep 17 00:00:00 2001
From: OsCoder <oscoder@lczimmermann.eu>
Date: Fri, 11 Sep 2026 15:48:53 +0200
Subject: Initial Commit with podman scripts

---
 scripts/insert-test-data.sh |  6 ++++++
 scripts/start-db.sh         | 16 ++++++++++++++++
 scripts/stop-db.sh          |  3 +++
 3 files changed, 25 insertions(+)
 create mode 100755 scripts/insert-test-data.sh
 create mode 100755 scripts/start-db.sh
 create mode 100755 scripts/stop-db.sh

(limited to 'scripts')

diff --git a/scripts/insert-test-data.sh b/scripts/insert-test-data.sh
new file mode 100755
index 0000000..b817cce
--- /dev/null
+++ b/scripts/insert-test-data.sh
@@ -0,0 +1,6 @@
+#!/usr/bin/env bash
+set -euo pipefail
+
+podman exec -it pg-postgres-browser psql -U postgres -d testdb -c \
+  "CREATE TABLE clients (id serial PRIMARY KEY, label text, city text);
+   INSERT INTO clients (label, city) VALUES ('Anna Schmidt', 'Kiel'), ('Ben Weber', 'Flensburg');"
\ No newline at end of file
diff --git a/scripts/start-db.sh b/scripts/start-db.sh
new file mode 100755
index 0000000..d46e5f5
--- /dev/null
+++ b/scripts/start-db.sh
@@ -0,0 +1,16 @@
+#!/usr/bin/env bash
+set -euo pipefail
+
+CONTAINER_NAME="pg-postgres-browser"
+
+if podman ps -a --format '{{.Names}}' | grep -q "^${CONTAINER_NAME}$"; then
+    echo "Container existiert bereits, starte neu..."
+    podman start "${CONTAINER_NAME}"
+else
+    echo "Erstelle neuen Container..."
+    podman run -d --name "${CONTAINER_NAME}" \
+        -e POSTGRES_PASSWORD=test \
+        -e POSTGRES_DB=testdb \
+        -p 5432:5432 \
+        postgres:latest
+fi
\ No newline at end of file
diff --git a/scripts/stop-db.sh b/scripts/stop-db.sh
new file mode 100755
index 0000000..1c6b0af
--- /dev/null
+++ b/scripts/stop-db.sh
@@ -0,0 +1,3 @@
+#!/usr/bin/env bash
+set -euo pipefail
+podman stop pg-postgres-browser
\ No newline at end of file
-- 
cgit v1.2.3