Class Mutation (1.16.0)

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

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

Like insert][google.spanner.v1.Mutation.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_upd ate][google.spanner.v1.Mutation.insert_or_update], just as when using insert][google.spanner.v1.Mutation.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.

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

Classes

Delete

Arguments to delete][google.spanner.v1.Mutation.delete] operations.

Required. The primary keys of the rows within table][google.spanner.v1.Mutation.Delete.table] to delete. The primary keys must be specified in the order in which they appear in the PRIMARY KEY() clause of the table's equivalent DDL statement (the DDL statement used to create the table). Delete is idempotent. The transaction will succeed even if some or all rows do not exist.

Write

Arguments to insert][google.spanner.v1.Mutation.insert], update][google.spanner.v1.Mutation.update], [insert_or_update][google.spanner.v1.Mutation.insert_or_update], and replace][google.spanner.v1.Mutation.replace] operations.

The names of the columns in table][google.spanner.v1.Mutation.Write.table] to be written. The list of columns must contain enough columns to allow Cloud Spanner to derive values for all primary key columns in the row(s) to be modified.