run_install_job.sh

#!/bin/bash
source .env

# Get variables
PROJECT_ID=$(gcloud config get-value project)
REGION="europe-west1"
IMAGE_URL="europe-west1-docker.pkg.dev/$PROJECT_ID/kimai-repo/kimai-app:latest"
DB_INSTANCE_NAME="kimai-db"
CONNECTION_NAME=$(gcloud sql instances describe $DB_INSTANCE_NAME --format="value(connectionName)")

# Escape commas for TRUSTED_PROXIES
TRUSTED_PROXIES_ESCAPED=$(echo "$TRUSTED_PROXIES" | sed 's/,/\\,/g')

echo "Creating Kimai installer job..."
gcloud run jobs create kimai-installer \
    --image=$IMAGE_URL \
    --region=$REGION \
    --memory=4Gi \
    --set-cloudsql-instances=$CONNECTION_NAME \
    --set-env-vars="^|^TRUSTED_PROXIES=$TRUSTED_PROXIES|MAILER_FROM=$MAILER_FROM|MAILER_URL=$MAILER_URL|ADMINMAIL=$ADMIN_EMAIL|memory_limit=3072M|APP_ENV=prod" \
    --set-secrets="DATABASE_URL=kimai-db-url:latest,APP_SECRET=kimai-app-secret:latest,ADMINPASS=kimai-admin-password:latest" \
    --command="sh" \
    --args="-c,php -d memory_limit=-1 /opt/kimai/bin/console kimai:install -n" \
    --service-account="587885930948-compute@developer.gserviceaccount.com"

echo "Executing installer job..."
gcloud run jobs execute kimai-installer --region=$REGION --wait