mysql

Fix #227 #431

	on:
	pull_request:
	paths-ignore:
	- 'docs/**'
	- 'README.md'
	- 'CHANGELOG.md'
	- '.gitignore'
	- '.gitattributes'
	- 'infection.json.dist'
	- 'psalm.xml'

	push:
	branches: ['master']
	paths-ignore:
	- 'docs/**'
	- 'README.md'
	- 'CHANGELOG.md'
	- '.gitignore'
	- '.gitattributes'
	- 'infection.json.dist'
	- 'psalm.xml'

	name: mysql

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

	jobs:
	tests:
	name: PHP ${{ matrix.php }}-${{ matrix.mysql }}

	env:
	extensions: pdo, pdo_mysql

	runs-on: ${{ matrix.os }}

	strategy:
	matrix:
	os:
	- ubuntu-latest

	php:
	- 8.0
	- 8.1
	- 8.2

	mysql:
	- mysql:5.7
	- mysql:latest

	services:
	mysql:
	image: ${{ matrix.mysql }}
	env:
	MYSQL_ALLOW_EMPTY_PASSWORD: true
	MYSQL_PASSWORD: ''
	MYSQL_DATABASE: yiitest
	ports:
	- 3306:3306
	options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3

	steps:
	- name: Checkout.
	uses: actions/checkout@v3

	- name: Install PHP with extensions.
	uses: shivammathur/setup-php@v2
	with:
	php-version: ${{ matrix.php }}
	extensions: ${{ env.extensions }}
	ini-values: date.timezone='UTC'
	coverage: pcov

	- name: Update composer.
	run: composer self-update

	- name: Install db-mysql.
	run: composer require yiisoft/db-mysql:^1.0 --prefer-dist --no-interaction --no-progress --optimize-autoloader --ansi

	- name: Run tests with phpunit.
	run: vendor/bin/phpunit --testsuite=Mysql --coverage-clover=coverage.xml --colors=always

	- name: Upload coverage to Codecov.
	if: matrix.php == '8.1'
	uses: codecov/codecov-action@v3
	with:
	token: ${{ secrets.CODECOV_TOKEN }}
	files: ./coverage.xml

Provide feedback