release.yml

name: Release Binary

on:
  workflow_dispatch:

permissions:
  contents: write

env:
  # Need these guys for cross-compilation
  CARGO_TARGET_AARCH64_UNKNOWN_LINUX_GNU_LINKER: aarch64-linux-gnu-gcc
  CARGO_TARGET_AARCH64_UNKNOWN_LINUX_MUSL_LINKER: aarch64-linux-gnu-gcc

jobs:
  # windows does not run git cliff so we need to do it here
  extract_version:
    name: Extract Version
    runs-on: ubuntu-latest
    outputs:
      version: ${{ steps.set_version.outputs.version }}

    steps:
      - uses: actions/checkout@v4
        with:
          fetch-depth: 0

      - name: Set up git-cliff
        uses: kenji-miyake/setup-git-cliff@v1

      - name: Set version name
        id: set_version
        run: echo "version=$(git cliff --bumped-version)" >> "$GITHUB_OUTPUT"

  wasm:
    name: Build & Test WASM
    runs-on: ubuntu-22.04
    steps:
      - uses: actions/checkout@v4
        with:
          submodules: true

      - name: Install Nix
        uses: DeterminateSystems/nix-installer-action@main

      - name: Setup Magic Nix Cache
        uses: DeterminateSystems/magic-nix-cache-action@main

      - uses: oven-sh/setup-bun@v2
        with:
          bun-version: "1.3.11"

      - name: Install dependencies
        run: bun install

      - name: Build WASM
        run: nix develop --command bash -c "bun run build"
        working-directory: packages/@postgres-language-server/wasm

      - name: Run Tests
        run: bun test
        working-directory: packages/@postgres-language-server/wasm

      - name: Install Playwright
        run: bun run test:e2e:install
        working-directory: packages/@postgres-language-server/wasm

      - name: Run E2E Tests
        run: bun run test:e2e
        working-directory: packages/@postgres-language-server/wasm

      - name: Upload WASM Artifacts
        uses: actions/upload-artifact@v4
        with:
          name: wasm
          path: |
            packages/@postgres-language-server/wasm/wasm/pgls.js
            packages/@postgres-language-server/wasm/wasm/pgls.wasm
          if-no-files-found: error

  build_and_test:
    name: Build & Test for ${{ matrix.config.target }}
    needs: extract_version
    strategy:
      matrix:
        config:
          - { os: ubuntu-22.04, target: x86_64-unknown-linux-gnu }
          - { os: ubuntu-22.04, target: aarch64-unknown-linux-gnu }
          - { os: macos-14, target: x86_64-apple-darwin }
          - { os: macos-14, target: aarch64-apple-darwin }
          - { os: windows-2022, target: x86_64-pc-windows-msvc }
          - { os: windows-2022, target: aarch64-pc-windows-msvc }
          - { os: ubuntu-22.04, target: x86_64-unknown-linux-musl }

    runs-on: ${{ matrix.config.os }}

    steps:
      - uses: actions/checkout@v4
        with:
          submodules: true

      - uses: actions-rust-lang/setup-rust-toolchain@v1
        with:
          target: ${{ matrix.config.target }}

      - uses: Swatinem/rust-cache@v2
        id: rust-cache

      # The Aarch64 Linux is a special snowflake, we need to install its toolchain
      - name: Install arm64 toolchain
        if: matrix.config.target == 'aarch64-unknown-linux-gnu'
        run: |
          sudo apt-get update
          sudo apt-get install -y gcc-aarch64-linux-gnu

      - name: Install musl toolchain
        if: matrix.config.target == 'x86_64-unknown-linux-musl'
        run: |
          sudo apt-get update
          sudo apt-get install -y musl-tools

      - uses: actions/cache@v5
        with:
          path: |
            ~/.cargo/bin/tree-sitter
            target/**/build/pgls_treesitter_grammar-*/out/generated
          key: ${{ runner.os }}-tree-sitter-${{ hashFiles('.tree-sitter-cli-version', 'crates/pgls_treesitter_grammar/grammar.js', 'crates/pgls_treesitter_grammar/tree-sitter.json', 'rust-toolchain.toml', 'Cargo.lock') }}

      - name: Setup tree-sitter
        run: command -v tree-sitter || cargo install tree-sitter-cli --version "$(cat .tree-sitter-cli-version)" --locked
        shell: bash

      - name: Setup Postgres
        uses: ./.github/actions/setup-postgres

      - name: 🧪 Run Tests
        run: cargo test --release
        env:
          DATABASE_URL: postgres://postgres:postgres@localhost:5432/postgres

      - name: 🛠️ Run Build
        run: cargo build -p pgls_cli --release --target ${{ matrix.config.target }}
        env:
          # Strip all debug symbols from the resulting binaries
          RUSTFLAGS: "-C strip=symbols -C codegen-units=1"
          # Inline the version in the CLI binary
          PGT_VERSION: ${{ needs.extract_version.outputs.version }}

      # windows is a special snowflake too, it saves binaries as .exe
      - name: 👦 Name the Binary
        if: matrix.config.os == 'windows-2022'
        run: |
          mkdir dist
          # deprecated
          cp target/${{ matrix.config.target }}/release/postgrestools.exe ./dist/postgrestools_${{ matrix.config.target }}.exe
          cp target/${{ matrix.config.target }}/release/postgres-language-server.exe ./dist/postgres-language-server_${{ matrix.config.target }}.exe

      - name: 👦 Name the Binary
        if: matrix.config.os != 'windows-2022'
        run: |
          mkdir dist
          # deprecated
          cp target/${{ matrix.config.target }}/release/postgrestools ./dist/postgrestools_${{ matrix.config.target }}
          cp target/${{ matrix.config.target }}/release/postgres-language-server ./dist/postgres-language-server_${{ matrix.config.target }}

      # It is not possible to return the artifacts from the matrix jobs individually: Matrix outputs overwrite each other.
      # A common workaround is to upload and download the resulting artifacts.
      - name: 👆 Upload Artifacts (deprecated)
        id: upload-artifacts-deprecated
        uses: actions/upload-artifact@v4
        with:
          name: postgrestools_${{ matrix.config.target }}
          path: ./dist/postgrestools_*
          # The default compression level is 6; this took the binary down from 350 to 330MB.
          # It is recommended to use a lower level for binaries, since the compressed result is not much smaller,
          # and the higher levels of compression take much longer.
          compression-level: 2
          if-no-files-found: error

      # It is not possible to return the artifacts from the matrix jobs individually: Matrix outputs overwrite each other.
      # A common workaround is to upload and download the resulting artifacts.
      - name: 👆 Upload Artifacts
        id: upload-artifacts
        uses: actions/upload-artifact@v4
        with:
          name: postgres-language-server_${{ matrix.config.target }}
          path: ./dist/postgres-language-server_*
          # The default compression level is 6; this took the binary down from 350 to 330MB.
          # It is recommended to use a lower level for binaries, since the compressed result is not much smaller,
          # and the higher levels of compression take much longer.
          compression-level: 2
          if-no-files-found: error

  create_changelog_and_release:
    runs-on: ubuntu-latest
    needs: [extract_version, build_and_test, wasm]
    steps:
      - name: Checkout Repo
        uses: actions/checkout@v4
        with:
          # we need all commits to create a changelog
          fetch-depth: 0

      - name: 📝 Create Changelog
        uses: orhun/git-cliff-action@v4
        id: create_changelog
        with:
          config: cliff.toml
          args: --bump --unreleased
        env:
          GITHUB_REPO: ${{ github.repository }}

      - name: Ensure tag matches
        if: steps.create_changelog.outputs.version != needs.extract_version.outputs.version
        run: |
          echo "Tag does not match: ${{ steps.create_changelog.outputs.version }} vs ${{ needs.extract_version.outputs.version }}"
          exit 1

      - name: 👇 Download Artifacts (deprecated)
        uses: actions/download-artifact@v4
        id: download-deprecated
        with:
          merge-multiple: true
          pattern: postgrestools_*

      - name: 👇 Download Artifacts
        uses: actions/download-artifact@v4
        id: download
        with:
          merge-multiple: true
          pattern: postgres-language-server_*

      - name: 👇 Download WASM Artifacts
        uses: actions/download-artifact@v4
        with:
          name: wasm
          path: wasm-assets

      - name: Prepare WASM Assets
        run: |
          cp wasm-assets/pgls.js ./pgls.js
          cp wasm-assets/pgls.wasm ./pgls.wasm

      - name: 📂 Create Release
        uses: softprops/action-gh-release@v2
        id: create-release
        env:
          GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
        with:
          token: ${{ secrets.GITHUB_TOKEN }}
          body: ${{ steps.create_changelog.outputs.content }}
          tag_name: ${{ steps.create_changelog.outputs.version }}
          files: |
            postgrestools_*
            postgres-language-server_*
            pgls.js
            pgls.wasm
            docs/schema.json
          fail_on_unmatched_files: true
          draft: true

      - name: ✅ Output Link to Workflow Summary
        run: |
          {
            echo "# 🚀 Release completed!"
            echo ""
            echo "Here is the URL to the Release Draft:"
            echo ""
            echo "[Link](${{ steps.create-release.outputs.url }})"
            echo ""
          } >> "$GITHUB_STEP_SUMMARY"