Replace SQLAlchemy with ibis-framework for all database operations #297

	name: CI

	on:
	push:
	branches:
	- main
	pull_request:

	env:
	DEFAULT_PYTHON: "3.12"
	DEFAULT_OS: ubuntu-latest

	jobs:
	pytest:
	runs-on: ${{ matrix.os }}
	strategy:
	matrix:
	python-version: ["3.12", "3.13"]
	# TODO: skip spark on Windows
	#os: [ubuntu-latest, windows-latest]
	os: [ubuntu-latest]

	steps:
	- uses: actions/checkout@v4
	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/setup-python@v5
	with:
	python-version: ${{ matrix.python-version }}
	- name: Install dependencies
	run: \|
	python -m pip install --upgrade pip
	python -m pip install -e ".[dev,spark]"
	- name: Run pytest with coverage
	run: \|
	pytest -v --cov=chronify --cov-report=xml:coverage.xml
	- name: codecov
	uses: codecov/codecov-action@v4.2.0
	if: ${{ matrix.os == env.DEFAULT_OS && matrix.python-version == env.DEFAULT_PYTHON }}
	with:
	token: ${{ secrets.CODECOV_TOKEN }}
	name: chronify-tests
	fail_ci_if_error: false
	verbose: true
	mypy:
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v4
	- name: Set up Python
	uses: actions/setup-python@v5
	with:
	python-version: 3.12
	- name: Install dependencies
	run: \|
	python -m pip install --upgrade pip
	python -m pip install ".[dev]"
	mypy
	ruff:
	runs-on: ubuntu-latest
	name: "ruff"
	steps:
	- uses: actions/checkout@v4
	- uses: chartboost/ruff-action@v1
	with:
	src: "./src"

Provide feedback