supabase / supabase / 42034797724

87%

push

github

feat(studio): duplicate row and keep values with Create more in Table Editor (#52952)

## What

Two additions to the Table Editor's Insert Row flow:

- **Duplicate row**: new item in the row context menu. Opens the Insert
Row panel as a new record, pre-filled from the selected row.
- **Keep values**: a gear button next to \"Create more\" (visible only
while \"Create more\" is on) opens a \"Row creation options\" popover
with a \"Keep values for the next row\" checkbox. When checked, the form
keeps its values after each insert instead of clearing. Off by default,
so existing behavior is unchanged.

## How

- Both use a shared helper, `generateReusedRowFields`, that clears
primary key, identity, function-defaulted (e.g. `gen_random_uuid()`,
`nextval(...)`, `now()`, `CURRENT_TIMESTAMP`), and truncated values.
Cleared columns fall back to their blank state so the database fills
them in. A boolean with a function default is left unset so the database
evaluates it.
- Duplicate adds a `duplicateFrom` field to the `row` side panel state
rather than reusing `row`, so the panel stays in insert mode and can't
turn into an update.
- The popover lives in a new co-located `RowCreationOptions` component.
Its notch is a rotated square drawn inside the popover content,
positioned over the trigger by Radix.

<img width="165" height="220" alt="Screenshot 2026-11-04 at 15 22 20"
src="https://github.com/user-attachments/assets/145e3aeb-9f6f-4826-a789-a0e462d3d1d5"
/>

<img width="678" height="202" alt="Screenshot 2026-11-05 at 11 41 35"
src="https://github.com/user-attachments/assets/07cc5251-e2fc-417c-90bd-6b6268a2c0c7"
/>


## Notes

- Columns with unique constraints other than the primary key are still
copied, so saving a duplicate can fail with the normal error toast.
- Large values (over 10 KB) are truncated by the grid query, so
duplicate clears them rather than copying a corrupted value. Copying
them is tracked in FE-4927.

## Testing

- Unit tests for the helper (... (continued)

2043 of 2411 branches covered (84.74%)

Branch coverage included in aggregate %.

2839 of 3198 relevant lines covered (88.77%)

201.12 hits per line