ci.yaml

name: run-tests

on:
  push:
  pull_request:

jobs:
    mysql_8:
        runs-on: ubuntu-24.04
        timeout-minutes: 5

        services:
            mysql:
            image: mysql:8
            env:
                MYSQL_ALLOW_EMPTY_PASSWORD: yes
                MYSQL_DATABASE: laravel
                MYSQL_ROOT_PASSWORD: root
            ports:
                - 3306:3306
            options: --default-authentication-plugin=mysql_native_password --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3

        strategy:
            fail-fast: true
            matrix:
                php: [ 8.1, 8.2, 8.3 ]
                laravel: [ 10.*, 11.* ]
                include:
                    -   laravel: 11.*
                        testbench: 9.*-dev
                    -   laravel: 10.*
                        testbench: 8.*
                exclude:
                    -   laravel: 11.*
                        php: 8.1

        name: MySQL 8 - PHP ${{ matrix.php }} - Laravel ${{ matrix.laravel }}

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

            -   name: Setup PHP
                uses: shivammathur/setup-php@v2
                with:
                    php-version: 8.2
                    extensions: dom, curl, libxml, mbstring, zip, pcntl, pdo, pdo_mysql, :php-psr
                    tools: composer:v2
                    coverage: none

            -   name: Set Framework version
                run: composer config version "11.x-dev"

            -   name: Install dependencies
                uses: nick-fields/retry@v3
                with:
                    timeout_minutes: 5
                    max_attempts: 5
                    command: composer update --prefer-stable --prefer-dist --no-interaction --no-progress

            -   name: Execute tests
                run: vendor/bin/phpunit
                env:
                    DB_CONNECTION: mysql

    pgsql_15:
        runs-on: ubuntu-24.04
        timeout-minutes: 5

        services:
            postgresql:
                image: postgres:15
                env:
                    POSTGRES_DB: laravel
                    POSTGRES_USER: laravel
                    POSTGRES_PASSWORD: password
                ports:
                    - 5432:5432
                options: --health-cmd=pg_isready --health-interval=10s --health-timeout=5s --health-retries=3

        strategy:
            fail-fast: true
            matrix:
                php: [ 8.1, 8.2, 8.3 ]
                laravel: [ 10.*, 11.* ]
                include:
                    -   laravel: 11.*
                        testbench: 9.*-dev
                    -   laravel: 10.*
                        testbench: 8.*
                exclude:
                    -   laravel: 11.*
                        php: 8.1

        name: PostgreSQL 15 - PHP ${{ matrix.php }} - Laravel ${{ matrix.laravel }}

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

            -   name: Cache dependencies
                uses: actions/cache@v1
                with:
                    path: ~/.composer/cache/files
                    key: dependencies-pw-v2-${{ matrix.laravel }}-php-${{ matrix.php }}-composer-${{ hashFiles('composer.json') }}

            -   name: Setup PHP
                uses: shivammathur/setup-php@v2
                with:
                    php-version: ${{ matrix.php }}
                    extensions: curl, mbstring, zip, pcntl, pdo, sqlite, pdo_sqlite, iconv
                    coverage: none
                    tools: composer:v2

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

            -   name: Execute tests
                run: vendor/bin/phpunit
                env:
                    DB_CONNECTION: pgsql
                    DB_DATABASE: laravel
                    DB_USERNAME: laravel
                    DB_PASSWORD: password

    sqlite:
        runs-on: ubuntu-24.04
        timeout-minutes: 5

        strategy:
            fail-fast: true
            matrix:
                php: [ 8.1, 8.2, 8.3 ]
                laravel: [ 10.*, 11.* ]
                include:
                    -   laravel: 11.*
                        testbench: 9.*-dev
                    -   laravel: 10.*
                        testbench: 8.*
                exclude:
                    -   laravel: 11.*
                        php: 8.1

        name: SQLite - PHP ${{ matrix.php }} - Laravel ${{ matrix.laravel }}

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

            -   name: Cache dependencies
                uses: actions/cache@v1
                with:
                    path: ~/.composer/cache/files
                    key: dependencies-pw-v2-${{ matrix.laravel }}-php-${{ matrix.php }}-composer-${{ hashFiles('composer.json') }}

            -   name: Setup PHP
                uses: shivammathur/setup-php@v2
                with:
                    php-version: ${{ matrix.php }}
                    extensions: curl, mbstring, zip, pcntl, pdo, sqlite, pdo_sqlite, iconv
                    coverage: none
                    tools: composer:v2

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

            -   name: Setup SQLite Database
                run: php vendor/bin/testbench package:create-sqlite-db

            -   name: Execute tests
                run: vendor/bin/phpunit
                env:
                    DB_CONNECTION: sqlite