🚧 getting our action going #6

	name: Run Tests
	on:
	pull_request:
	types: [synchronize, ready_for_review]

	jobs:
	test:
	if: github.event.pull_request.draft == false
	runs-on: ubuntu-latest
	services:
	mysql:
	image: mysql:8.0
	env:
	# The MySQL docker container requires these environment variables to be set
	# so we can create and migrate the test database.
	# See: https://hub.docker.com/_/mysql
	MYSQL_DATABASE: bio-test
	MYSQL_ROOT_PASSWORD: root
	ports:
	# Opens port 3306 on service container and host
	# https://docs.github.com/en/actions/using-containerized-services/about-service-containers
	- 3306:3306
	# Before continuing, verify the mysql container is reachable from the ubuntu host
	options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3
	steps:
	- uses: actions/checkout@v3
	- uses: pnpm/action-setup@v2
	name: Install pnpm
	id: pnpm-install
	with:
	version: 9
	run_install: false

	- name: Get pnpm store directory
	id: pnpm-cache
	shell: bash
	run: \|
	echo "STORE_PATH=$(pnpm store path)" >> $GITHUB_OUTPUT

	- uses: actions/cache@v3
	name: Setup pnpm cache
	with:
	path: ${{ steps.pnpm-cache.outputs.STORE_PATH }}
	key: ${{ runner.os }}-pnpm-store-${{ hashFiles('**/pnpm-lock.yaml') }}
	restore-keys: \|
	${{ runner.os }}-pnpm-store-

	- name: Install Dependencies
	run: pnpm i

	- name: Run Migrations
	run: pnpm run db:test:reset

	- name: Run Vitest
	run: pnpm run test

Provide feedback