supabase-test.yml

name: Test Supabase
on:
  push:
    paths:
      - ".github/workflows/supabase-test.yml"
      - "database/**"
  workflow_dispatch:

jobs:
  pgtap:
    runs-on: ubuntu-latest
    services:
      postgres:
        image: supabase/postgres:15.1.0.90
        env:
          POSTGRES_PASSWORD: postgres
        options: >-
          --health-cmd pg_isready
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5
        ports:
          - 5432:5432

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

      - name: Prepare Supabase CI Seed
        run: |
          cp supabase/seed-ci.sql supabase/seed.sql

      - name: Set up Supabase CLI
        uses: supabase/setup-cli@v1
        with:
          version: latest

      - name: Start Supabase database
        run: |
          supabase db start

      - name: Run Supabase Tests
        run: |
          supabase test db