ci: integrate frontend and backend tests with organization-related test suites #1121

	name: Test Migrations

	on:
	push:
	branches:
	- main
	- release/**
	pull_request:
	branches:
	- main
	- release/**
	workflow_dispatch:

	defaults:
	run:
	shell: bash

	permissions:
	contents: read

	concurrency:
	group: pr-checks-${{ github.workflow }}-${{ github.head_ref \|\| github.run_id }}
	cancel-in-progress: true

	jobs:
	test-migrations:
	name: Migration Tests
	runs-on: transaction-tools-linux-medium

	services:
	postgres:
	image: postgres:15
	env:
	POSTGRES_PASSWORD: postgres
	POSTGRES_USER: postgres
	POSTGRES_DB: postgres
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	ports:
	- 5432:5432

	steps:
	- name: Harden Runner
	uses: step-security/harden-runner@a90bcbc6539c36a85cdfeb73f7e2f433735f215b # v2.15.0
	with:
	egress-policy: audit

	- name: Checkout code
	uses: actions/checkout@de0fac2e4500dabe0009e67214ff5f5447ce83dd # v6.0.2

	- name: Install pnpm
	uses: step-security/action-setup@3d419c73e38e670dbffe349ffff26dd13c164640 # v4.2.0
	with:
	version: 9

	- name: Set up Node.js
	uses: actions/setup-node@53b83947a5a98c8d113130e565377fae1a50d02f # v6.3.0
	with:
	node-version: 22.12.0
	cache: 'pnpm'
	cache-dependency-path: \|
	back-end/pnpm-lock.yaml

	- name: Install dependencies
	run: pnpm install
	working-directory: back-end

	- name: Run migration tests
	run: pnpm test:migrations
	working-directory: back-end
	env:
	POSTGRES_HOST: localhost
	POSTGRES_PORT: 5432
	POSTGRES_USERNAME: postgres
	POSTGRES_PASSWORD: postgres
	POSTGRES_DATABASE: postgres

Provide feedback