- 1.104.0 (latest)
- 1.103.0
- 1.102.0
- 1.101.0
- 1.100.0
- 1.98.0
- 1.97.0
- 1.96.0
- 1.95.0
- 1.94.0
- 1.93.1
- 1.92.1
- 1.91.0
- 1.90.0
- 1.89.0
- 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 \ V1Methods
__construct
Constructor.
data
array
Optional. Data for populating the Message object.
↳ insert
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
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
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
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
getInsert
Insert new rows in a table. If any of the rows already exist,
the write or transaction fails with error ALREADY_EXISTS
.
hasInsert
setInsert
Insert new rows in a table. If any of the rows already exist,
the write or transaction fails with error ALREADY_EXISTS
.
$this
getUpdate
Update existing rows in a table. If any of the rows does not
already exist, the transaction fails with error NOT_FOUND
.
hasUpdate
setUpdate
Update existing rows in a table. If any of the rows does not
already exist, the transaction fails with error NOT_FOUND
.
$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.
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.
$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.
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.
$this
getDelete
Delete rows from a table. Succeeds whether or not the named rows were present.
hasDelete
setDelete
Delete rows from a table. Succeeds whether or not the named rows were present.
$this
getOperation
string
