ci.yml

name: CI

on:
  pull_request:
  push:
    branches:
      - master

concurrency:
  group: ci-${{ github.workflow }}-${{ github.ref }}
  cancel-in-progress: true

jobs:
  test:
    name: PHP ${{ matrix.php }} / ${{ matrix.driver }} / ${{ matrix.search_build }}
    runs-on: ubuntu-22.04
    timeout-minutes: 30
    permissions:
      contents: read
      packages: read
    strategy:
      fail-fast: false
      matrix:
        php: ['8.2', '8.3']
        driver: [mysqli, pdo]
        search_build: [SPHINX2, SPHINX3, MANTICORE]
    env:
      DRIVER: ${{ matrix.driver }}
      SEARCH_BUILD: ${{ matrix.search_build }}
      COVERAGE_LANE: ${{ matrix.php == '8.3' && matrix.driver == 'pdo' && matrix.search_build == 'MANTICORE' }}

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

      - name: Setup PHP
        if: env.COVERAGE_LANE != 'true'
        uses: shivammathur/setup-php@v2
        with:
          php-version: ${{ matrix.php }}
          coverage: none
          extensions: mysqli, pdo_mysql, mbstring
          tools: composer:v2

      - name: Setup PHP (coverage lane)
        if: env.COVERAGE_LANE == 'true'
        uses: shivammathur/setup-php@v2
        with:
          php-version: ${{ matrix.php }}
          coverage: xdebug
          extensions: mysqli, pdo_mysql, mbstring
          tools: composer:v2

      - name: Resolve search image and group exclusions
        id: vars
        run: |
          EXCLUDE_GROUP=""
          SEARCH_IMAGE=""
          SEARCH_DOCKERFILE=""
          case "$SEARCH_BUILD" in
            SPHINX2)
              SEARCH_IMAGE="ghcr.io/foolcode/sphinxql-query-builder-search-sphinx2:sphinx2-latest"
              SEARCH_DOCKERFILE="docker/search/sphinx2/Dockerfile"
              EXCLUDE_GROUP="--exclude-group=Manticore"
              ;;
            SPHINX3)
              SEARCH_IMAGE="ghcr.io/foolcode/sphinxql-query-builder-search-sphinx3:sphinx3-latest"
              SEARCH_DOCKERFILE="docker/search/sphinx3/Dockerfile"
              EXCLUDE_GROUP="--exclude-group=Manticore"
              ;;
            MANTICORE)
              SEARCH_IMAGE="ghcr.io/foolcode/sphinxql-query-builder-search-manticore:manticore-latest"
              SEARCH_DOCKERFILE="docker/search/manticore/Dockerfile"
              ;;
            *)
              echo "Unknown SEARCH_BUILD: $SEARCH_BUILD"
              exit 1
              ;;
          esac
          {
            echo "search_image=$SEARCH_IMAGE"
            echo "search_dockerfile=$SEARCH_DOCKERFILE"
            echo "exclude_group=$EXCLUDE_GROUP"
          } >> "$GITHUB_OUTPUT"

      - name: Fetch search image
        run: |
          if ! docker pull "${{ steps.vars.outputs.search_image }}"; then
            echo "Unable to pull image, building from repository Dockerfile fallback."
            docker build -f "${{ steps.vars.outputs.search_dockerfile }}" -t "${{ steps.vars.outputs.search_image }}" .
          fi

      - name: Start search daemon container
        run: |
          docker run -d --name searchd \
            -p 9307:9307 \
            -p 9312:9312 \
            "${{ steps.vars.outputs.search_image }}"

      - name: Wait for searchd
        run: |
          n=0
          while [ "$n" -lt 60 ]; do
            if php -r '
              try {
                $pdo = new PDO("mysql:host=127.0.0.1;port=9307", "", "");
                $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                $pdo->query("SHOW TABLES");
                exit(0);
              } catch (Throwable $exception) {
                exit(1);
              }
            ' >/dev/null 2>&1; then
              exit 0
            fi
            n=$((n + 1))
            sleep 1
          done
          echo "searchd did not become SQL-ready on 127.0.0.1:9307"
          docker logs searchd || true
          exit 1

      - name: Validate composer metadata
        run: composer validate --strict --no-check-publish

      - name: Install dependencies
        run: composer install --prefer-dist --no-interaction --no-progress

      - name: Prepare autoload
        run: composer dump-autoload

      - name: Run PHPStan
        if: env.COVERAGE_LANE == 'true'
        run: |
          set -o pipefail
          mkdir -p static-analysis
          ./vendor/bin/phpstan analyse --configuration phpstan.neon.dist --memory-limit=1G --no-progress --error-format=raw 2>&1 | tee static-analysis/phpstan.txt

      - name: Run tests
        run: |
          if [ "${COVERAGE_LANE}" = "true" ]; then
            mkdir -p coverage
            ./vendor/bin/phpunit --configuration "tests/travis/${DRIVER}.phpunit.xml" --coverage-text --coverage-clover coverage/clover.xml ${{ steps.vars.outputs.exclude_group }}
          else
            ./vendor/bin/phpunit --configuration "tests/travis/${DRIVER}.phpunit.xml" --coverage-text ${{ steps.vars.outputs.exclude_group }}
          fi

      - name: Build changed-line coverage artifact
        if: always() && env.COVERAGE_LANE == 'true'
        continue-on-error: true
        run: |
          mkdir -p coverage-artifact

          BASE_SHA=""
          BASE_LABEL=""

          if [ "${{ github.event_name }}" = "pull_request" ]; then
            BASE_SHA="${{ github.event.pull_request.base.sha }}"
            BASE_LABEL="PR base (${BASE_SHA})"
          else
            BASE_SHA="${{ github.event.before }}"
            BASE_LABEL="push before (${BASE_SHA})"
          fi

          if [ -z "${BASE_SHA}" ] \
            || [ "${BASE_SHA}" = "0000000000000000000000000000000000000000" ] \
            || ! git cat-file -e "${BASE_SHA}^{commit}" 2>/dev/null; then
            DEFAULT_BRANCH="${{ github.event.repository.default_branch }}"
            if git show-ref --verify --quiet "refs/remotes/origin/${DEFAULT_BRANCH}"; then
              BASE_SHA="$(git merge-base "origin/${DEFAULT_BRANCH}" HEAD)"
              BASE_LABEL="merge-base (origin/${DEFAULT_BRANCH})"
            elif git cat-file -e "HEAD~1^{commit}" 2>/dev/null; then
              BASE_SHA="$(git rev-parse HEAD~1)"
              BASE_LABEL="fallback (HEAD~1)"
            else
              BASE_SHA="$(git rev-parse HEAD)"
              BASE_LABEL="fallback (HEAD)"
            fi
          fi

          git diff --unified=0 "${BASE_SHA}"...HEAD > coverage-artifact/changed-lines.patch || true
          git diff --name-only "${BASE_SHA}"...HEAD > coverage-artifact/changed-files.txt || true

          ADDED_LINES="$(git diff --numstat "${BASE_SHA}"...HEAD | awk '{a+=$1} END {print a+0}')"
          REMOVED_LINES="$(git diff --numstat "${BASE_SHA}"...HEAD | awk '{d+=$2} END {print d+0}')"
          CHANGED_FILES="$(wc -l < coverage-artifact/changed-files.txt | tr -d ' ')"

          {
            echo "Changed-line coverage artifact summary"
            echo "Event: ${{ github.event_name }}"
            echo "Base: ${BASE_LABEL}"
            echo "Head: $(git rev-parse HEAD)"
            echo "Changed files: ${CHANGED_FILES}"
            echo "Added lines: ${ADDED_LINES}"
            echo "Removed lines: ${REMOVED_LINES}"
            if [ -f coverage/clover.xml ]; then
              echo "Clover XML: coverage/clover.xml"
            else
              echo "Clover XML: missing"
            fi
          } > coverage-artifact/summary.txt

      - name: Upload changed-line coverage artifact
        if: always() && env.COVERAGE_LANE == 'true'
        continue-on-error: true
        uses: actions/upload-artifact@v4
        with:
          name: changed-line-coverage-php${{ matrix.php }}-${{ matrix.driver }}-${{ matrix.search_build }}
          if-no-files-found: warn
          path: |
            coverage/clover.xml
            static-analysis/phpstan.txt
            coverage-artifact/summary.txt
            coverage-artifact/changed-lines.patch
            coverage-artifact/changed-files.txt

      - name: Upload debug artifacts on failure
        if: failure()
        uses: actions/upload-artifact@v4
        with:
          name: ci-debug-php${{ matrix.php }}-${{ matrix.driver }}-${{ matrix.search_build }}
          if-no-files-found: ignore
          path: |
            tests/searchd.log
            tests/searchd.pid
            tests/data/*

      - name: Show searchd logs
        if: always()
        run: docker logs searchd || true

      - name: Stop searchd container
        if: always()
        run: docker rm -f searchd || true