Verify Schema Update #20

	name: Verify Schema Update

	on:
	workflow_call:
	workflow_run:
	workflows: ["Verify Database"]
	types:
	- completed

	defaults:
	run:
	working-directory: ./server

	env:
	DATABASE_URL: postgresql://postgres:password@localhost:5433/f1_fantasy_league_db?schema=public

	jobs:
	verify:
	runs-on: ubuntu-latest
	permissions:
	contents: write
	steps:
	- uses: actions/checkout@v3
	- name: execute flyway in docker 🐳
	run: docker compose up -d
	- name: pnpm-setup
	uses: pnpm/action-setup@v4
	with:
	version: latest
	- name: Server Install
	run: pnpm i
	- name: Prisma Pull
	run: pnpm run prisma:pull
	- name: Prisma Generate
	run: pnpm run prisma:generate
	- name: Debug Git Status
	run: git status
	- name: Check for modified snapshots / database schema
	id: snapshot-check
	run: echo ::set-output name=modified::$(if git status \| grep "nothing to commit"; then echo "false"; else echo "true"; fi)
	- name: Commit any updated snapshots / database schema changes
	if: steps.snapshot-check.outputs.modified == 'true'
	uses: stefanzweifel/git-auto-commit-action@v5
	with:
	commit_message: Commit for snapshot update
	- name: Spin Down Docker 🐳
	run: docker compose down

Provide feedback