Test with PDO instead #77

	name: PHP Composer
	on: [push, pull_request]
	jobs:
	build:
	name: Run tests on ${{ matrix.php }}
	runs-on: ubuntu-latest

	strategy:
	matrix:
	php: [ '8.1', '8.2', '8.3' ]

	services:
	mysql:
	image: mysql:8.0
	env:
	MYSQL_ALLOW_EMPTY_PASSWORD: yes
	MYSQL_DATABASE: PeachySQL
	ports:
	- 3306
	options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3

	steps:
	- name: Install SQL Server
	uses: Particular/[email protected]
	with:
	connection-string-env-var: MSSQL_CONNECTION_STRING
	catalog: PeachySQL

	- name: Checkout
	uses: actions/checkout@v4

	# Docs: https://github.com/shivammathur/setup-php
	- name: Setup PHP
	uses: shivammathur/setup-php@v2
	with:
	php-version: ${{ matrix.php }}
	tools: psalm
	extensions: sqlsrv-5.10.1

	- name: Setup problem matchers for PHPUnit
	run: echo "::add-matcher::${{ runner.tool_cache }}/phpunit.json"

	- name: Install Composer dependencies
	run: composer install --no-progress

	- name: Run Psalm
	run: psalm --output-format=github
	if: ${{ matrix.php == '8.3' }}

	- name: Run PHPUnit
	run: vendor/bin/phpunit
	env:
	DB_PORT: ${{ job.services.mysql.ports[3306] }}

Provide feedback