Cloud Spanner V1 Client - Class ResultSetMetadata (1.68.0)

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

Metadata about a ResultSet or PartialResultSet.

Generated from protobuf message google.spanner.v1.ResultSetMetadata

Namespace

Google \ Cloud \ Spanner \ V1

Methods

__construct

Constructor.

Parameters
NameDescription
data array

Optional. Data for populating the Message object.

↳ row_type Google\Cloud\Spanner\V1\StructType

Indicates the field names and types for the rows in the result set. For example, a SQL query like "SELECT UserId, UserName FROM Users" could return a row_type value like: "fields": [ { "name": "UserId", "type": { "code": "INT64" } }, { "name": "UserName", "type": { "code": "STRING" } }, ]

↳ transaction Google\Cloud\Spanner\V1\Transaction

If the read or SQL query began a transaction as a side-effect, the information about the new transaction is yielded here.

↳ undeclared_parameters Google\Cloud\Spanner\V1\StructType

A SQL query can be parameterized. In PLAN mode, these parameters can be undeclared. This indicates the field names and types for those undeclared parameters in the SQL query. For example, a SQL query like "SELECT * FROM Users where UserId = @userId and UserName = @userName " could return a undeclared_parameters value like: "fields": [ { "name": "UserId", "type": { "code": "INT64" } }, { "name": "UserName", "type": { "code": "STRING" } }, ]

getRowType

Indicates the field names and types for the rows in the result set. For example, a SQL query like "SELECT UserId, UserName FROM Users" could return a row_type value like: "fields": [ { "name": "UserId", "type": { "code": "INT64" } }, { "name": "UserName", "type": { "code": "STRING" } }, ]

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

hasRowType

clearRowType

setRowType

Indicates the field names and types for the rows in the result set. For example, a SQL query like "SELECT UserId, UserName FROM Users" could return a row_type value like: "fields": [ { "name": "UserId", "type": { "code": "INT64" } }, { "name": "UserName", "type": { "code": "STRING" } }, ]

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

getTransaction

If the read or SQL query began a transaction as a side-effect, the information about the new transaction is yielded here.

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

hasTransaction

clearTransaction

setTransaction

If the read or SQL query began a transaction as a side-effect, the information about the new transaction is yielded here.

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

getUndeclaredParameters

A SQL query can be parameterized. In PLAN mode, these parameters can be undeclared. This indicates the field names and types for those undeclared parameters in the SQL query. For example, a SQL query like "SELECT * FROM Users where UserId = @userId and UserName = @userName " could return a undeclared_parameters value like: "fields": [ { "name": "UserId", "type": { "code": "INT64" } }, { "name": "UserName", "type": { "code": "STRING" } }, ]

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

hasUndeclaredParameters

clearUndeclaredParameters

setUndeclaredParameters

A SQL query can be parameterized. In PLAN mode, these parameters can be undeclared. This indicates the field names and types for those undeclared parameters in the SQL query. For example, a SQL query like "SELECT * FROM Users where UserId = @userId and UserName = @userName " could return a undeclared_parameters value like: "fields": [ { "name": "UserId", "type": { "code": "INT64" } }, { "name": "UserName", "type": { "code": "STRING" } }, ]

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