From 4a120a3e1828d91d0d03ee3bc53d599969872a97 Mon Sep 17 00:00:00 2001
From: Kurt Roscher <ku.roscher@abenteuerkompass.eu>
Date: Sat, 18 Oct 2025 19:45:28 +0200
Subject: [PATCH] Add compose file for postgresql testing in local docker
 environment

---
 docker-compose.yaml | 50 +++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 50 insertions(+)
 create mode 100644 docker-compose.yaml

diff --git a/docker-compose.yaml b/docker-compose.yaml
new file mode 100644
index 000000000..5b3630a5e
--- /dev/null
+++ b/docker-compose.yaml
@@ -0,0 +1,50 @@
+services:
+  coocook:
+    image: registry.gitlab.com/coocook/coocook/dev:latest
+    container_name: coocook-app
+    restart: always
+    ports:
+      - 3004:3000
+    volumes:
+      - .:/usr/src/app
+    environment:
+      COOCOOK_DSN: "dbi:Pg:"
+      PGHOST: "db"
+      PGDATABASE: "coocook"
+      PGUSER: "coocook"
+      PGPASSWORD: "super-secret-coocook"
+    command: ["--restart", "--debug"]
+    depends_on:
+      - db
+
+  db:
+    image: docker.io/postgres:17.4
+    container_name: coocook-db
+    restart: always
+    ports:
+      - 3005:5432
+    volumes:
+      - db_data:/var/lib/postgresql/data
+    environment:
+      POSTGRES_PASSWORD: "super-secret-coocook"
+      POSTGRES_USER: "coocook"
+      POSTGRES_DB: "coocook"
+
+  coocook_db_install:
+    image: registry.gitlab.com/coocook/coocook/dev:latest
+    container_name: coocook-db-install
+    volumes:
+      - .:/usr/src/app
+    environment:
+      COOCOOK_DSN: "dbi:Pg:"
+      PGHOST: "db"
+      PGDATABASE: "coocook"
+      PGUSER: "coocook"
+      PGPASSWORD: "super-secret-coocook"
+      DBI_TRACE: 1
+    entrypoint: ["script/coocook_deploy.pl", "--connection_name", "dbi:Pg:", "install"]
+    depends_on:
+      - db
+
+volumes:
+  db_data:
-- 
GitLab