Cloud Spanner Client - Class BatchDmlResult (1.60.0)

Version 1.60.0

• 1.88.0 (latest)
• 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 Client class BatchDmlResult.

Represents the result of a Batch DML operation.

Example:

use Google\Cloud\Spanner\SpannerClient;
use Google\Cloud\Spanner\Transaction;

$spanner = new SpannerClient();
$database = $spanner->connect('my-instance', 'my-database');

$batchDmlResult = $database->runTransaction(function (Transaction $t) {
    $result = $t->executeUpdateBatch([
        [
            'sql' => 'UPDATE posts SET author = @author WHERE id = @id',
            'params' => [
                'author' => 'John',
                'id' => 1
            ]
        ]
    ]);

    $t->commit();

    return $result;
});

Methods

__construct

Parameters
Name	Description
data	array The executeBatchDml response data.
errorStatement	array|null The statement (with params and types) which triggered an error.

rowCounts

Get a list of integers indicating the number of modified rows for each successful statement.

Example:

$counts = $batchDmlResult->rowCounts();

Returns
Type	Description
int[]

error

Get a Batch DML error, if one exists.

If an error occurred, the method returns an array, where the status key contains error information, represented as google.rpc.Status, and the 'statement` key contains the input which caused the error.

If no error occurred, this method returns null.

Example:

$error = $batchDmlResult->error();

Returns
Type	Description
array|null