[data.delete]

data.delete is a slot in the data namespace, in Hyperlambda, the language of Magic Cloud. Deletes rows in the current open database connection; include a [where] child unless intentionally deleting every row in the table.

Returns: Resolves to the number of rows affected
Scope: requires data.connection - Requires an open database connection created by [data.connect]

Arguments

Required arguments come first, then the optional ones in the order they are declared.

Argument	Type	Required	Description
`[table]`	string	yes	Table name to use in the SQL statement.
`[where]`	lambda	yes	Required boolean predicate tree — destructive SQL must constrain affected rows.
`[where]` / `[and]`	lambda	no	Boolean AND group.
`[where]` / `[and]` / any node name	object	yes	Column condition; suffix the name with .eq, .neq, .gt, .gte, .lt, .lte, .like, .ilike, or .in to select an operator. Can be repeated.
`[where]` / `[and]` / any node name / unnamed child node	object	no	Value item used by operators such as .in.
`[where]` / `[and]` / `[or]`	lambda	no	Boolean OR group. Can be repeated.
`[where]` / `[and]` / `[or]` / any node name	object	yes	Column condition; suffix the name with .eq, .neq, .gt, .gte, .lt, .lte, .like, .ilike, or .in to select an operator. Can be repeated.
`[where]` / `[and]` / `[or]` / any node name / unnamed child node	object	no	Value item used by operators such as .in.
`[where]` / `[or]`	lambda	no	Boolean OR group.
`[where]` / `[or]` / any node name	object	yes	Column condition; suffix the name with .eq, .neq, .gt, .gte, .lt, .lte, .like, .ilike, or .in to select an operator. Can be repeated.
`[where]` / `[or]` / any node name / unnamed child node	object	no	Value item used by operators such as .in.
`[where]` / `[or]` / `[and]`	lambda	no	Boolean AND group. Can be repeated.
`[where]` / `[or]` / `[and]` / any node name	object	yes	Column condition; suffix the name with .eq, .neq, .gt, .gte, .lt, .lte, .like, .ilike, or .in to select an operator. Can be repeated.
`[where]` / `[or]` / `[and]` / any node name / unnamed child node	object	no	Value item used by operators such as .in.
`[database-type]`	string	no	Database adapter to use instead of the configured default.
`[generate]`	bool	no	Whether to only generate SQL and parameter nodes instead of executing it. Default: `false`.

Nodes nested deeper than 6 levels, and nodes that repeat one of their own ancestors, are not listed. The JSON declaration below has all of them.

JSON declaration

This is the complete declaration of data.delete, as the running system describes it. It is also published as slot.json.

JSON declaration (loads when opened)

← data.create

all data.* slots

data.execute →