Class Mutation

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.

Inheritance

object

Mutation

Implements

IDirectResponseSchema

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Google.Apis.Spanner.v1.Data

Assembly: Google.Apis.Spanner.v1.dll

Syntax

public class Mutation : IDirectResponseSchema

Properties

Delete

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

Declaration

[JsonProperty("delete")]
public virtual Delete Delete { get; set; }

Property Value

Type	Description
Delete

ETag

The ETag of the item.

Declaration

public virtual string ETag { get; set; }

Property Value

Type	Description
string

Insert

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

Declaration

[JsonProperty("insert")]
public virtual Write Insert { get; set; }

Property Value

Type	Description
Write

InsertOrUpdate

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.

Declaration

[JsonProperty("insertOrUpdate")]
public virtual Write InsertOrUpdate { get; set; }

Property Value

Type	Description
Write

Replace

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.

Declaration

[JsonProperty("replace")]
public virtual Write Replace { get; set; }

Property Value

Type	Description
Write

Update

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

Declaration

[JsonProperty("update")]
public virtual Write Update { get; set; }

Property Value

Type	Description
Write

Implements

IDirectResponseSchema