Class PartitionedDml (7.5.0)

This type of transaction is used to execute a single Partitioned DML statement. Partitioned DML partitions the key space and runs the DML statement over each partition in parallel using separate, internal transactions that commit independently.

Chances are, you'll never need to create a partitioned DML transaction directly, instead you'll want to use .

Snapshot

Inheritance

Dml > PartitionedDml

Package

@google-cloud/spanner

Constructors

(constructor)(session, options)

constructor(session: Session, options?: spannerClient.spanner.v1.TransactionOptions.PartitionedDml);

Constructs a new instance of the PartitionedDml class

Parameters
NameDescription
session Session
options PartitionedDml

Methods

runUpdate(query)

runUpdate(query: string | ExecuteSqlRequest): Promise<RunUpdateResponse>;

Execute a DML statement and get the affected row count. Unlike after using this method you should immediately discard this transaction, internally it will invoke .

Parameter
NameDescription
query string | ExecuteSqlRequest

A DML statement or [ExecuteSqlRequest](https://cloud.google.com/spanner/docs/reference/rpc/google.spanner.v1#google.spanner.v1.ExecuteSqlRequest) object.

Returns
TypeDescription
Promise<RunUpdateResponse>

{Promise

Example 

transaction.runUpdate(query, (err, rowRount) => {
  if (err) {
    // Error handling omitted.
  }
});

runUpdate(query, callback)

runUpdate(query: string | ExecuteSqlRequest, callback: RunUpdateCallback): void;
Parameters
NameDescription
query string | ExecuteSqlRequest
callback RunUpdateCallback
Returns
TypeDescription
void