Amjith/modernize setup ci publish #128

	name: pgspecial

	on:
	pull_request:
	paths-ignore:
	- '**.rst'

	jobs:
	build:
	runs-on: ubuntu-latest

	strategy:
	matrix:
	python-version: ["3.9", "3.10", "3.11", "3.12", "3.13"]
	postgres-version: ["10", "11", "12", "13", "14", "15"]

	services:
	postgres:
	image: postgres:${{ matrix.postgres-version }}
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	ports:
	- 5432:5432
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5

	steps:
	- uses: actions/checkout@11bd71901bbe5b1630ceea73d27597364c9af683 # v4.2.2
	- uses: actions/checkout@11bd71901bbe5b1630ceea73d27597364c9af683 # v4.2.2
	- uses: astral-sh/setup-uv@c7f87aa956e4c323abf06d5dec078e358f6b4d04 # v6.0.0
	with:
	version: "latest"

	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/setup-python@a26af69be951a213d495a4c3e4e4022e16d87065 # v5.6.0
	with:
	python-version: ${{ matrix.python-version }}

	- name: Install dependencies
	run: uv sync --all-extras -p ${{ matrix.python-version }}

	- name: Run unit tests
	env:
	LANG: en_US.UTF-8
	run: uv run tox -e py${{ matrix.python-version }}

	- name: Run Style Checks
	run: uv run tox -e style

Provide feedback