Add 2022 dataset #207

	name: Test Python

	on:
	push:
	branches:
	- main
	pull_request:
	paths:
	- '*.py'
	- 'api/**'
	branches:
	- main

	jobs:
	test-python:
	runs-on: ubuntu-latest

	steps:
	- uses: actions/checkout@v2
	- uses: actions/setup-python@v2
	with:
	python-version: 3.9

	- uses: mirromutth/[email protected]
	with:
	mysql version: '8.0.22'
	mysql database: 'esprr_data'
	mysql root password: 'testpassword'

	- name: Install Dependencies
	run: \|
	cd api
	python -m pip install --upgrade pip
	pip install -r requirements.txt
	pip install -r requirements-test.txt
	pip install -e .
	pip list

	- name: Migrate database
	env:
	DATABASE_URL: "mysql://root:[email protected]:3306/esprr_data"
	run: \|
	curl -fsSL -o ./dbmate https://github.com/amacneil/dbmate/releases/latest/download/dbmate-linux-amd64
	chmod +x ./dbmate
	./dbmate --wait up

	- name: Test
	run: \|
	pytest api/esprr_api --cov=esprr_api --cov-report=term-missing --cov-report=xml

	- name: Run mypy
	run: mypy api/esprr_api
	if: ${{ always() }}

	- name: Upload coverage
	uses: codecov/codecov-action@v1
	with:
	token: ${{ secrets.CODECOV_TOKEN }}
	flags: python
	files: coverage.xml
	fail_ci_if_error: true
	if: ${{ always() }}

	- name: Ensure assets are up to date
	if: ${{ always() }}
	run: python extract_files.py --check

	lint-python:
	runs-on: ubuntu-latest

	steps:
	- uses: actions/checkout@v2
	- uses: actions/setup-python@v2
	- name: flake8
	run: \|
	cd api
	pip install flake8
	flake8 .
	- uses: psf/black@stable

Provide feedback