supabase / supabase-flutter / 29727256785
87%

DEFAULT BRANCH: main
Ran
Jobs 9
Files 103
Run time 1min
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst
coverage: 86.857% (+0.04%) from 86.818%
29727256785

push

github

web-flow 
docs(examples): add database CRUD with PostgREST example (#1616)

## What

Adds a runnable **Database CRUD with PostgREST** example under
`examples/database_crud`, plus the shared schema and seed data it runs
against. Closes SDK-1065.

The example is a small task manager that covers everything
`supabase.from(...)` offers for CRUD:

- **Select** tasks joined to their project (`select('*,
projects(name)')`)
- **Filters**: `eq` (project, completion), `ilike` (title search)
- **Ordering**: `order('priority', ascending:
false).order('created_at')`
- **Insert** returning the created joined row
(`insert().select().single()`)
- **Update** title and completion state (`update().eq()`)
- **Delete** (`delete().eq()`)

All database access lives in `lib/tasks_repository.dart`, kept separate
from the UI so the queries are easy to read and can later be driven from
a full end-to-end integration test.

## Shared config

- `examples/supabase/migrations/20240601000000_crud_example.sql` —
`projects` 1:N `tasks` with a foreign key and index, RLS enabled with
permissive demo policies, and grants so the publishable (anon) key can
read projects and manage tasks without signing in.
- `examples/supabase/seed.sql` — sample projects and tasks.

## Wiring

- Registered `examples/database_crud` in the root workspace
`pubspec.yaml` and the `examples/README.md` table. The launcher
auto-discovers it.

## Verification

- `flutter analyze examples` → no issues; `dart format` clean.
- `supabase db reset` against `examples/` applies the migration and seed
cleanly.
- Exercised the full flow over PostgREST with the publishable key:
joined + ordered + `ilike` select, insert returning the joined row,
update, filtered select, and delete (204) with confirmation.

5571 of 6414 relevant lines covered (86.86%)

3.92 hits per line

Jobs
ID Job ID Ran Files Coverage
1 functions_client - 29727256785.1 3
98.85
 GitHub Action Run
2 supabase_flutter - 29727256785.2 10
79.31
 GitHub Action Run
3 gotrue - 29727256785.3 28
87.6
 GitHub Action Run
4 realtime_client - 29727256785.4 11
90.11
 GitHub Action Run
5 postgrest - 29727256785.5 10
85.33
 GitHub Action Run
6 supabase - 29727256785.6 17
83.2
 GitHub Action Run
7 storage_client - 29727256785.7 13
84.63
 GitHub Action Run
8 supabase_common - 29727256785.8 10
100.0
 GitHub Action Run
9 yet_another_json_isolate - 29727256785.9 1
93.65
 GitHub Action Run
Source Files on build 29727256785