Reference documentation and code samples for the Cloud Spanner V1 API class Google::Cloud::Spanner::V1::ExecuteBatchDmlResponse.
The response for ExecuteBatchDml. Contains a list of ResultSet messages, one for each DML statement that has successfully executed, in the same order as the statements in the request. If a statement fails, the status in the response body identifies the cause of the failure.
To check for DML statements that failed, use the following approach:
- Check the status in the response message. The
[google.rpc.Code][google.rpc.Code] enum
value
OK
indicates that all statements were executed successfully. - If the status was not
OK
, check the number of result sets in the response. If the response containsN
ResultSet messages, then statementN+1
in the request failed.
Example 1:
- Request: 5 DML statements, all executed successfully.
- Response: 5 ResultSet messages, with the
status
OK
.
Example 2:
Inherits
- Object
Extended By
- Google::Protobuf::MessageExts::ClassMethods
Includes
- Google::Protobuf::MessageExts
Methods
#result_sets
def result_sets() -> ::Array<::Google::Cloud::Spanner::V1::ResultSet>
-
(::Array<::Google::Cloud::Spanner::V1::ResultSet>) — One ResultSet for each statement in the
request that ran successfully, in the same order as the statements in the
request. Each ResultSet does not contain any
rows. The ResultSetStats in each
ResultSet contain the number of rows
modified by the statement.
Only the first ResultSet in the response contains valid ResultSetMetadata.
#result_sets=
def result_sets=(value) -> ::Array<::Google::Cloud::Spanner::V1::ResultSet>
-
value (::Array<::Google::Cloud::Spanner::V1::ResultSet>) — One ResultSet for each statement in the
request that ran successfully, in the same order as the statements in the
request. Each ResultSet does not contain any
rows. The ResultSetStats in each
ResultSet contain the number of rows
modified by the statement.
Only the first ResultSet in the response contains valid ResultSetMetadata.
-
(::Array<::Google::Cloud::Spanner::V1::ResultSet>) — One ResultSet for each statement in the
request that ran successfully, in the same order as the statements in the
request. Each ResultSet does not contain any
rows. The ResultSetStats in each
ResultSet contain the number of rows
modified by the statement.
Only the first ResultSet in the response contains valid ResultSetMetadata.
#status
def status() -> ::Google::Rpc::Status
-
(::Google::Rpc::Status) — If all DML statements are executed successfully, the status is
OK
. Otherwise, the error status of the first failed statement.
#status=
def status=(value) -> ::Google::Rpc::Status
-
value (::Google::Rpc::Status) — If all DML statements are executed successfully, the status is
OK
. Otherwise, the error status of the first failed statement.
-
(::Google::Rpc::Status) — If all DML statements are executed successfully, the status is
OK
. Otherwise, the error status of the first failed statement.