test: Test with singer-sdk @ main #436

	name: Test tap-postgres

	on:
	pull_request:
	types: [opened, synchronize, reopened]
	push:
	branches: [main]
	workflow_dispatch:
	inputs: {}

	jobs:
	tests:
	runs-on: ubuntu-latest
	services:
	postgres:
	image: postgres
	env:
	POSTGRES_PASSWORD: postgres
	ports:
	- 5432:5432
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	env:
	PIP_CONSTRAINT: .github/workflows/constraints.txt
	strategy:
	matrix:
	python-version: ["3.8", "3.9", "3.10", "3.11"]

	steps:
	- name: Checkout code
	uses: actions/checkout@v4

	- name: Fix Permissions
	run: \|
	chmod 777 -R ./ssh_tunnel/ssh-server-config
	chmod 600 ssl/server.key
	sudo chown 999:999 ssl/server.key
	chmod 600 ssl/pkey.key

	- name: Set up Postgres container
	run: \|
	docker compose -f docker-compose.yml up -d

	- uses: isbang/[email protected]

	# Leaving comments as this makes testing the openssh docker image easier and should save someone some time later
	# - name: Test SSH File Permissiosn
	# run: \|
	# docker exec openssh-server ls -lsa /config/ssh_host_keys
	# docker exec openssh-server cat /config/logs/openssh/current
	# docker exec openssh-server ps aux


	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/[email protected]
	with:
	python-version: ${{ matrix.python-version }}

	- name: Upgrade pip
	run: \|
	pip install pip
	pip --version
	- name: Install Poetry
	run: \|
	pip install poetry
	poetry --version
	- name: Install dependencies
	run: \|
	poetry install
	- name: Run pytest
	run: \|
	poetry run pytest
	- name: Run lint
	run: \|
	poetry run tox -e lint

Provide feedback