fix: migration check pipeline #6

	name: Check Migrations

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

	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: \|
	console.log("----CONTEXT---", JSON.stringify(context, null, 2));
	console.log("GitHub Object:", Object.keys(github));
	console.log("Context Issue:", context.issue);
	console.log("Context Payload:", context.payload);

	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?"
	});
	}

Provide feedback