support for both psycopg2 and 3 #86

	name: Run tests

	on:
	push:
	branches:
	- master
	pull_request:
	branches:
	- master
	workflow_dispatch:
	workflow_call:


	jobs:
	test:
	runs-on: ubuntu-latest

	strategy:
	matrix:
	psycopg-version: [2, 3]
	pg-version: ['9.6', '10', '11']
	fail-fast: true

	# Service containers to run with `runner-job`
	services:
	# Label used to access the service container
	postgres:
	# Docker Hub image
	image: postgres:${{ matrix.pg-version }}
	# Provide the password for postgres
	env:
	POSTGRES_USER: pirogue
	POSTGRES_PASSWORD: 1234
	POSTGRES_DB: pirogue_test_db
	# Set health checks to wait until postgres has started
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	ports:
	# Maps tcp port 5432 on service container to the host
	- 5432:5432

	env:
	PGUSER: postgres

	steps:
	- name: Get source code
	uses: actions/checkout@v4

	- name: Set up Python
	uses: actions/setup-python@v5
	with:
	python-version: "3.9"
	cache: "pip"
	cache-dependency-path: "requirements*.txt"

	- name: Install requirements
	run: \|
	pip install -r requirements.txt
	pip install -r requirements-test.txt
	pip install -r requirements-psycopg${{ matrix.psycopg-version }}.txt

	- name: Install pirogue
	run: python -m pip install -e .[psycopg${{ matrix.psycopg-version }}]

	- name: Setup tests
	run: \|
	printf "[pirogue_test]\nhost=localhost\ndbname=pirogue_test_db\nuser=pirogue\npassword=1234\n\n" >> ~/.pg_service.conf
	PGSERVICE=pirogue_test psql --quiet -v ON_ERROR_STOP=on -f test/demo_data.sql

	- name: Run bash tests
	run: ./test/test_simple_inheritance.sh

	- name: Run Python tests
	run: nose2 -v

Provide feedback