pest.yml

name: Tests

on:
    push:
        branches:
            - master
    pull_request:

jobs:
    test:
        name: Pest - PHP ${{ matrix.php }} - Laravel ${{ matrix.laravel }} - DB ${{ matrix.db }} ${{ matrix.dependency-version }}

        runs-on: ubuntu-latest

        strategy:
            fail-fast: false
            matrix:
                php: [ 8.3, 8.2, 8.1 ]
                laravel: [ 11.*, 10.* ]
                db: [ 'mysql:8.0', 'mysql:5.7', 'mariadb:10.11', 'postgis/postgis:16-3.4', 'postgis/postgis:15-3.4', 'postgis/postgis:14-3.4', 'postgis/postgis:13-3.4', 'postgis/postgis:12-3.4' ]
                dependency-version: [ prefer-stable ]
                include:
                    -   laravel: 10.*
                        testbench: ^8.0
                    -   laravel: 11.*
                        testbench: ^9.0
                exclude:
                    -   laravel: 11.*
                        php: 8.1

        services:
            db:
                image: ${{ matrix.db }}
                env:
                    MYSQL_ALLOW_EMPTY_PASSWORD: yes
                    MYSQL_DATABASE: laravel_eloquent_spatial_test
                    POSTGRES_DB: laravel_eloquent_spatial_test
                    POSTGRES_USER: root
                    POSTGRES_HOST_AUTH_METHOD: trust
                ports:
                    - ${{ contains(matrix.db, 'postgis') && '5432' || '3306' }}
                options: >-
                    ${{ (contains(matrix.db, 'postgis') && '--health-cmd="pg_isready"') || '--health-cmd="mysqladmin ping"' }}
                    --health-interval=10s --health-timeout=5s --health-retries=3

        steps:
            -   name: Checkout code
                uses: actions/checkout@v2

            -   name: Setup PHP
                uses: shivammathur/setup-php@v2
                with:
                    php-version: ${{ matrix.php }}
                    coverage: none

            -   name: Install dependencies
                run: |
                    composer require "laravel/framework:${{ matrix.laravel }}" "orchestra/testbench:${{ matrix.testbench }}" --no-interaction --no-update
                    composer update --${{ matrix.dependency-version }} --prefer-dist --no-interaction

            -   name: Set DB_CONNECTION env variable (PostGIS)
                if: contains(matrix.db, 'postgis')
                run: |
                    echo "DB_CONNECTION=pgsql" >> "$GITHUB_ENV"

            -   name: Set DB_CONNECTION env variable (MariaDB & Laravel 11)
                if: contains(matrix.laravel, '11') && contains(matrix.db, 'mariadb')
                run: |
                    echo "DB_CONNECTION=mariadb" >> "$GITHUB_ENV"

            -   name: Set DB_COLLATION env variable (Mysql 5.7 & Laravel 11)
                if: contains(matrix.laravel, '11') && contains(matrix.db, 'mysql:5.7')
                run: |
                    echo "DB_COLLATION=utf8mb4_unicode_ci" >> "$GITHUB_ENV"

            -   name: Execute tests
                env:
                    DB_PORT: ${{ job.services.db.ports[contains(matrix.db, 'postgis') && '5432' || '3306'] }}
                    DB_CONNECTION: ${{ env.DB_CONNECTION || 'mysql' }}
                run: vendor/bin/pest