release.yml

name: Release

on:
  workflow_run:
    workflows: [Build]
    types: [completed]
    branches: [main]

permissions:
  contents: write
  actions: read

defaults:
  run:
    shell: bash

jobs:
  check_commit:
    name: Check Commit
    runs-on: ubuntu-latest
    outputs:
      IS_RELEASE: ${{ steps.check_msg.outputs.IS_RELEASE }}
    steps:
      - uses: actions/checkout@v4
        with:
          ref: ${{ github.event.workflow_run.head_sha }}

      - name: Check latest commit message
        id: check_msg
        run: |
          LATEST_COMMIT_MSG=$(git log -1 --pretty=%B)
          if echo "$LATEST_COMMIT_MSG" | grep -q "Release Prep v"; then
            echo "IS_RELEASE=true" >> $GITHUB_OUTPUT
          else
            echo "IS_RELEASE=false" >> $GITHUB_OUTPUT
          fi

  release:
    name: Release
    needs: [check_commit]
    if: ${{ needs.check_commit.outputs.IS_RELEASE == 'true' }}
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v4
        with:
          fetch-depth: 0
          ref: ${{ github.event.workflow_run.head_sha }}

      - name: Extract version and find wasm artifact
        id: find-artifact
        env:
          GH_TOKEN: ${{ secrets.GITHUB_TOKEN }}
        run: |
          VERSION=$(git log -1 --pretty=%B | grep -oP 'Release Prep \Kv[0-9]+\.[0-9]+\.[0-9]+')
          echo "version=$VERSION" >> $GITHUB_OUTPUT

          ARTIFACT_NAME="wasm-${VERSION}"
          RUN_ID=$(gh api "/repos/${{ github.repository }}/actions/artifacts?per_page=100" \
            --jq "[.artifacts[] | select(.name == \"${ARTIFACT_NAME}\") | .workflow_run.id][0]")

          if [ -z "$RUN_ID" ]; then
            echo "Error: Could not find artifact ${ARTIFACT_NAME} in any workflow run" >&2
            exit 1
          fi

          echo "Found ${ARTIFACT_NAME} in workflow run: $RUN_ID"
          echo "run-id=$RUN_ID" >> $GITHUB_OUTPUT

      - name: Download wasm
        uses: dawidd6/action-download-artifact@v6
        with:
          github_token: ${{ secrets.GITHUB_TOKEN }}
          run_id: ${{ steps.find-artifact.outputs.run-id }}
          name: wasm-${{ steps.find-artifact.outputs.version }}

      - name: Calculate sha256
        run: |
          SHA256_HASH=$(sha256sum plugin.wasm | awk '{ print $1 }')
          echo "SHA256_HASH=${SHA256_HASH}" >> $GITHUB_ENV

      - name: Reconstruct release notes from PRs
        id: notes
        env:
          GH_TOKEN: ${{ secrets.GITHUB_TOKEN }}
          OWNER: ${{ github.repository_owner }}
          REPO: ${{ github.event.repository.name }}
        run: |
          VERSION=${{ steps.find-artifact.outputs.version }}
          PREVIOUS_TAG=$(git tag --sort=-v:refname | head -1)

          NOTES_FILE=$(mktemp)
          echo "notes-file=$NOTES_FILE" >> $GITHUB_OUTPUT

          ./scripts/generate-release-notes.sh \
            "$PREVIOUS_TAG" "$VERSION" "$SHA256_HASH" \
            --file "$NOTES_FILE"

      - name: Create release and upload asset
        env:
          GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
        run: |
          NEW_TAG=${{ steps.find-artifact.outputs.version }}
          mv plugin.wasm sqlc-gen-csharp.wasm

          echo "Creating release ${NEW_TAG}..."
          gh release create ${NEW_TAG} \
            sqlc-gen-csharp.wasm \
            --title "${NEW_TAG}" \
            --notes-file "${{ steps.notes.outputs.notes-file }}"

          echo "Release ${NEW_TAG} published successfully"