update-mendix-version.yml

name: Update Mendix Version

on:
  schedule:
    - cron: '0 8 * * 1'  # Every Monday at 08:00 UTC
  workflow_dispatch:       # Manual trigger

permissions:
  contents: write

jobs:
  check-mendix-version:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v5

      - name: Read current Mendix version
        id: current
        run: echo "version=$(cat .mendix-version)" >> "$GITHUB_OUTPUT"

      - name: Check for newer Mendix versions
        id: check
        run: |
          CURRENT="${{ steps.current.outputs.version }}"
          MAJOR=$(echo "$CURRENT" | cut -d. -f1)
          MINOR=$(echo "$CURRENT" | cut -d. -f2)
          PATCH=$(echo "$CURRENT" | cut -d. -f3)

          LATEST="$CURRENT"

          # Check patch versions (e.g., 11.6.3 -> 11.6.4, 11.6.5, ...)
          for i in $(seq 1 20); do
            CANDIDATE="$MAJOR.$MINOR.$((PATCH + i))"
            STATUS=$(curl -s -o /dev/null -w "%{http_code}" \
              "https://cdn.mendix.com/runtime/mxbuild-${CANDIDATE}.tar.gz")
            if [ "$STATUS" = "200" ]; then
              LATEST="$CANDIDATE"
            else
              break
            fi
          done

          # Check next minor version (e.g., 11.6.x -> 11.7.0)
          CANDIDATE="$MAJOR.$((MINOR + 1)).0"
          STATUS=$(curl -s -o /dev/null -w "%{http_code}" \
            "https://cdn.mendix.com/runtime/mxbuild-${CANDIDATE}.tar.gz")
          if [ "$STATUS" = "200" ]; then
            NEW_MINOR=$((MINOR + 1))
            LATEST="$CANDIDATE"
            for i in $(seq 1 20); do
              CANDIDATE="$MAJOR.$NEW_MINOR.$i"
              STATUS=$(curl -s -o /dev/null -w "%{http_code}" \
                "https://cdn.mendix.com/runtime/mxbuild-${CANDIDATE}.tar.gz")
              if [ "$STATUS" = "200" ]; then
                LATEST="$CANDIDATE"
              else
                break
              fi
            done
          fi

          if [ "$LATEST" = "$CURRENT" ]; then
            echo "No new Mendix version found (current: $CURRENT)"
            echo "found=false" >> "$GITHUB_OUTPUT"
          else
            echo "New Mendix version found: $LATEST (was: $CURRENT)"
            echo "found=true" >> "$GITHUB_OUTPUT"
            echo "version=$LATEST" >> "$GITHUB_OUTPUT"
          fi

      - name: Install JDK 21
        if: steps.check.outputs.found == 'true'
        uses: actions/setup-java@v4
        with:
          distribution: 'temurin'
          java-version: '21'

      - name: Download mxbuild
        if: steps.check.outputs.found == 'true'
        run: |
          VERSION="${{ steps.check.outputs.version }}"
          curl -fsSL "https://cdn.mendix.com/runtime/mxbuild-${VERSION}.tar.gz" \
            -o mxbuild.tar.gz
          mkdir -p mxbuild
          tar xzf mxbuild.tar.gz -C mxbuild

      - name: Create fresh Mendix project
        if: steps.check.outputs.found == 'true'
        run: |
          # Remove old project files
          rm -rf App.mpr mprcontents/

          # Create new blank project
          cd ${{ github.workspace }}
          ./mxbuild/modeler/mx create-project

          # Update version pin
          echo "${{ steps.check.outputs.version }}" > .mendix-version

      - name: Download mxcli and re-initialize
        if: steps.check.outputs.found == 'true'
        run: |
          MXCLI_VERSION=$(cat .mxcli-version)
          curl -fsSL "https://github.com/mendixlabs/mxcli/releases/download/${MXCLI_VERSION}/mxcli-linux-amd64" \
            -o /usr/local/bin/mxcli
          chmod +x /usr/local/bin/mxcli

          # Re-initialize (updates devcontainer to reference new Mendix version)
          mxcli init -p App.mpr --all-tools --force

      - name: Validate seed scripts
        if: steps.check.outputs.found == 'true'
        run: |
          FAILED=0
          for f in scripts/*.mdl; do
            echo "Checking $f..."
            if ! mxcli check "$f" 2>&1; then
              echo "WARNING: $f failed syntax check"
              FAILED=1
            fi
          done
          if [ "$FAILED" = "1" ]; then
            echo "::warning::Some seed scripts failed validation after Mendix version update"
          fi

      - name: Commit and push
        if: steps.check.outputs.found == 'true'
        run: |
          VERSION="${{ steps.check.outputs.version }}"
          git config user.name "mxcli-bot"
          git config user.email "mxcli-bot@mendix.com"
          git add -A
          git commit -m "chore: update Mendix project to $VERSION"
          git push origin main