Cloud Spanner Client - Class ValueMapper (1.60.0)

Version 1.60.0

• 1.88.0 (latest)
• 1.87.0
• 1.86.0
• 1.85.0
• 1.84.0
• 1.83.0
• 1.82.0
• 1.81.0
• 1.80.0
• 1.79.0
• 1.78.0
• 1.77.0
• 1.76.1
• 1.68.0
• 1.67.0
• 1.66.0
• 1.65.0
• 1.64.0
• 1.63.2
• 1.62.1
• 1.61.0
• 1.60.0
• 1.59.0
• 1.58.4
• 1.57.0
• 1.56.0
• 1.55.0
• 1.54.2

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

Manage value mappings between Google Cloud PHP and Cloud Spanner

Methods

__construct

Parameter
Name	Description
returnInt64AsObject	bool

formatParamsForExecuteSql

Accepts an array of key/value pairs, where the key is a SQL parameter name and the value is the value interpolated by the server, and returns an array of parameters and inferred parameter types.

Parameters
Name	Description
parameters	array The key/value parameters.
types	array The types of values.

Returns
Type	Description
array	An associative array containing params and paramTypes.

encodeValuesAsSimpleType

Accepts a list of values and encodes the value into a format accepted by the Spanner API.

Parameters
Name	Description
values	array The list of values
allowMixedArrayType	bool If true, array values may be of mixed type. Defaults to false.

Returns
Type	Description
array	The encoded values

decodeValues

Accepts a list of columns (with name and type) and a row from read or executeSql and decodes each value to its corresponding PHP type.

Parameters
Name	Description
columns	array The list of columns.
row	array The row data.
format	string The format in which to return the rows.

Returns
Type	Description
array	The decoded row data.

Constants

TYPE_BOOL

Value: \Google\Cloud\Spanner\V1\TypeCode::BOOL

TYPE_INT64

Value: \Google\Cloud\Spanner\V1\TypeCode::INT64

TYPE_FLOAT64

Value: \Google\Cloud\Spanner\V1\TypeCode::FLOAT64

TYPE_TIMESTAMP

Value: \Google\Cloud\Spanner\V1\TypeCode::TIMESTAMP

TYPE_DATE

Value: \Google\Cloud\Spanner\V1\TypeCode::DATE

TYPE_STRING

Value: \Google\Cloud\Spanner\V1\TypeCode::STRING

TYPE_BYTES

Value: \Google\Cloud\Spanner\V1\TypeCode::BYTES

TYPE_ARRAY

Value: \Google\Cloud\Spanner\V1\TypeCode::PBARRAY

TYPE_STRUCT

Value: \Google\Cloud\Spanner\V1\TypeCode::STRUCT

TYPE_NUMERIC

Value: \Google\Cloud\Spanner\V1\TypeCode::NUMERIC

TYPE_JSON

Value: \Google\Cloud\Spanner\V1\TypeCode::JSON

TYPE_PG_NUMERIC

Value: 'pgNumeric'

TYPE_PG_JSONB

Value: 'pgJsonb'