Mutation

import type { Mutation } from "https://googleapis.deno.dev/v1/spanner:v1.ts";

A modification to one or more Cloud Spanner rows. Mutations can be applied to a Cloud Spanner database by sending them in a Commit call.

interface Mutation {

delete?: Delete;

insert?: Write;

insertOrUpdate?: Write;

replace?: Write;

update?: Write;

}

§Properties

delete?: Delete

[src]

Delete rows from a table. Succeeds whether or not the named rows were present.

insert?: Write

[src]

Insert new rows in a table. If any of the rows already exist, the write or transaction fails with error ALREADY_EXISTS.

insertOrUpdate?: Write

[src]

Like insert, except that if the row already exists, then its column values are overwritten with the ones provided. Any column values not explicitly written are preserved. When using insert_or_update, just as when using insert, all NOT NULL columns in the table must be given a value. This holds true even when the row already exists and will therefore actually be updated.

replace?: Write

[src]

Like insert, except that if the row already exists, it is deleted, and the column values provided are inserted instead. Unlike insert_or_update, this means any values not explicitly written become NULL. In an interleaved table, if you create the child table with the ON DELETE CASCADE annotation, then replacing a parent row also deletes the child rows. Otherwise, you must delete the child rows before you replace the parent row.

update?: Write

[src]

Update existing rows in a table. If any of the rows does not already exist, the transaction fails with error NOT_FOUND.