Tests

Tests #218

	---
	name: "Tests"

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

	# Allow job to be triggered manually.
	workflow_dispatch:

	# Run job each night after CrateDB nightly has been published.
	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:
	fail-fast: false
	matrix:
	os: ["ubuntu-latest"]
	python-version: ["3.8", "3.11"]

	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: Set up Python
	uses: actions/setup-python@v5
	with:
	python-version: ${{ matrix.python-version }}
	architecture: x64
	cache: 'pip'
	cache-dependency-path:
	requirements.txt

	- name: Set up PostgreSQL container.
	run: \|
	docker compose -f docker-compose.yml up -d

	- name: Set up 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 requirements.
	pip install -r requirements.txt

	- name: Verify "to-database"
	run: \|
	ngr test to-database

Provide feedback