Merge pull request #14327 from snipe/fixes/better_ui_for_history_impo… #1

	name: Tests in MySQL

	on:
	push:
	branches:
	- master
	- develop
	pull_request:

	jobs:
	tests:
	runs-on: ubuntu-latest

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

	strategy:
	fail-fast: false
	matrix:
	php-version:
	- "7.4"
	- "8.0"
	- "8.1.1"

	name: PHP ${{ matrix.php-version }}

	steps:
	- uses: shivammathur/setup-php@v2
	with:
	php-version: "${{ matrix.php-version }}"
	coverage: none

	- uses: actions/checkout@v4

	- name: Get Composer Cache Directory
	id: composer-cache
	run: \|
	echo "dir=$(composer config cache-files-dir)" >> $GITHUB_OUTPUT
	- uses: actions/cache@v4
	with:
	path: ${{ steps.composer-cache.outputs.dir }}
	key: ${{ runner.os }}-${{ matrix.php-version }}-composer-${{ hashFiles('**/composer.lock') }}
	restore-keys: \|
	${{ runner.os }}-composer-

	- name: Copy .env
	run: \|
	cp -v .env.testing.example .env
	cp -v .env.testing.example .env.testing

	- name: Install Dependencies
	run: composer install -q --no-ansi --no-interaction --no-scripts --no-progress --prefer-dist

	- name: Generate key
	run: php artisan key:generate

	- name: Directory Permissions
	run: chmod -R 777 storage bootstrap/cache

	- name: Execute tests (Unit and Feature tests) via PHPUnit
	env:
	DB_CONNECTION: mysql
	DB_DATABASE: snipeit
	DB_PORT: ${{ job.services.mysql.ports[3306] }}
	DB_USERNAME: root
	run: php artisan test --parallel

Provide feedback