Release 4.0.0 #22
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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: | | |
| mkdir -p static-analysis | |
| ./vendor/bin/phpstan analyse --configuration phpstan.neon.dist --memory-limit=1G --no-progress --error-format=raw > 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 |