feat: Add the last statement option to ExecuteSqlRequest and ExecuteBatchDmlRequest

Google APIs · copybara-github · commit 97da65f78924 · 2024-11-22T10:39:30.000-08:00
PiperOrigin-RevId: 699218836
diff --git a/google/spanner/v1/spanner.proto b/google/spanner/v1/spanner.proto
@@ -792,6 +792,17 @@ message ExecuteSqlRequest {
   // If the field is set to `true` but the request does not set
   // `partition_token`, the API returns an `INVALID_ARGUMENT` error.
   bool data_boost_enabled = 16;
+
+  // Optional. If set to true, this statement marks the end of the transaction.
+  // The transaction should be committed or aborted after this statement
+  // executes, and attempts to execute any other requests against this
+  // transaction (including reads and queries) will be rejected.
+  //
+  // For DML statements, setting this option may cause some error reporting to
+  // be deferred until commit time (e.g. validation of unique constraints).
+  // Given this, successful execution of a DML statement should not be assumed
+  // until a subsequent Commit call completes successfully.
+  bool last_statement = 17 [(google.api.field_behavior) = OPTIONAL];
 }
 
 // The request for [ExecuteBatchDml][google.spanner.v1.Spanner.ExecuteBatchDml].
@@ -861,6 +872,17 @@ message ExecuteBatchDmlRequest {
 
   // Common options for this request.
   RequestOptions request_options = 5;
+
+  // Optional. If set to true, this request marks the end of the transaction.
+  // The transaction should be committed or aborted after these statements
+  // execute, and attempts to execute any other requests against this
+  // transaction (including reads and queries) will be rejected.
+  //
+  // Setting this option may cause some error reporting to be deferred until
+  // commit time (e.g. validation of unique constraints). Given this, successful
+  // execution of statements should not be assumed until a subsequent Commit
+  // call completes successfully.
+  bool last_statements = 6 [(google.api.field_behavior) = OPTIONAL];
 }
 
 // The response for
