test: Add integration tests for repositories using MariaDB #374

	name: Capture.The.Flag

	on:
	push:
	branches:
	- dev
	pull_request:
	branches:
	- dev
	env:
	DOTNET_VERSION: '8.x'

	jobs:
	unit_testing:
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v4
	- name: Setup .NET Core
	uses: actions/setup-dotnet@v3
	with:
	dotnet-version: ${{ env.DOTNET_VERSION }}
	- name: Execute unit tests
	run: \|
	dotnet test ./tests/Application.Tests/CTF.Application.Tests.csproj -c Release

	integration_testing:
	runs-on: ubuntu-latest
	services:
	mariadb:
	image: mariadb
	ports:
	- 3306:3306
	env:
	MARIADB_DATABASE: gamemode
	MARIADB_ROOT_PASSWORD: 123456789
	volumes:
	- ./scripts/mariadb:/docker-entrypoint-initdb.d
	steps:
	- uses: actions/checkout@v4
	- name: Setup .NET Core
	uses: actions/setup-dotnet@v3
	with:
	dotnet-version: ${{ env.DOTNET_VERSION }}
	- name: Create .env files
	run: \|
	cp ./tests/Persistence.Tests/.env.test.example ./tests/Persistence.Tests/.env.test
	- name: Execute integration tests
	run: \|
	dotnet test ./tests/Persistence.Tests/Persistence.Tests.csproj -c Release

Provide feedback