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 (auto const& 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-14 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, allowing direct iteration to access a sequence of `StatusOr\u003cRow\u003e` objects."],["Callers can wrap the instance in a `StreamOf\u003cstd::tuple\u003c...\u003e\u003e` to automatically parse each `Row` into a `std::tuple` with the specified types."],["After reading all rows, `ExecutionStats()` can be called to retrieve key-value pair statistics for the executed SQL statement, while `ReadTimestamp()` will retrieve the timestamp at which the read occurred if a read-only transaction was used."],["The methods `begin()` and `end()` are used to return a `RowStreamIterator` that defines the start and end of the result set, respectively, and the method `ExecutionPlan()` will return the plan of execution for the SQL statement."]]],[]]
