Skip to content
tests

Add real MySQL and PostgreSQL coverage for ORM query and relationship test suites #1399

Sign in to view logs

Add real MySQL and PostgreSQL coverage for ORM query and relationship test suites

Add real MySQL and PostgreSQL coverage for ORM query and relationship test suites #1399

Workflow file for this run

.github/workflows/tests.yml at 62cdeaa
name: tests
on:
push:
branches:
- master
- '*.x'
pull_request:
schedule:
- cron: '0 0 * * *'
jobs:
linux_tests:
runs-on: ubuntu-24.04
services:
mysql:
image: mysql:5.7
env:
MYSQL_ALLOW_EMPTY_PASSWORD: yes
MYSQL_DATABASE: testing
ports:
- 33306:3306
options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3
redis:
image: redis:7.0
ports:
- 6379:6379
options: --entrypoint redis-server
strategy:
fail-fast: true
matrix:
php: [8.3, 8.4, 8.5]
phpunit: ['12.5.0', '12.5.8']
stability: [prefer-lowest, prefer-stable]
exclude:
- php: 8.3
phpunit: '12.0.0'
- php: 8.4
phpunit: '12.0.0'
- php: 8.5
phpunit: '12.0.0'
name: PHP ${{ matrix.php }} - PHPUnit ${{ matrix.phpunit }} - ${{ matrix.stability }}
steps:
- name: Checkout code
uses: actions/checkout@v4
- name: Setup PHP
uses: shivammathur/setup-php@v2
with:
php-version: ${{ matrix.php }}
extensions: dom, curl, libxml, mbstring, zip, pcntl, pdo, sqlite, pdo_sqlite, gd, redis, igbinary, msgpack, memcached, gmp, :php-psr
ini-values: error_reporting=E_ALL
tools: composer:v2
coverage: none
env:
REDIS_CONFIGURE_OPTS: --enable-redis --enable-redis-igbinary --enable-redis-msgpack --enable-redis-lzf --with-liblzf --enable-redis-zstd --with-libzstd --enable-redis-lz4 --with-liblz4
REDIS_LIBS: liblz4-dev, liblzf-dev, libzstd-dev
- name: Set Framework version
run: composer config version "2.x-dev"
- name: Install dependencies
uses: nick-fields/retry@v3
with:
timeout_minutes: 5
max_attempts: 5
command: composer update --${{ matrix.stability }} --prefer-dist --no-interaction --no-progress --with="phpunit/phpunit:~${{ matrix.phpunit }}"
- name: Execute tests
run: vendor/bin/phpunit --exclude-group database-external
env:
DB_PORT: ${{ job.services.mysql.ports[3306] }}
DB_USERNAME: root
database_driver_tests:
runs-on: ubuntu-24.04
services:
mysql:
image: mysql:5.7
env:
MYSQL_ALLOW_EMPTY_PASSWORD: yes
MYSQL_DATABASE: testing
ports:
- 33306:3306
options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3
postgres:
image: postgres:16
env:
POSTGRES_DB: testing
POSTGRES_USER: postgres
POSTGRES_PASSWORD: postgres
ports:
- 35432:5432
options: >-
--health-cmd="pg_isready -U postgres -d testing"
--health-interval=10s
--health-timeout=5s
--health-retries=5
strategy:
fail-fast: false
matrix:
driver: [mysql, pgsql]
name: External DB - ${{ matrix.driver }}
steps:
- name: Checkout code
uses: actions/checkout@v4
- name: Setup PHP
uses: shivammathur/setup-php@v2
with:
php-version: 8.5
extensions: dom, curl, libxml, mbstring, zip, pcntl, pdo, sqlite, pdo_sqlite, pdo_mysql, pgsql, pdo_pgsql
ini-values: error_reporting=E_ALL
tools: composer:v2
coverage: none
- name: Set Framework version
run: composer config version "2.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 --with="phpunit/phpunit:~12.5.8"
- name: Execute MySQL model query tests
if: matrix.driver == 'mysql'
run: vendor/bin/phpunit --group mysql
env:
DOPPAR_TEST_MYSQL_HOST: 127.0.0.1
DOPPAR_TEST_MYSQL_PORT: ${{ job.services.mysql.ports[3306] }}
DOPPAR_TEST_MYSQL_DATABASE: testing
DOPPAR_TEST_MYSQL_USERNAME: root
DOPPAR_TEST_MYSQL_PASSWORD: ''
DOPPAR_TEST_MYSQL_CHARSET: utf8mb4
- name: Execute PostgreSQL model query tests
if: matrix.driver == 'pgsql'
run: vendor/bin/phpunit --group pgsql
env:
DOPPAR_TEST_PGSQL_HOST: 127.0.0.1
DOPPAR_TEST_PGSQL_PORT: ${{ job.services.postgres.ports[5432] }}
DOPPAR_TEST_PGSQL_DATABASE: testing
DOPPAR_TEST_PGSQL_USERNAME: postgres
DOPPAR_TEST_PGSQL_PASSWORD: postgres
- name: Store artifacts
if: always()
uses: actions/upload-artifact@v4
with:
name: external-db-logs-${{ matrix.driver }}
path: |
vendor/orchestra/testbench-core/doppar/storage/logs
!vendor/**/.gitignore
windows_tests:
runs-on: windows-2022
strategy:
fail-fast: true
matrix:
php: [8.3, 8.4, 8.5]
phpunit: ['12.5.0', '12.5.8']
stability: [prefer-lowest, prefer-stable]
exclude:
- php: 8.3
phpunit: '12.0.0'
- php: 8.4
phpunit: '12.0.0'
- php: 8.5
phpunit: '12.0.0'
name: PHP ${{ matrix.php }} - PHPUnit ${{ matrix.phpunit }} - ${{ matrix.stability }} - Windows
steps:
- name: Set git to use LF
run: |
git config --global core.autocrlf false
git config --global core.eol lf
- name: Checkout code
uses: actions/checkout@v4
- name: Setup PHP
uses: shivammathur/setup-php@v2
with:
php-version: ${{ matrix.php }}
extensions: dom, curl, libxml, mbstring, zip, pdo, sqlite, pdo_sqlite, gd, pdo_mysql, fileinfo, ftp, redis, memcached, gmp, intl, :php-psr
tools: composer:v2
coverage: none
- name: Set Framework version
run: composer config version "2.x-dev"
- name: Install dependencies
uses: nick-fields/retry@v3
with:
timeout_minutes: 5
max_attempts: 5
command: composer update --${{ matrix.stability }} --prefer-dist --no-interaction --no-progress --with="phpunit/phpunit:~${{ matrix.phpunit }}"
- name: Execute tests
run: vendor/bin/phpunit --exclude-group database-external
- name: Store artifacts
if: always()
uses: actions/upload-artifact@v4
with:
name: windows-logs-${{ matrix.php }}-${{ matrix.phpunit }}-${{ matrix.stability }}
path: |
vendor/orchestra/testbench-core/doppar/storage/logs
!vendor/**/.gitignore