10491: Move work items to Postgres #791

	name: E2E Cypress

	on:
	pull_request:

	jobs:
	e2e_cypress:
	runs-on: ubuntu-latest

	strategy:
	fail-fast: false
	matrix:
	ci_node_total: [6]
	ci_node_index: [0, 1, 2, 3, 4, 5]
	env:
	CI: true
	CI_NODE_TOTAL: ${{ matrix.ci_node_total }}
	CI_NODE_INDEX: ${{ matrix.ci_node_index }}
	services:
	postgres:
	image: postgres
	env:
	POSTGRES_PASSWORD: example
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	ports:
	- 5432:5432
	steps:
	- uses: actions/checkout@v4
	- uses: actions/setup-node@v4
	with:
	node-version: '20.14.0'
	- name: Setup OpenSearch
	uses: ankane/setup-opensearch@v1
	with:
	opensearch-version: 2.11
	- name: Setup DynamoDB Local
	uses: rrainn/[email protected]
	with:
	port: 8000
	cors: '*'
	- name: Collect Workflow Telemetry
	uses: runforesight/workflow-telemetry-action@v2
	with:
	comment_on_pr: false
	- name: Install Node Dependencies
	run: npm ci
	- name: Setup Postgres
	run: \|
	npm run migration:postgres
	npm run seed:postgres
	- name: Run E2E Cypress
	run: \|
	mkdir -p /tmp/cypress/
	npm run start:all:ci >> /tmp/cypress/cypress-output.txt &
	./wait-until-services.sh
	sleep 5
	export TESTFILES=$(npx ts-node split-tests-cypress.ts integration)
	npm run cypress:integration:file $TESTFILES
	- name: Store Cypress Videos
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: cypress-videos-${{ matrix.ci_node_index }}
	path: ${{ github.workspace }}/cypress/local-only/videos

Provide feedback