SQLAlchemy #843

	name: SQLAlchemy

	on:
	pull_request:
	branches: ~
	paths:
	- '.github/workflows/lang-python-sqlalchemy.yml'
	- 'by-language/python-sqlalchemy/**'
	- '/requirements.txt'
	push:
	branches: [ main ]
	paths:
	- '.github/workflows/lang-python-sqlalchemy.yml'
	- 'by-language/python-sqlalchemy/**'
	- '/requirements.txt'

	# 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:
	test:
	name: "
	Python: ${{ matrix.python-version }}
	CrateDB: ${{ matrix.cratedb-version }}
	on ${{ matrix.os }}"
	runs-on: ${{ matrix.os }}
	strategy:
	fail-fast: false
	matrix:
	os:
	- 'ubuntu-latest'
	python-version:
	- '3.11'
	- '3.14'
	cratedb-version:
	- 'nightly'

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

	env:
	PIP_PRE: true
	UV_PRERELEASE: allow

	steps:

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

	- name: Install uv
	uses: astral-sh/setup-uv@v7
	with:
	activate-environment: 'true'
	cache-dependency-glob: \|
	requirements.txt
	by-language/python-sqlalchemy/requirements*.txt
	cache-suffix: ${{ matrix.python-version }}
	enable-cache: true
	python-version: ${{ matrix.python-version }}

	- name: Install utilities
	run: uv pip install --requirements=requirements.txt

	- name: Validate by-language/python-sqlalchemy
	run: ngr test by-language/python-sqlalchemy

Provide feedback