release.yml

name: Release

on:
  push:
    tags:
      - 'v*'

jobs:
  release:
    runs-on: windows-latest
    permissions:
      contents: write

    steps:
      - uses: actions/checkout@v4

      - name: Use Node.js 22.x
        uses: actions/setup-node@v4
        with:
          node-version: 22.x
          cache: 'npm'

      - name: Install dependencies
        run: npm ci

      - name: Check Version
        run: |
          $tag = $env:GITHUB_REF -replace 'refs/tags/v', ''
          $pkg = Get-Content package.json | ConvertFrom-Json
          if ($pkg.version -ne $tag) {
            Write-Error "Version mismatch: Tag $tag vs Package $($pkg.version)"
            exit 1
          }

      - name: Build
        run: npm run build

      - name: Package (SEA)
        run: npm run package

      - name: Install Inno Setup
        run: choco install innosetup -y --no-progress

      - name: Build Installer
        run: npm run installer

      - name: Generate Docs
        run: npm run docs:generate

      - name: Stage Artifacts
        run: npm run stage

      - name: Verify Artifacts
        run: |
          if (-not (Test-Path artifacts/cloudsqlctl.exe)) { throw "Missing cloudsqlctl.exe" }
          if (-not (Test-Path artifacts/cloudsqlctl-setup.exe)) { throw "Missing cloudsqlctl-setup.exe" }
          if (-not (Test-Path artifacts/cloudsqlctl-windows-x64.zip)) { throw "Missing zip bundle" }
          if (-not (Test-Path artifacts/SHA256SUMS.txt)) { throw "Missing SHA256SUMS.txt" }

      - name: Delete existing release assets (same tag)
        shell: pwsh
        env:
          GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
        run: |
          $tag = $env:GITHUB_REF -replace 'refs/tags/', ''
          $headers = @{
            Authorization = "Bearer $env:GITHUB_TOKEN"
            Accept = "application/vnd.github+json"
          }
          try {
            $release = Invoke-RestMethod -Method Get -Uri "https://api.github.com/repos/$env:GITHUB_REPOSITORY/releases/tags/$tag" -Headers $headers
          } catch {
            if ($_.Exception.Response.StatusCode.value__ -eq 404) {
              Write-Host "No existing release for $tag"
              exit 0
            }
            throw
          }

          if (-not $release) {
            Write-Host "No existing release data for $tag"
            exit 0
          }

          foreach ($asset in $release.assets) {
            Write-Host "Deleting asset $($asset.name)"
            Invoke-RestMethod -Method Delete -Uri "https://api.github.com/repos/$env:GITHUB_REPOSITORY/releases/assets/$($asset.id)" -Headers $headers
          }

      - name: Release
        uses: softprops/action-gh-release@v2
        if: startsWith(github.ref, 'refs/tags/')
        with:
          files: artifacts/*
          generate_release_notes: true