test: enhance automated Laravel test GitHub action #167

	name: Laravel Test

	on:
	push:
	branches: [main]
	pull_request:
	branches: [main]

	env:
	DB_DATABASE: radioroster
	DB_USERNAME: radioroster
	DB_PASSWORD: testPassword

	jobs:
	laravel-mariadb:
	name: Laravel with MariaDB ${{ matrix.mariadb-versions }}
	runs-on: ubuntu-latest
	services:
	mariadb:
	image: mariadb:${{ matrix.mariadb-versions }}
	env:
	MYSQL_ROOT_PASSWORD: root
	MYSQL_DATABASE: ${{ env.DB_DATABASE }}
	MYSQL_USER: ${{ env.DB_USERNAME }}
	MYSQL_PASSWORD: ${{ env.DB_PASSWORD }}
	ports:
	- 3306
	options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3

	strategy:
	matrix:
	mariadb-versions: ["10", "11"]

	steps:
	- uses: ./.github/workflows/laravel-test.yml
	with:
	db-type: mysql
	db-port: ${{ job.services.mariadb.ports[3306] }}
	db-user: ${{ env.DB_USERNAME }}
	db-password: ${{ env.DB_PASSWORD }}
	db-database: ${{ env.DB_DATABASE }}

	laravel-psql:
	name: Laravel with PostgreSQL ${{ matrix.psql-versions }}
	runs-on: ubuntu-latest
	services:
	postgres:
	image: postgres:${{ matrix.psql-versions }}
	env:
	POSTGRES_USER: ${{ env.DB_USERNAME }}
	POSTGRES_PASSWORD: ${{ env.DB_PASSWORD }}
	POSTGRES_DB: ${{ env.DB_DATABASE }}
	ports:
	- 5432
	options: --health-cmd="pg_isready" --health-interval=10s --health-timeout=5s --health-retries=3

	strategy:
	matrix:
	psql-versions: ["14", "15", "16"]

	steps:
	- uses: ./.github/workflows/laravel-test.yml
	with:
	db-type: pgsql
	db-port: ${{ job.services.postgres.ports[5432] }}
	db-user: ${{ env.DB_USERNAME }}
	db-password: ${{ env.DB_PASSWORD }}
	db-database: ${{ env.DB_DATABASE }}

Provide feedback