migration-deploy.yaml

name: Deploy Migrations to Production

on:
  push:
    branches:
      - master
    paths:
      - 'supabase/**'
  workflow_dispatch:

jobs:
  deploy:
    runs-on: ubuntu-latest
    timeout-minutes: 10

    env:
      SUPABASE_ACCESS_TOKEN: ${{ secrets.SUPABASE_ACCESS_TOKEN }}
      SUPABASE_DB_PASSWORD: ${{ secrets.SUPABASE_DB_PASSWORD }}
      PROJECT_ID: pfsmhuunrlzvdbteqfku

    steps:
      - uses: actions/checkout@v3

      - uses: supabase/setup-cli@v1

      - run: supabase link --project-ref $PROJECT_ID

      - run: supabase db push