supabase / supabase-flutter / 32821480584

88%

Build Type

push

github

Committed by web-flow

Commit Message

feat(postgrest): add a notInFilter filter method (#1762)

## Summary

Adds `PostgrestFilterBuilder.notInFilter(String column, List values)`,
the negated counterpart of the existing `inFilter`. It emits
`not.in.(...)` and reuses the same `_cleanFilterList` quoting and
escaping, so callers no longer have to hand-format PostgREST list syntax
through the generic `not('column', 'in', '(a,b,c)')` escape hatch.

```dart
await supabase
    .from('users')
    .select()
    .notInFilter('status', ['ONLINE', 'OFFLINE']);
```

The name mirrors `inFilter` because `in` is a reserved word in Dart.

## Outcome

Implemented. Additive, no breaking change.

## Tests

- `filter_test.dart`: live `not in` test against the local backend.
- `filter_escape_test.dart`: asserts the exact query string for escaped
string values (`not.in.("a\"b\\c")`) and for unquoted numeric values
(`not.in.(1,2,3)`).

All 208 `postgrest` tests pass locally.

## Reference

Ports the behavior added in supabase-swift:
https://github.com/supabase/supabase-swift/pull/1114

## Compliance matrix

`database.using_filters.not_in` → `implemented`, with
`PostgrestFilterBuilder.notInFilter` registered alongside the existing
`PostgrestFilterBuilder.not`.

Closes SDK-1595

<!-- This is an auto-generated comment: release notes by coderabbit.ai
-->

## Summary by CodeRabbit

* **New Features**
* Added support for negated list filters, allowing records matching
specified values to be excluded.
  * Supports both text and numeric values with appropriate escaping.

* **Bug Fixes**
* Ensured special characters in negated list filters are handled safely
and consistently.

<!-- end of auto-generated comment: release notes by coderabbit.ai -->

Coverage Stats

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

125 existing lines in 5 files now uncovered.

6008 of 6781 relevant lines covered (88.6%)

4.5 hits per line