Nightly #1005

	name: Nightly

	on:
	workflow_dispatch:
	schedule:
	- cron: '0 2 * * *'


	jobs:
	nightly:
	name: "Python: ${{ matrix.python-version }}
	SQLA: ${{ matrix.sqla-version }}
	CrateDB: ${{ matrix.cratedb-version }}
	on ${{ matrix.os }}"
	runs-on: ${{ matrix.os }}
	strategy:
	matrix:
	os: ['ubuntu-latest']
	python-version: ['3.7', '3.8', '3.9', '3.10', '3.11', '3.12']
	cratedb-version: ['nightly']
	sqla-version: ['latest']
	pip-allow-prerelease: ['false']

	# Another CI test matrix slot to test against prerelease versions of Python packages.
	include:
	- os: 'ubuntu-latest'
	python-version: '3.12'
	cratedb-version: 'nightly'
	sqla-version: 'latest'
	pip-allow-prerelease: 'true'

	fail-fast: false

	env:
	CRATEDB_VERSION: ${{ matrix.cratedb-version }}
	SQLALCHEMY_VERSION: ${{ matrix.sqla-version }}
	PIP_ALLOW_PRERELEASE: ${{ matrix.pip-allow-prerelease }}

	steps:
	- uses: actions/checkout@v4
	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/setup-python@v5
	with:
	python-version: ${{ matrix.python-version }}
	cache: 'pip'
	cache-dependency-path: 'setup.py'

	- name: Invoke tests
	run: \|

	# Propagate build matrix information.
	./devtools/setup_ci.sh

	# Bootstrap environment.
	source bootstrap.sh

	# Report about the test matrix slot.
	echo "Invoking tests with CrateDB ${CRATEDB_VERSION} and SQLAlchemy ${SQLALCHEMY_VERSION}"

	# Run linter.
	flake8 src bin

	# Run tests.
	export SQLALCHEMY_WARN_20=1
	bin/test -vvv

Provide feedback