Cloud Spanner Client - Class ValueMapper (1.83.0)

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

Manage value mappings between Google Cloud PHP and Cloud Spanner

Namespace

Google \ 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_FLOAT32

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

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'

TYPE_PG_OID

Value: 'pgOid'