Tests #506

# to view logs

	name: Tests

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

	# Allow job to be triggered manually.
	workflow_dispatch:

	# Run job each night.
	schedule:
	- cron: '0 3 * * *'

	# 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:
	matrix:
	python-version: ["3.7", "3.8", "3.9", "3.10", "3.11", "3.12"]
	os: ["ubuntu-22.04"]
	cratedb-version: ["nightly"]
	fail-fast: false

	services:
	cratedb:
	image: crate/crate:${{ matrix.cratedb-version }}
	ports:
	- 4200:4200
	- 5432:5432

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

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

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

	- name: Setup Python
	uses: actions/setup-python@v5
	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 --editable=.[test,develop]

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

	- name: Upload coverage to Codecov
	uses: codecov/codecov-action@v4
	env:
	CODECOV_TOKEN: ${{ secrets.CODECOV_TOKEN }}
	with:
	files: ./coverage.xml
	flags: unittests
	env_vars: OS,PYTHON
	name: codecov-umbrella
	fail_ci_if_error: true

Provide feedback