Delete Row(s) - Pipedream

import neon from "../../neon_postgres.app.mjs"; export default { name: "Delete Row(s)", key: "neon_postgres-delete-rows", description: "Deletes a row or rows from a table. [See the documentation](https://node-postgres.com/features/queries)", version: "0.0.1", type: "action", props: { neon, schema: { propDefinition: [ neon, "schema", ], }, table: { propDefinition: [ neon, "table", (c) => ({ schema: c.schema, }), ], }, column: { propDefinition: [ neon, "column", (c) => ({ table: c.table, schema: c.schema, }), ], label: "Lookup Column", description: "Find row(s) by searching for a value in this column", }, value: { propDefinition: [ neon, "value", (c) => ({ table: c.table, column: c.column, schema: c.schema, }), ], }, }, async run({ $ }) { const { table, schema, column, value, } = this; const errorMsg = "Row not deleted due to an error. "; const rows = await this.neon.deleteRows( schema, table, column, value, errorMsg, ); $.export("$summary", `Deleted ${rows.length} rows from ${table}`); return rows; }, };

Label	Prop	Type	Description
Neon Postgres	`neon`	`app`	This component uses the Neon Postgres app.
Schema	`schema`	`string`	Select a value from the drop down menu.
Table	`table`	`string`	Select a value from the drop down menu.
Lookup Column	`column`	`string`	Select a value from the drop down menu.
Lookup Value	`value`	`string`	Select a value from the drop down menu.

Label

Prop

Type

Description

Neon Postgres

neon

app

This component uses the Neon Postgres app.

Schema

schema

string

Select a value from the drop down menu.