Note: The following fields are mutually exclusive: begin, single_use, id. If a field in that set is populated, all other fields in the set will automatically be cleared.
Note: The following fields are mutually exclusive: begin, single_use, id. If a field in that set is populated, all other fields in the set will automatically be cleared.
Note: The following fields are mutually exclusive: begin, single_use, id. If a field in that set is populated, all other fields in the set will automatically be cleared.
#id
defid()->::String
Returns
(::String) — Execute the read or SQL query in a previously-started transaction.
Note: The following fields are mutually exclusive: id, single_use, begin. If a field in that set is populated, all other fields in the set will automatically be cleared.
#id=
defid=(value)->::String
Parameter
value (::String) — Execute the read or SQL query in a previously-started transaction.
Note: The following fields are mutually exclusive: id, single_use, begin. If a field in that set is populated, all other fields in the set will automatically be cleared.
Returns
(::String) — Execute the read or SQL query in a previously-started transaction.
Note: The following fields are mutually exclusive: id, single_use, begin. If a field in that set is populated, all other fields in the set will automatically be cleared.
(::Google::Cloud::Spanner::V1::TransactionOptions) — Execute the read or SQL query in a temporary transaction.
This is the most efficient way to execute a transaction that
consists of a single SQL query.
Note: The following fields are mutually exclusive: single_use, id, begin. If a field in that set is populated, all other fields in the set will automatically be cleared.
value (::Google::Cloud::Spanner::V1::TransactionOptions) — Execute the read or SQL query in a temporary transaction.
This is the most efficient way to execute a transaction that
consists of a single SQL query.
Note: The following fields are mutually exclusive: single_use, id, begin. If a field in that set is populated, all other fields in the set will automatically be cleared.
Returns
(::Google::Cloud::Spanner::V1::TransactionOptions) — Execute the read or SQL query in a temporary transaction.
This is the most efficient way to execute a transaction that
consists of a single SQL query.
Note: The following fields are mutually exclusive: single_use, id, begin. If a field in that set is populated, all other fields in the set will automatically be cleared.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-28 UTC."],[],[],null,["# Cloud Spanner V1 API - Class Google::Cloud::Spanner::V1::TransactionSelector (v1.10.0)\n\nVersion latestkeyboard_arrow_down\n\n- [1.10.0 (latest)](/ruby/docs/reference/google-cloud-spanner-v1/latest/Google-Cloud-Spanner-V1-TransactionSelector)\n- [1.9.1](/ruby/docs/reference/google-cloud-spanner-v1/1.9.1/Google-Cloud-Spanner-V1-TransactionSelector)\n- [1.8.0](/ruby/docs/reference/google-cloud-spanner-v1/1.8.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [1.7.1](/ruby/docs/reference/google-cloud-spanner-v1/1.7.1/Google-Cloud-Spanner-V1-TransactionSelector)\n- [1.6.0](/ruby/docs/reference/google-cloud-spanner-v1/1.6.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [1.5.0](/ruby/docs/reference/google-cloud-spanner-v1/1.5.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [1.4.0](/ruby/docs/reference/google-cloud-spanner-v1/1.4.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [1.3.0](/ruby/docs/reference/google-cloud-spanner-v1/1.3.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [1.2.0](/ruby/docs/reference/google-cloud-spanner-v1/1.2.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [1.1.0](/ruby/docs/reference/google-cloud-spanner-v1/1.1.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [1.0.2](/ruby/docs/reference/google-cloud-spanner-v1/1.0.2/Google-Cloud-Spanner-V1-TransactionSelector)\n- [0.27.0](/ruby/docs/reference/google-cloud-spanner-v1/0.27.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [0.26.0](/ruby/docs/reference/google-cloud-spanner-v1/0.26.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [0.25.0](/ruby/docs/reference/google-cloud-spanner-v1/0.25.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [0.24.0](/ruby/docs/reference/google-cloud-spanner-v1/0.24.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [0.23.0](/ruby/docs/reference/google-cloud-spanner-v1/0.23.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [0.22.2](/ruby/docs/reference/google-cloud-spanner-v1/0.22.2/Google-Cloud-Spanner-V1-TransactionSelector)\n- [0.21.0](/ruby/docs/reference/google-cloud-spanner-v1/0.21.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [0.20.1](/ruby/docs/reference/google-cloud-spanner-v1/0.20.1/Google-Cloud-Spanner-V1-TransactionSelector)\n- [0.19.0](/ruby/docs/reference/google-cloud-spanner-v1/0.19.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [0.18.0](/ruby/docs/reference/google-cloud-spanner-v1/0.18.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [0.17.0](/ruby/docs/reference/google-cloud-spanner-v1/0.17.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [0.16.0](/ruby/docs/reference/google-cloud-spanner-v1/0.16.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [0.15.1](/ruby/docs/reference/google-cloud-spanner-v1/0.15.1/Google-Cloud-Spanner-V1-TransactionSelector)\n- [0.14.1](/ruby/docs/reference/google-cloud-spanner-v1/0.14.1/Google-Cloud-Spanner-V1-TransactionSelector)\n- [0.13.0](/ruby/docs/reference/google-cloud-spanner-v1/0.13.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [0.12.0](/ruby/docs/reference/google-cloud-spanner-v1/0.12.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [0.11.0](/ruby/docs/reference/google-cloud-spanner-v1/0.11.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [0.10.0](/ruby/docs/reference/google-cloud-spanner-v1/0.10.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [0.9.0](/ruby/docs/reference/google-cloud-spanner-v1/0.9.0/Google-Cloud-Spanner-V1-TransactionSelector)\n- [0.8.1](/ruby/docs/reference/google-cloud-spanner-v1/0.8.1/Google-Cloud-Spanner-V1-TransactionSelector)\n- [0.7.4](/ruby/docs/reference/google-cloud-spanner-v1/0.7.4/Google-Cloud-Spanner-V1-TransactionSelector) \nReference documentation and code samples for the Cloud Spanner V1 API class Google::Cloud::Spanner::V1::TransactionSelector.\n\nThis message is used to select the transaction in which a\n[Read](/ruby/docs/reference/google-cloud-spanner-v1/latest/Google-Cloud-Spanner-V1-Spanner-Client#Google__Cloud__Spanner__V1__Spanner__Client_read_instance_ \"Google::Cloud::Spanner::V1::Spanner::Client#read (method)\") or\n[ExecuteSql](/ruby/docs/reference/google-cloud-spanner-v1/latest/Google-Cloud-Spanner-V1-Spanner-Client#Google__Cloud__Spanner__V1__Spanner__Client_execute_sql_instance_ \"Google::Cloud::Spanner::V1::Spanner::Client#execute_sql (method)\") call runs.\n\n\n\u003cbr /\u003e\n\nSee [TransactionOptions](/ruby/docs/reference/google-cloud-spanner-v1/latest/Google-Cloud-Spanner-V1-TransactionOptions \"Google::Cloud::Spanner::V1::TransactionOptions (class)\") for more\ninformation about transactions. \n\nInherits\n--------\n\n- Object \n\nExtended By\n-----------\n\n- Google::Protobuf::MessageExts::ClassMethods \n\nIncludes\n--------\n\n- Google::Protobuf::MessageExts\n\nMethods\n-------\n\n### #begin\n\n def begin() -\u003e ::Google::Cloud::Spanner::V1::TransactionOptions\n\n**Returns**\n\n- ([::Google::Cloud::Spanner::V1::TransactionOptions](./Google-Cloud-Spanner-V1-TransactionOptions)) --- Begin a new transaction and execute this read or SQL query in it. The transaction ID of the new transaction is returned in [ResultSetMetadata.transaction](/ruby/docs/reference/google-cloud-spanner-v1/latest/Google-Cloud-Spanner-V1-ResultSetMetadata#Google__Cloud__Spanner__V1__ResultSetMetadata_transaction_instance_ \"Google::Cloud::Spanner::V1::ResultSetMetadata#transaction (method)\"), which is a [Transaction](/ruby/docs/reference/google-cloud-spanner-v1/latest/Google-Cloud-Spanner-V1-Transaction \"Google::Cloud::Spanner::V1::Transaction (class)\").\n\n\n Note: The following fields are mutually exclusive: `begin`, `single_use`, `id`. If a field in that set is populated, all other fields in the set will automatically be cleared.\n\n### #begin=\n\n def begin=(value) -\u003e ::Google::Cloud::Spanner::V1::TransactionOptions\n\n**Parameter**\n\n- **value** ([::Google::Cloud::Spanner::V1::TransactionOptions](./Google-Cloud-Spanner-V1-TransactionOptions)) --- Begin a new transaction and execute this read or SQL query in it. The transaction ID of the new transaction is returned in [ResultSetMetadata.transaction](/ruby/docs/reference/google-cloud-spanner-v1/latest/Google-Cloud-Spanner-V1-ResultSetMetadata#Google__Cloud__Spanner__V1__ResultSetMetadata_transaction_instance_ \"Google::Cloud::Spanner::V1::ResultSetMetadata#transaction (method)\"), which is a [Transaction](/ruby/docs/reference/google-cloud-spanner-v1/latest/Google-Cloud-Spanner-V1-Transaction \"Google::Cloud::Spanner::V1::Transaction (class)\").\n\n\nNote: The following fields are mutually exclusive: `begin`, `single_use`, `id`. If a field in that set is populated, all other fields in the set will automatically be cleared. \n**Returns**\n\n- ([::Google::Cloud::Spanner::V1::TransactionOptions](./Google-Cloud-Spanner-V1-TransactionOptions)) --- Begin a new transaction and execute this read or SQL query in it. The transaction ID of the new transaction is returned in [ResultSetMetadata.transaction](/ruby/docs/reference/google-cloud-spanner-v1/latest/Google-Cloud-Spanner-V1-ResultSetMetadata#Google__Cloud__Spanner__V1__ResultSetMetadata_transaction_instance_ \"Google::Cloud::Spanner::V1::ResultSetMetadata#transaction (method)\"), which is a [Transaction](/ruby/docs/reference/google-cloud-spanner-v1/latest/Google-Cloud-Spanner-V1-Transaction \"Google::Cloud::Spanner::V1::Transaction (class)\").\n\n\n Note: The following fields are mutually exclusive: `begin`, `single_use`, `id`. If a field in that set is populated, all other fields in the set will automatically be cleared.\n\n### #id\n\n def id() -\u003e ::String\n\n**Returns**\n\n- (::String) --- Execute the read or SQL query in a previously-started transaction.\n\n Note: The following fields are mutually exclusive: `id`, `single_use`, `begin`. If a field in that set is populated, all other fields in the set will automatically be cleared.\n\n### #id=\n\n def id=(value) -\u003e ::String\n\n**Parameter**\n\n- **value** (::String) --- Execute the read or SQL query in a previously-started transaction.\n\n\nNote: The following fields are mutually exclusive: `id`, `single_use`, `begin`. If a field in that set is populated, all other fields in the set will automatically be cleared. \n**Returns**\n\n- (::String) --- Execute the read or SQL query in a previously-started transaction.\n\n Note: The following fields are mutually exclusive: `id`, `single_use`, `begin`. If a field in that set is populated, all other fields in the set will automatically be cleared.\n\n### #single_use\n\n def single_use() -\u003e ::Google::Cloud::Spanner::V1::TransactionOptions\n\n**Returns**\n\n- ([::Google::Cloud::Spanner::V1::TransactionOptions](./Google-Cloud-Spanner-V1-TransactionOptions)) --- Execute the read or SQL query in a temporary transaction. This is the most efficient way to execute a transaction that consists of a single SQL query.\n\n\n Note: The following fields are mutually exclusive: `single_use`, `id`, `begin`. If a field in that set is populated, all other fields in the set will automatically be cleared.\n\n### #single_use=\n\n def single_use=(value) -\u003e ::Google::Cloud::Spanner::V1::TransactionOptions\n\n**Parameter**\n\n- **value** ([::Google::Cloud::Spanner::V1::TransactionOptions](./Google-Cloud-Spanner-V1-TransactionOptions)) --- Execute the read or SQL query in a temporary transaction. This is the most efficient way to execute a transaction that consists of a single SQL query.\n\n\nNote: The following fields are mutually exclusive: `single_use`, `id`, `begin`. If a field in that set is populated, all other fields in the set will automatically be cleared. \n**Returns**\n\n- ([::Google::Cloud::Spanner::V1::TransactionOptions](./Google-Cloud-Spanner-V1-TransactionOptions)) --- Execute the read or SQL query in a temporary transaction. This is the most efficient way to execute a transaction that consists of a single SQL query.\n\n\n Note: The following fields are mutually exclusive: `single_use`, `id`, `begin`. If a field in that set is populated, all other fields in the set will automatically be cleared."]]