# Hinweise nutzt die Kerndatenbank zeitenschleife_core.
services:
  app:
    build: .
    image: zeitenschleife:hinweise
    init: true
    restart: unless-stopped
    depends_on:
      database:
        condition: service_healthy
    ports:
      - "${ZS_BIND_ADDRESS:-127.0.0.1}:${ZS_PORT:-5173}:5173"
    environment:
      DATA_SOURCE_KEY: "${DATA_SOURCE_KEY:-}"
    volumes:
      - app_data:/app/data
  database:
    image: mariadb:11.4
    # Die offizielle MariaDB-Initialisierung führt das SQL beim ersten Start aus.
    entrypoint: ["/bin/sh", "-ec"]
    command:
      - |
        cat > /docker-entrypoint-initdb.d/01-zeitenschleife.sql <<'SQL'
        CREATE DATABASE IF NOT EXISTS zeitenschleife_asset CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
        CREATE DATABASE IF NOT EXISTS zeitenschleife_calendar CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
        CREATE DATABASE IF NOT EXISTS zeitenschleife_plans CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
        CREATE DATABASE IF NOT EXISTS zeitenschleife_workflow CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
        CREATE DATABASE IF NOT EXISTS zeitenschleife_mailclient CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
        CREATE DATABASE IF NOT EXISTS zeitenschleife_portal CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

        GRANT ALL PRIVILEGES ON `zeitenschleife\_asset`.* TO 'zeitenschleife'@'%';
        GRANT ALL PRIVILEGES ON `zeitenschleife\_calendar`.* TO 'zeitenschleife'@'%';
        GRANT ALL PRIVILEGES ON `zeitenschleife\_plans`.* TO 'zeitenschleife'@'%';
        GRANT ALL PRIVILEGES ON `zeitenschleife\_workflow`.* TO 'zeitenschleife'@'%';
        GRANT ALL PRIVILEGES ON `zeitenschleife\_mailclient`.* TO 'zeitenschleife'@'%';
        GRANT ALL PRIVILEGES ON `zeitenschleife\_portal`.* TO 'zeitenschleife'@'%';
        SQL
        exec /usr/local/bin/docker-entrypoint.sh mariadbd
    restart: unless-stopped
    environment:
      MARIADB_DATABASE: zeitenschleife_core
      MARIADB_USER: zeitenschleife
      MARIADB_PASSWORD: "${ZS_DB_PASSWORD:?Bitte ZS_DB_PASSWORD als Umgebungsvariable setzen}"
      MARIADB_RANDOM_ROOT_PASSWORD: "1"
      MARIADB_ROOT_HOST: localhost
    healthcheck:
      test: ["CMD", "healthcheck.sh", "--connect", "--innodb_initialized"]
      start_period: 20s
      interval: 10s
      timeout: 5s
      retries: 12
    volumes:
      - db_data:/var/lib/mysql

volumes:
  app_data:
  db_data:
