comment-if-db-migrations.yaml

name: Check if db migrations are needed

on:
  pull_request:
    branches: [main]
    paths:
      - 'drizzle/**'

jobs:
  comment-if-db-migrations:
    permissions:
      pull-requests: write
      contents: read

    runs-on: ubuntu-latest
    steps:
      - name: Comment PR - db migrated
        uses: thollander/actions-comment-pull-request@main
        with:
          message: |
            > [!NOTE]  
            > This PR introduces changes to the database.

            **Remember to:**

            1. Run the migrations in [stage database branch](https://app.planetscale.com/begursecret/descobreix-begur-app/stage) with:
               ```bash
               pnpm db:push
               ```
            1. Create a [deploy request in Planetscale](https://app.planetscale.com/begursecret/descobreix-begur-app/deploy-requests/)
            1. Merge the deploy request from Planetscale just before merging the PR.
          comment_tag: execution