supabase / supabase-flutter / 29017673507

87%

push

github

feat(database): add dryRun and stripNulls query modifiers (#1559)

## Summary

Implements the postgrest parity ticket SDK-1269, bundling three additive
query-builder capabilities from the SDK compliance matrix.

- **`dryRun()`** — new `PostgrestTransformBuilder.dryRun()` modifier
that appends `Prefer: tx=rollback`, so the query runs but the
transaction is rolled back and no changes are persisted (supabase-js
`rollback()`).
- **`stripNulls()`** — new `PostgrestTransformBuilder.stripNulls()`
modifier that appends `;nulls=stripped` to the `Accept` header, omitting
null-valued properties from the response (requires PostgREST 11.2+).
- **rpc `head`/`count`** — no code change. In Dart these are already
available through the type-safe `.head()` / `.count()` chaining, which
is the idiomatic builder pattern. Inline call options cannot preserve
the three distinct return types (`PostgrestFilterBuilder<T>`,
`PostgrestBuilder<void>`,
`ResponsePostgrestBuilder<PostgrestResponse<T>>`) since Dart has no
method overloading, so the matrix entry is reconciled to `implemented`
with a note.

## Outcome

implemented

## Reference

Canonical capability registry: `supabase/sdk`
`capabilities/database.yaml` (`dry_run`, `strip_nulls`). supabase-js
`rollback()` in `postgrest-js` `PostgrestTransformBuilder.ts`.

## Compliance matrix

- `database.using_modifiers.dry_run` → `implemented`
- `database.using_modifiers.strip_nulls` → `implemented`
- `database.query.rpc` → `implemented` (was `partially_implemented`)

## Tests

Added header-assertion and backend-behavior tests in
`packages/postgrest/test/transforms_test.dart`. Full postgrest suite
passes (176 tests) against a local `supabase start` backend.

SDK-1269

13 of 13 new or added lines in 1 file covered. (100.0%)

4538 of 5240 relevant lines covered (86.6%)

4.09 hits per line