Merge pull request #216 from BritishGeologicalSurvey/test-newer-pytho… #162

	name: Lint and test

	# Global environment variables for all jobs
	env:
	POSTGRES_DB: etlhelper
	POSTGRES_USER: etlhelper_user
	POSTGRES_PASSWORD: etlhelper_pw
	TEST_PG_PASSWORD: etlhelper_pw

	on:
	push:
	paths:
	- '**.py'
	- '.github/workflows/test.yml'

	jobs:
	flake8_py3:
	runs-on: ubuntu-latest
	steps:
	- name: Checkout repo
	uses: actions/checkout@v3
	- name: Setup Python
	uses: actions/setup-python@v4
	with:
	python-version: 3.9
	- name: Install flake8
	run: pip install flake8
	- name: Run flake8
	uses: suo/flake8-github-action@releases/v1
	with:
	checkName: 'flake8_py3'

	pytest:
	runs-on: ubuntu-latest
	services:
	postgres:
	# Accessed directly from host at localhost, because tests are not
	# running in a container
	image: postgis/postgis:15-3.4
	ports:
	- 5432:5432
	# Copy env vars from above - substitution didn't work
	env:
	POSTGRES_DB: etlhelper
	POSTGRES_USER: etlhelper_user
	POSTGRES_PASSWORD: etlhelper_pw
	# Set health checks to wait until postgres has started
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	strategy:
	matrix:
	python-version: [3.9, '3.10', 3.11, 3.12, 3.13]
	steps:
	- name: Checkout repo
	uses: actions/checkout@v3
	- name: Setup Python ${{ matrix.python-version }}
	uses: actions/setup-python@v4
	with:
	python-version: ${{ matrix.python-version }}
	- name: Install requirements
	run: pip install -r requirements-dev.txt
	- name: Run pytest
	run: pytest -vrsx --cov=etlhelper --cov-report term test/

Provide feedback