build-commitfest.yml

name: Container Images from Commitest patch

on:
  workflow_dispatch:
    inputs:
      patch_id:
        description: "ID of the Patch"
        required: true
      major_version:
        description: "PostgreSQL major version (leave empty for default)"
        required: false

defaults:
  run:
    # default failure handling for shell scripts in 'run' steps
    shell: 'bash -Eeuo pipefail -x {0}'

permissions: read-all

jobs:
  build-pg:
    name: Build the patch for PostgreSQL
    runs-on: ${{ github.repository_owner == 'cloudnative-pg' && 'ubuntu-latest-16-cores' || 'ubuntu-24.04' }}
    permissions:
      contents: read
      packages: write
    outputs:
      images: ${{ env.IMAGES }}
    steps:
    - name: Checkout Code
      uses: actions/checkout@v6

    - name: Set env variables from defaults.json
      run: |
        for key in $(jq -r 'keys[]' defaults.json); do
          echo "$key=$(cat defaults.json | jq -r --arg key "$key" '.[$key]')" >> $GITHUB_ENV
        done

    # Inputs have priority over defaults.json.
    - name: Evaluate E2E workflow inputs
      env:
        INPUT_MAJOR_VERSION: ${{ github.event.inputs.major_version }}
      run: |
        if [[ -n "${INPUT_MAJOR_VERSION}" ]]; then
          echo "PG_MAJOR=${INPUT_MAJOR_VERSION}" >> $GITHUB_ENV
        fi

    - name: Set commitfest branch and tag
      env:
        INPUT_PATCH_ID: ${{ github.event.inputs.patch_id }}
      run: |
        BRANCH="cf/${INPUT_PATCH_ID}"
        TAG="${BRANCH////-}"
        echo "TAG=${TAG}" >> $GITHUB_ENV
        echo "BRANCH=${BRANCH}" >> $GITHUB_ENV

    - name: Log in to the GitHub Container registry
      uses: docker/login-action@v4
      with:
        registry: ghcr.io
        username: ${{ github.actor }}
        password: ${{ secrets.GITHUB_TOKEN }}

    - name: Set up Docker Buildx
      uses: docker/setup-buildx-action@v4

    - name: Build and push
      uses: docker/bake-action@v7
      id: build
      env:
        environment: production
        registry: ghcr.io/${{ github.repository_owner }}
        revision: ${{ github.sha }}
        pgMajor: ${{ env.PG_MAJOR }}
      with:
        set: |
          *.args.PG_REPO=https://github.com/postgresql-cfbot/postgresql.git
          *.args.PG_BRANCH=${{ env.BRANCH }}
          minimal.tags=${{ env.registry }}/postgresql-trunk:${{ env.PG_MAJOR }}-minimal-${{ env.TAG }}
          standard.tags=${{ env.registry }}/postgresql-trunk:${{ env.PG_MAJOR }}-standard-${{ env.TAG }}
          postgis.tags=${{ env.registry }}/postgresql-trunk:${{ env.PG_MAJOR }}-postgis-${{ env.TAG }}
        push: true

    # Get a list of the images that were built and pushed.
    - name: Generated images
      id: images
      env:
        BUILD_METADATA: ${{ steps.build.outputs.metadata }}
      run: |
        IMAGES="$(echo "${BUILD_METADATA}" | jq -r '.[]."image.name"')"
        {
          echo 'IMAGES<<EOF'
          echo "${IMAGES}"
          echo EOF
        } >> $GITHUB_ENV

  generate-summary:
    name: Commitfest Image Build summary
    runs-on: ubuntu-24.04
    needs:
      - build-pg
    steps:
      - name: Output summary
        env:
          INPUT_PATCH_ID: ${{ github.event.inputs.patch_id }}
          BUILD_PG_IMAGES: ${{ needs.build-pg.outputs.images }}
        run: |
          commitFestPatchID="${INPUT_PATCH_ID}"
          commitFestURL="https://commitfest.postgresql.org/patch/${commitFestPatchID}"
          images="${BUILD_PG_IMAGES}"
          images_list="$(echo $images | tr ' ' '\n' | sed 's/^/https:\/\//')"
          minimalImage="$(echo $images | tr ' ' '\n' | grep minimal)"

          echo "# Commitfest Image Build summary" >> $GITHUB_STEP_SUMMARY
          echo "**Commitfest Patch URL**: [$commitFestPatchID]($commitFestURL)" >> $GITHUB_STEP_SUMMARY
          echo "Here's the list of Container Images that have been built:" >> $GITHUB_STEP_SUMMARY
          echo "$images_list" >> $GITHUB_STEP_SUMMARY

          echo "## CloudNativePG Cluster definition" >> $GITHUB_STEP_SUMMARY
          echo "You can create a cluster in CloudNativePG running this image:" >> $GITHUB_STEP_SUMMARY
          echo "\`\`\`sh" >> $GITHUB_STEP_SUMMARY
          echo "(cat <<EOF" >> $GITHUB_STEP_SUMMARY
          echo "apiVersion: postgresql.cnpg.io/v1" >> $GITHUB_STEP_SUMMARY
          echo "kind: Cluster" >> $GITHUB_STEP_SUMMARY
          echo "metadata:" >> $GITHUB_STEP_SUMMARY
          echo "  name: commitfest-$commitFestPatchID" >> $GITHUB_STEP_SUMMARY
          echo "spec:" >> $GITHUB_STEP_SUMMARY
          echo "  imageName: $minimalImage" >> $GITHUB_STEP_SUMMARY
          echo "  instances: 3" >> $GITHUB_STEP_SUMMARY
          echo "  storage:" >> $GITHUB_STEP_SUMMARY
          echo "    size: 1Gi" >> $GITHUB_STEP_SUMMARY
          echo "EOF" >> $GITHUB_STEP_SUMMARY
          echo ") | kubectl apply -f -" >> $GITHUB_STEP_SUMMARY
          echo "\`\`\`" >> $GITHUB_STEP_SUMMARY