Cloud Spanner V1 Client - Class Mutation (1.86.0)

Version 1.86.0

• 1.89.0 (latest)
• 1.88.0
• 1.87.0
• 1.86.0
• 1.85.0
• 1.84.0
• 1.83.0
• 1.82.0
• 1.81.0
• 1.80.0
• 1.79.0
• 1.78.0
• 1.77.0
• 1.76.1
• 1.68.0
• 1.67.0
• 1.66.0
• 1.65.0
• 1.64.0
• 1.63.2
• 1.62.1
• 1.61.0
• 1.60.0
• 1.59.0
• 1.58.4
• 1.57.0
• 1.56.0
• 1.55.0
• 1.54.2

Reference documentation and code samples for the Cloud Spanner V1 Client 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.

Generated from protobuf message google.spanner.v1.Mutation

Namespace

Google \ Cloud \ Spanner \ V1

Methods

__construct

Constructor.

Parameters
Name	Description
data	array Optional. Data for populating the Message object.
↳ insert	Google\Cloud\Spanner\V1\Mutation\Write Insert new rows in a table. If any of the rows already exist, the write or transaction fails with error ALREADY_EXISTS.
↳ update	Google\Cloud\Spanner\V1\Mutation\Write Update existing rows in a table. If any of the rows does not already exist, the transaction fails with error NOT_FOUND.
↳ insert_or_update	Google\Cloud\Spanner\V1\Mutation\Write 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	Google\Cloud\Spanner\V1\Mutation\Write 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.
↳ delete	Google\Cloud\Spanner\V1\Mutation\Delete Delete rows from a table. Succeeds whether or not the named rows were present.

getInsert

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

Returns
Type	Description
Google\Cloud\Spanner\V1\Mutation\Write|null

hasInsert

setInsert

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

Parameter
Name	Description
var	Google\Cloud\Spanner\V1\Mutation\Write

Returns
Type	Description
$this

getUpdate

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

Returns
Type	Description
Google\Cloud\Spanner\V1\Mutation\Write|null

hasUpdate

setUpdate

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

Parameter
Name	Description
var	Google\Cloud\Spanner\V1\Mutation\Write

Returns
Type	Description
$this

getInsertOrUpdate

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.

Returns
Type	Description
Google\Cloud\Spanner\V1\Mutation\Write|null

hasInsertOrUpdate

setInsertOrUpdate

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.

Parameter
Name	Description
var	Google\Cloud\Spanner\V1\Mutation\Write

Returns
Type	Description
$this

getReplace

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.

Returns
Type	Description
Google\Cloud\Spanner\V1\Mutation\Write|null

hasReplace

setReplace

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.

Parameter
Name	Description
var	Google\Cloud\Spanner\V1\Mutation\Write

Returns
Type	Description
$this

getDelete

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

Returns
Type	Description
Google\Cloud\Spanner\V1\Mutation\Delete|null

hasDelete

setDelete

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

Parameter
Name	Description
var	Google\Cloud\Spanner\V1\Mutation\Delete

Returns
Type	Description
$this

getOperation

Returns
Type	Description
string