supabase / supabase-flutter / 38902895875

92%

push

github

feat(typegen): non-null view columns from postgrest-typegen 0.6.0 (#1968)

## What

`@supabase/postgrest-typegen` 0.6.0 (bundled by `typegen` 0.3.1) infers
view column nullability from the source column (supabase/sdk#284). A
view column that passes through a `NOT NULL` column, outside the
nullable side of an outer join, is no longer reported as nullable. This
updates `supabase_typegen` to that document.

## Changes

- Regenerated `test/fixtures/generator_metadata.json` on a fresh
`postgres:15` with `postgrest-typegen/v0.6.0`. Eight view columns flip
to non-null: `author_stats.author_id`, `book_prices.id`/`title`,
`book_summaries.id`/`title`/`author_name` and
`book_submissions.title`/`author_name`. Computed columns such as
`count(*)` and `price * 0.9` stay nullable. The release also marks
`latest_book` and `recent_books` as not callable through `/rpc`
(supabase/sdk#272), which changes no generated code.
- View and materialized view columns are never required on insert. The
catalog does not carry the base table default onto the view column, so a
non-null column like `book_prices.id` (an identity on `books`) can still
be omitted when inserting through the view. This matches the TypeScript
generator, which makes every view `Insert` and `Update` field optional.
- Regenerated the goldens: those view columns become `T` on the row and
`PostgrestColumn` instead of `PostgrestNullableColumn`, and their
`setXToNull()` helpers are gone.


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

## Summary by CodeRabbit

* **Bug Fixes**
* Generated types now preserve non-nullable column information for views
and materialized views, while correctly keeping view columns out of
required insert fields.
* Insert and update helpers no longer offer null-setting methods for
columns declared non-nullable.
* Generated types for tables continue to mark non-nullable columns
without defaults as required for inserts.

<!-- end of auto-generated comment: releas... (continued)

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

9638 of 10477 relevant lines covered (91.99%)

5.45 hits per line