Set up testing infrastructure #324

	name: CI

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

	jobs:
	build:
	runs-on: ubuntu-latest

	steps:
	- uses: actions/checkout@v3

	- name: Set up Node.js
	uses: actions/setup-node@v3
	with:
	node-version: '18.18.0'

	- name: Install modules
	run: npm install

	- name: Run ESLint
	run: npm run lint

	- name: Build
	run: npm run build

	- name: Start MySQL service
	run: sudo systemctl start mysql.service

	- name: Create database
	run: \|
	echo "CREATE DATABASE IF NOT EXISTS test" > setup.sql
	sudo mysql -h 127.0.0.1 -uroot -proot < setup.sql

	- name: Test
	# This is just the default settings for GH Actions MySQL
	# Nothing secret here aside from the hashed API key
	env:
	DB_TEST_HOSTNAME: 127.0.0.1
	DB_TEST_USERNAME: root
	DB_TEST_PASSWORD: root
	HASHED_API_KEY: ${{ secrets.HASHED_API_KEY }}
	run: npm run test

	- name: Destroy test database
	run: \|
	echo "DROP DATABASE test" > teardown.sql
	sudo mysql -h 127.0.0.1 -uroot -proot < teardown.sql

Provide feedback