spanner  v1
Properties | List of all members
Google.Apis.Spanner.v1.Data.Mutation Class Reference

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. More...

Inheritance diagram for Google.Apis.Spanner.v1.Data.Mutation:
Google::Apis::Requests::IDirectResponseSchema

Properties

virtual Delete Delete [get, set]
 Delete rows from a table. Succeeds whether or not the named rows were present. More...
 
virtual Write Insert [get, set]
 Insert new rows in a table. If any of the rows already exist, the write or transaction fails with error ALREADY_EXISTS. More...
 
virtual Write InsertOrUpdate [get, set]
 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. More...
 
virtual Write Replace [get, set]
 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. More...
 
virtual Write Update [get, set]
 Update existing rows in a table. If any of the rows does not already exist, the transaction fails with error NOT_FOUND. More...
 
virtual string ETag [get, set]
 The ETag of the item. More...
 
- Properties inherited from Google::Apis::Requests::IDirectResponseSchema
string ETag
 

Detailed Description

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.

Property Documentation

◆ Delete

virtual Delete Google.Apis.Spanner.v1.Data.Mutation.Delete
getset

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

◆ ETag

virtual string Google.Apis.Spanner.v1.Data.Mutation.ETag
getset

The ETag of the item.

◆ Insert

virtual Write Google.Apis.Spanner.v1.Data.Mutation.Insert
getset

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

◆ InsertOrUpdate

virtual Write Google.Apis.Spanner.v1.Data.Mutation.InsertOrUpdate
getset

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

virtual Write Google.Apis.Spanner.v1.Data.Mutation.Replace
getset

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

virtual Write Google.Apis.Spanner.v1.Data.Mutation.Update
getset

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


The documentation for this class was generated from the following file: