Reference documentation and code samples for the Cloud Spanner V1 API class Google::Cloud::Spanner::V1::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.
Inherits
- Object
Extended By
- Google::Protobuf::MessageExts::ClassMethods
Includes
- Google::Protobuf::MessageExts
Methods
#delete
def delete() -> ::Google::Cloud::Spanner::V1::Mutation::Delete
- (::Google::Cloud::Spanner::V1::Mutation::Delete) — Delete rows from a table. Succeeds whether or not the named rows were present.
#delete=
def delete=(value) -> ::Google::Cloud::Spanner::V1::Mutation::Delete
- value (::Google::Cloud::Spanner::V1::Mutation::Delete) — Delete rows from a table. Succeeds whether or not the named rows were present.
- (::Google::Cloud::Spanner::V1::Mutation::Delete) — Delete rows from a table. Succeeds whether or not the named rows were present.
#insert
def insert() -> ::Google::Cloud::Spanner::V1::Mutation::Write
-
(::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
.
#insert=
def insert=(value) -> ::Google::Cloud::Spanner::V1::Mutation::Write
-
value (::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
.
-
(::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
.
#insert_or_update
def insert_or_update() -> ::Google::Cloud::Spanner::V1::Mutation::Write
-
(::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.
#insert_or_update=
def insert_or_update=(value) -> ::Google::Cloud::Spanner::V1::Mutation::Write
-
value (::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.
-
(::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
def replace() -> ::Google::Cloud::Spanner::V1::Mutation::Write
-
(::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.
#replace=
def replace=(value) -> ::Google::Cloud::Spanner::V1::Mutation::Write
-
value (::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.
-
(::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.
#update
def update() -> ::Google::Cloud::Spanner::V1::Mutation::Write
-
(::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
.
#update=
def update=(value) -> ::Google::Cloud::Spanner::V1::Mutation::Write
-
value (::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
.
-
(::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
.