Running Regression Tests and Spockbench #245

	name: Regression Tests and Spockbench
	run-name: Running Regression Tests and Spockbench
	on:
	pull_request:
	types: [opened, synchronize, reopened]


	permissions:
	contents: read

	jobs:
	pull-and-test:
	strategy:
	fail-fast: false
	matrix:
	os: [ubuntu-latest]
	pgver: [15, 16, 17]

	runs-on: ${{ matrix.os }}

	steps:
	- name: Checkout spock
	uses: actions/checkout@v4
	with:
	ref: ${{ github.ref }}

	- name: Checkout spockbench
	uses: actions/checkout@v4
	with:
	repository: pgedge/spockbench
	token: ${{ secrets.READ_SPOCKBENCH_PAT }}
	path: spockbench
	ref: master

	- name: Add permissions
	run: \|
	sudo chmod -R a+w ${GITHUB_WORKSPACE}

	- name: Set up Docker
	uses: docker/setup-buildx-action@v3

	- name: Set up docker compose
	uses: docker/setup-compose-action@v1
	with:
	version: latest

	- name: Build docker container
	run: \|
	cd ${GITHUB_WORKSPACE}/
	echo PG_VER=${{ matrix.pgver }} >> tests/pgedge.env
	docker build \
	--build-arg PGVER=${{ matrix.pgver }} \
	-t spock -f tests/Dockerfile.el9 .

	- name: Run regression tests
	run: \|
	docker run -e PGVER=${{ matrix.pgver }} spock /home/pgedge/run-spock-regress.sh

	- name: Start docker
	run: \|
	cd ${GITHUB_WORKSPACE}/tests/
	echo PG_VER=${{ matrix.pgver }} >> pgedge.env
	docker compose up

	- name: Check spockbench output
	run: \|
	cd ${GITHUB_WORKSPACE}/tests
	./check-outputs.sh

Provide feedback