supabase / supabase-flutter / 39603824352

92%

Build Type

push

github

Committed by web-flow

Commit Message

feat(typegen)!: read multirange columns into a multirange type (#1999)

## Summary

Multirange columns (`int4multirange`, `int8multirange`, `nummultirange`,
`datemultirange`, `tsmultirange`, `tstzmultirange`) generated `String`
getters. They now map to `PostgresMultirange<Bound>`, a new value type
in `supabase_common` re-exported from postgrest. Its bounds are typed
like those of the matching range type, so a `datemultirange` is a
`PostgresMultirange<PostgresDate>` and a `tstzmultirange` a
`PostgresMultirange<DateTime>`.

- It wraps an unmodifiable list of `PostgresRange<Bound>`, rather than
being a bare `List<PostgresRange<Bound>>`. A bare list would render in a
filter as an array literal (`{"[1,3)"}`), not as the multirange literal
(`{[1,3)}`), and arrays of multiranges would be ambiguous.
- `parse(literal, parseBound)` splits the `{[1,3),[5,7)}` literal into
its ranges, keeping brackets and commas inside quoted bounds, and reads
each with `PostgresRange.parse`.
- `render(renderBound)` and `literal` mirror `PostgresRange`. The
generator writes timestamp bounds through `render`, exactly as it does
for ranges.

It implements `PostgresValue`, so filters and writes need no postgrest
change. The parser resolves the bound kind of multiranges, and of arrays
of them, through a table that mirrors the range one.

The range-specific filters (`PostgrestRangeFilters`) still only apply to
range columns. Multirange columns get the generic comparisons.

## Breaking change

Regenerated getters for multirange columns change from `String` to
`PostgresMultirange`.

## Tests

- Unit tests covering parse, quoted bounds containing brackets,
whitespace and `empty` members, malformed literals, render, round trips
and the unmodifiable list.
- The parser test covers every multirange format and its bound kind.
- Fixture columns for `datemultirange` and `tsmultirange`, regenerated
goldens, and a behavior test covering read, write and `eq`.
- `catalog_values` gains `datemultiran... (continued)

Coverage Stats

76 of 79 new or added lines in 4 files covered. (96.2%)

3 existing lines in 1 file now uncovered.

10623 of 11566 relevant lines covered (91.85%)

5.37 hits per line