production.yml

name: Deploy Migrations/Edge Functions to Production

on:
  workflow_dispatch

jobs:
  deploy:
    runs-on: ubuntu-latest
    environment: database
    env:
      SUPABASE_ACCESS_TOKEN: ${{ secrets.SUPABASE_ACCESS_TOKEN }}
      SUPABASE_DB_PASSWORD: ${{ secrets.PRODUCTION_DB_PASSWORD }}
      SUPABASE_PROJECT_ID: ${{ secrets.PRODUCTION_PROJECT_ID }}

    steps:
      - uses: actions/checkout@v3

      - uses: supabase/setup-cli@v1
        with:
          version: latest

      - run: supabase link --project-ref $SUPABASE_PROJECT_ID
      
      - name: Database Migrations push
        run: supabase db push

      - name: Edge Functions deployment
        run: supabase functions deploy --project-ref $SUPABASE_PROJECT_ID