Automate migrations #22

	name: Apply staging migrations on PR when there are changes in the migrations folder

	on:
	pull_request:
	types: [opened, synchronize]

	jobs:
	check-folder-changes:
	runs-on: ubuntu-latest
	steps:
	- name: Checkout repository
	uses: actions/checkout@v4

	- name: Check for changes in migrations folder
	id: check_changes
	run: \|
	git fetch origin main
	git fetch origin ${{ github.head_ref \|\| github.ref_name }}
	git checkout ${{ github.head_ref \|\| github.ref_name }}

	if git diff --name-only origin/main...HEAD \| grep -q '^migrations/'; then
	echo "CHANGES=true" >> $GITHUB_ENV
	else
	echo "CHANGES=false" >> $GITHUB_ENV
	fi

	apply-staging:
	needs: check-folder-changes
	runs-on: ubuntu-latest
	steps:
	- name: Check if changes are detected
	run: \|
	if [ "$CHANGES" = "true" ]; then
	echo "Changes detected in migrations folder"
	else
	echo "No changes detected in migrations folder"
	exit 78
	fi
	- name: Checkout repository
	uses: actions/checkout@v4

	- name: Set up Node.js
	uses: actions/setup-node@v4
	with:
	node-version: "20"

	- name: Install dependencies
	run: npm install

	- name: Run TypeScript script
	run: npm run migrations:apply-staging

Provide feedback