Cloud Spanner V1 Client - Class ResultSet (1.54.2)

Reference documentation and code samples for the Cloud Spanner V1 Client class ResultSet.

Results from Read or ExecuteSql.

Generated from protobuf message google.spanner.v1.ResultSet

Methods

__construct

Constructor.

Parameters
NameDescription
data array

Optional. Data for populating the Message object.

↳ metadata Google\Cloud\Spanner\V1\ResultSetMetadata

Metadata about the result set, such as row type information.

↳ rows array<Google\Protobuf\ListValue>

Each element in rows is a row whose format is defined by metadata.row_type. The ith element in each row matches the ith field in metadata.row_type. Elements are encoded based on type as described here.

↳ stats Google\Cloud\Spanner\V1\ResultSetStats

Query plan and execution statistics for the SQL statement that produced this result set. These can be requested by setting ExecuteSqlRequest.query_mode. DML statements always produce stats containing the number of rows modified, unless executed using the ExecuteSqlRequest.QueryMode.PLAN ExecuteSqlRequest.query_mode. Other fields may or may not be populated, based on the ExecuteSqlRequest.query_mode.

getMetadata

Metadata about the result set, such as row type information.

Generated from protobuf field .google.spanner.v1.ResultSetMetadata metadata = 1;

Returns
TypeDescription
Google\Cloud\Spanner\V1\ResultSetMetadata|null

hasMetadata

clearMetadata

setMetadata

Metadata about the result set, such as row type information.

Generated from protobuf field .google.spanner.v1.ResultSetMetadata metadata = 1;

Parameter
NameDescription
var Google\Cloud\Spanner\V1\ResultSetMetadata
Returns
TypeDescription
$this

getRows

Each element in rows is a row whose format is defined by metadata.row_type. The ith element in each row matches the ith field in metadata.row_type. Elements are encoded based on type as described here.

Generated from protobuf field repeated .google.protobuf.ListValue rows = 2;

Returns
TypeDescription
Google\Protobuf\Internal\RepeatedField

setRows

Each element in rows is a row whose format is defined by metadata.row_type. The ith element in each row matches the ith field in metadata.row_type. Elements are encoded based on type as described here.

Generated from protobuf field repeated .google.protobuf.ListValue rows = 2;

Parameter
NameDescription
var array<Google\Protobuf\ListValue>
Returns
TypeDescription
$this

getStats

Query plan and execution statistics for the SQL statement that produced this result set. These can be requested by setting ExecuteSqlRequest.query_mode.

DML statements always produce stats containing the number of rows modified, unless executed using the ExecuteSqlRequest.QueryMode.PLAN ExecuteSqlRequest.query_mode. Other fields may or may not be populated, based on the ExecuteSqlRequest.query_mode.

Generated from protobuf field .google.spanner.v1.ResultSetStats stats = 3;

Returns
TypeDescription
Google\Cloud\Spanner\V1\ResultSetStats|null

hasStats

clearStats

setStats

Query plan and execution statistics for the SQL statement that produced this result set. These can be requested by setting ExecuteSqlRequest.query_mode.

DML statements always produce stats containing the number of rows modified, unless executed using the ExecuteSqlRequest.QueryMode.PLAN ExecuteSqlRequest.query_mode. Other fields may or may not be populated, based on the ExecuteSqlRequest.query_mode.

Generated from protobuf field .google.spanner.v1.ResultSetStats stats = 3;

Parameter
NameDescription
var Google\Cloud\Spanner\V1\ResultSetStats
Returns
TypeDescription
$this