Class ExecuteBatchDmlRequest (3.7.0)

ExecuteBatchDmlRequest(mapping=None, *, ignore_unknown_fields=False, **kwargs)

The request for ExecuteBatchDml][google.spanner.v1.Spanner.ExecuteBatchDml].

Attributes

NameDescription
session str
Required. The session in which the DML statements should be performed.
transaction google.cloud.spanner_v1.types.TransactionSelector
Required. The transaction to use. Must be a read-write transaction. To protect against replays, single-use transactions are not supported. The caller must either supply an existing transaction ID or begin a new transaction.
statements Sequence[google.cloud.spanner_v1.types.ExecuteBatchDmlRequest.Statement]
Required. The list of statements to execute in this batch. Statements are executed serially, such that the effects of statement i are visible to statement i+1. Each statement must be a DML statement. Execution stops at the first failed statement; the remaining statements are not executed. Callers must provide at least one statement.
seqno int
Required. A per-transaction sequence number used to identify this request. This field makes each request idempotent such that if the request is received multiple times, at most one will succeed. The sequence number must be monotonically increasing within the transaction. If a request arrives for the first time with an out-of-order sequence number, the transaction may be aborted. Replays of previously handled requests will yield the same response as the first execution.
request_options google.cloud.spanner_v1.types.RequestOptions
Common options for this request.

Classes

Statement

Statement(mapping=None, *, ignore_unknown_fields=False, **kwargs)

A single DML statement. .. attribute:: sql

Required. The DML string.

:type: str