Tests

Reorder CrateDB SQLAlchemy Dialect polyfills once more #42

	---
	name: Tests

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

	# Allow job to be triggered manually.
	workflow_dispatch:

	# Cancel in-progress jobs when pushing to the same branch.
	concurrency:
	cancel-in-progress: true
	group: ${{ github.workflow }}-${{ github.ref }}

	jobs:

	tests:

	runs-on: ${{ matrix.os }}
	strategy:
	fail-fast: false
	matrix:
	os: ["ubuntu-latest"]
	python-version: ["3.11"]

	env:
	OS: ${{ matrix.os }}
	PYTHON: ${{ matrix.python-version }}

	# https://docs.github.com/en/free-pro-team@latest/actions/guides/about-service-containers
	services:
	cratedb:
	image: crate/crate:nightly
	ports:
	- 4200:4200
	- 5432:5432

	name: Python ${{ matrix.python-version }} on OS ${{ matrix.os }}
	steps:

	- name: Acquire sources
	uses: actions/checkout@v4

	- name: Set up Python
	uses: actions/setup-python@v4
	with:
	python-version: ${{ matrix.python-version }}
	architecture: x64
	cache: 'pip'
	cache-dependency-path: 'pyproject.toml'

	- name: Setup project
	run: \|

	# `setuptools 0.64.0` adds support for editable install hooks (PEP 660).
	# https://github.com/pypa/setuptools/blob/main/CHANGES.rst#v6400
	pip install "setuptools>=64" --upgrade

	# Install package in editable mode.
	pip install --use-pep517 --prefer-binary --editable=.[develop,docs,test]

	- name: Run linter and software tests
	run: \|
	poe check

	- name: Upload coverage to Codecov
	uses: codecov/codecov-action@v3
	with:
	files: ./coverage.xml
	flags: unittests
	env_vars: OS,PYTHON
	name: codecov-umbrella
	fail_ci_if_error: false

Provide feedback