Automated testing using GitHub Actions
Run your tests when you or your team make changes.
Automated testing
You can use the Supabase CLI to run automated tests.
Testing your database
After you have created unit tests for your database, you can use the GitHub Action to run the tests.
Inside your repository, create a new file inside the .github/workflows folder called database-tests.yml. Copy this snippet inside the file, and the action will run whenever a new PR is created:
_14name: 'database-tests'_14on:_14 pull_request:_14_14jobs:_14 build:_14 runs-on: ubuntu-latest_14 steps:_14 - uses: actions/checkout@v3_14 - uses: supabase/setup-cli@v1_14 with:_14 version: latest_14 - run: supabase db start_14 - run: supabase test db
Testing your Edge Functions
After you have created unit tests for your Edge Functions, you can use the GitHub Action to run the tests.
Inside your repository, create a new file inside the .github/workflows folder called functions-tests.yml. Copy this snippet inside the file, and the action will run whenever a new PR is created:
_14name: 'functions-tests'_14on:_14 pull_request:_14_14jobs:_14 build:_14 runs-on: ubuntu-latest_14 steps:_14 - uses: actions/checkout@v3_14 - uses: supabase/setup-cli@v1_14 with:_14 version: latest_14 - run: supabase start_14 - run: deno test --allow-all deno-test.ts --env-file .env.local
More resources
- Learn more about the pgTAP extension for database testing.
- Official pgTAP Documentation: pgtap.org