Bump mysql2 from 3.9.4 to 3.9.7 #36

	name: CI
	on:
	push:
	branches:
	- master
	pull_request:
	types: [opened, synchronize, reopened]
	jobs:
	build:
	name: Build, lint, and test on Node ${{ matrix.node }} and ${{ matrix.os }}

	runs-on: ${{ matrix.os }}
	strategy:
	matrix:
	node: ['18.x', '20.x']
	os: [ubuntu-latest]

	steps:
	- name: Checkout repo
	uses: actions/checkout@v3

	- name: Use Node ${{ matrix.node }}
	uses: actions/setup-node@v3
	with:
	node-version: ${{ matrix.node }}
	cache: 'yarn'

	- name: Set up MySQL
	run: \|
	sudo systemctl start mysql
	mysql -uroot -h127.0.0.1 -proot -e 'CREATE DATABASE IF NOT EXISTS test_db;'
	mysql -uroot -h127.0.0.1 -proot test_db < ./sql-data/dummy.sql
	mysql -uroot -h127.0.0.1 -proot -e 'SELECT * FROM test_db.persons;'

	- name: Install Packages
	run: yarn install --frozen-lockfile
	env:
	CI: true

	- name: Test types
	run: yarn test:types

	- name: Test
	run: yarn test --ci --coverage --maxWorkers=2
	env:
	CI: true
	MYSQL_DATABASE: 'test_db'
	MYSQL_PASSWORD: 'root'
	MYSQL_USER: 'root'
	MYSQL_HOST: '127.0.0.1'

Provide feedback