For convenience, callers may wrap instances in a StreamOf<std::tuple<...>> object, which will automatically parse each Row into a std::tuple with the specified types.
Example:
namespace spanner =::google::cloud::spanner; spanner::SqlStatement select( "SELECT AlbumId, AlbumTitle, MarketingBudget" " FROM Albums" " WHERE AlbumTitle >= 'Aardvark' AND AlbumTitle < 'Goo'"); auto profile_query_result = client.ProfileQuery(std::move(select)); for(auto& row : profile_query_result){ if(!row)throw std::move(row).status(); // Discard rows for brevity in this example. }
// Stats are only available after all rows from the result have been read. auto execution_stats = profile_query_result.ExecutionStats(); if(execution_stats){ for(autoconst& stat :*execution_stats){ std::cout << stat.first <<":\t"<< stat.second <<"\n"; } }
[[["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-03-21 UTC."],[[["This document outlines the `ProfileQueryResult` class, which represents the stream of rows and profile statistics returned from `spanner::Client::ProfileQuery()`."],["The `ProfileQueryResult` class is iterable, providing a sequence of `StatusOr\u003cRow\u003e` objects that can be processed sequentially."],["Callers can utilize a `StreamOf\u003cstd::tuple\u003c...\u003e\u003e` to parse each `Row` into a `std::tuple` with defined types."],["After reading all rows, the `ExecutionStats()` function can be called to obtain a collection of key-value pair statistics relating to the SQL statement's execution."],["The `ExecutionPlan()` function can be used to get the execution plan for the SQL statement, and the `ReadTimestamp()` function is available for read-only transactions to fetch the timestamp of the read."]]],[]]