Flyway migration with proper encoding ~ Test data as of Oct25 #526

	name: PR

	on:
	pull_request:

	concurrency:
	# Cancel in progress for PR open and close
	group: ${{ github.event.number }}
	cancel-in-progress: true

	jobs:
	# https://github.com/bcgov-nr/action-builder-ghcr
	builds:
	name: Builds
	runs-on: ubuntu-22.04
	permissions:
	packages: write
	outputs:
	digest: ${{ steps.builds.outputs.digest }}
	strategy:
	matrix:
	package: [backend, frontend, migrations]
	timeout-minutes: 10
	steps:
	- uses: bcgov-nr/action-builder-ghcr@v2.0.2
	id: builds
	with:
	keep_versions: 50
	package: ${{ matrix.package }}
	tag: ${{ github.event.number }}
	tag_fallback: latest
	triggers: ('${{ matrix.package }}/')

	# https://github.com/bcgov-nr/action-deployer-openshift
	deploys:
	name: Deploys
	needs: [builds]
	uses: bcgov/quickstart-openshift-helpers/.github/workflows/.deployer.yml@v0.4.1
	secrets:
	oc_namespace: ${{ secrets.OC_NAMESPACE }}
	oc_token: ${{ secrets.OC_TOKEN }}
	with:
	triggers: ('backend/' 'frontend/' 'migrations/')
	params:
	--set global.secrets.persist=false

	tests:
	name: Tests
	if: needs.deploys.outputs.triggered == 'true'
	needs: [deploys]
	uses: ./.github/workflows/.tests.yml
	with:
	target: ${{ github.event.number }}

	results:
	name: PR Results
	if: always()
	needs: [builds, deploys, tests]
	runs-on: ubuntu-22.04
	steps:
	- run: \|
	# View results
	echo "needs..result: ${{ toJson(needs..result) }}"

	- if: contains(needs.*.result, 'failure')
	run: \|
	# Job failure found
	echo "At least one job has failed"
	exit 1

Provide feedback