Ensure that the github organizations are linked to projects #15

	name: Check Migrations

	on:
	pull_request:
	types: [opened, synchronize]
	paths:
	- 'src/database/migrations/**'

	permissions:
	issues: write
	pull-requests: write

	jobs:
	check-migrations:
	runs-on: ubuntu-latest

	steps:
	- name: Checkout repository
	uses: actions/checkout@v4

	- name: Check and add comment to PR
	uses: actions/github-script@v4
	with:
	github-token: ${{ secrets.GITHUB_TOKEN }}
	script: \|
	const { data: comments } = await github.issues.listComments({
	owner: context.repo.owner,
	repo: context.repo.repo,
	issue_number: context.issue.number,
	});

	const commentExists = comments.some(comment =>
	comment.body.includes("It looks like you've made changes to the migrations.")
	);

	if (!commentExists) {
	await github.issues.createComment({
	owner: context.repo.owner,
	repo: context.repo.repo,
	issue_number: context.issue.number,
	body: "It looks like you've made changes to the migrations. Have you run `npm run db:generate-schema` to ensure the updated schemas are included in your PR?"
	});
	console.log("Comment added");
	} else {
	console.log("Comment already exists");
	}

Provide feedback