NeonInstall

Summary

Update rows in a Neon database table matching specified criteria.

Inputs

• schema — The schema to use for the table.
• table — The table to update.
• columns (required) — Mapping of input columns to target columns for the update operation.
• cascade — Whether to drop all objects that depend on the table, such as views and sequences.
• delayClosingIdleConnection — Number of seconds to wait before an idle connection would be eligible for closing.
• outputColumns — Choose from the list, or specify IDs using an expression.
• outputLargeFormatNumberAs — How to handle PostgreSQL BIGINT/NUMERIC types that exceed JavaScript limits.
• queryMode — The way queries should be sent to the database.
• queryParameters — Comma-separated list of the values you want to use as query parameters, referenced as $1, $2, $3…
• replaceEmptyStrings — Whether to replace empty strings with NULL in input, could be useful when data come from spreadsheet.
• skipOnConflict — Whether to skip the row and do not throw error if a unique constraint or exclusion constraint is violated.

Output shape

a list of updated rows

May be empty if no rows match; updates are applied silently; errors are thrown as NodeOperationError.

Examples

Example 1: Update user status

Schema: public, Table: users, Columns: {"status":"active"}, Options: {"outputColumns":["id","status"],"queryMode":"single"}

Example 2: Update orders with cascade

Schema: main, Table: orders, Columns: {"status":"canceled"}, Options: {"cascade":true,"queryMode":"transaction"}

Example 3: Update invoices using query parameters

Schema: sales, Table: invoices, Columns: {"amount":"total"}, Options: {"queryParameters":"1000,2000","outputLargeFormatNumberAs":"string"}