Cloud Spanner Client - Class Database (2.0.0-RC1)

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

Represents a Cloud Spanner Database.

Example:

use Google\Cloud\Spanner\SpannerClient;

$spanner = new SpannerClient(['projectId' => 'my-project']);

$database = $spanner->connect('my-instance', 'my-database');

// Databases can also be connected to via an Instance.
use Google\Cloud\Spanner\SpannerClient;

$spanner = new SpannerClient(['projectId' => 'my-project']);

$instance = $spanner->instance('my-instance');
$database = $instance->database('my-database');

Namespace

Google \ Cloud \ Spanner

Methods

__construct

Create an object representing a Database.

Parameters
Name Description
spannerClient V1\Client\SpannerClient

The Spanner client used to interact with the API.
databaseAdminClient Admin\Database\V1\Client\DatabaseAdminClient

The database admin client used to interact with the API.
serializer Serializer

The serializer instance to encode/decode messages.
instance Instance

The instance in which the database exists.
projectId string

The project ID.
name string

The database name or ID.
session Session\SessionCache

the current Session
options array

[Optional] { Database options.

@type bool $routeToLeader Enable/disable Leader Aware Routing.
    **Defaults to** `true` (enabled).
@type array $defaultQueryOptions
@type bool $returnInt64AsObject If true, 64 bit integers will
    be returned as a <xref uid="\Google\Cloud\Core\Int64">Google\Cloud\Core\Int64</xref> object for 32 bit
    platform compatibility. **Defaults to** false.
@type string $databaseRole The user created database role which
    creates the session.
@type array $database The database info.
@type int $isolationLevel The level of Isolation for the transactions executed by this Client's instance.
      **Defaults to** IsolationLevel::ISOLATION_LEVEL_UNSPECIFIED

}

state

Return the database state.

When databases are created or restored, they may take some time before they are ready for use. This method allows for checking whether a database is ready. Note that this value is cached within the class instance, so if you are polling it, first call Database::reload() to refresh the cached value.

Example:

if ($database->state() === Database::STATE_READY) {
    echo 'Database is ready!';
}
Parameter
Name Description
options array

[optional] Configuration options.
Returns
Type Description
int|null

backups

List completed and pending backups belonging to this database.

Example:

$backups = $database->backups();
Parameters
Name Description
options array

Configuration options.
↳ filter string

The standard list filter. NOTE: This method always sets the database filter as a name of this database. User may provide additional filter expressions which would be appended in the form of "(database:
↳ pageSize int

Maximum number of results to return per request.
↳ resultLimit int

Limit the number of results returned in total. Defaults to 0 (return all results).
↳ pageToken string

A previously-returned page token used to resume the loading of results from a specific point.
Returns
Type Description
Google\Cloud\Core\Iterator\ItemIterator<Backup>

createBackup

Create a backup for this database.

Example:

$operation = $database->createBackup('my-backup', new \DateTime('+7 hours'));
Parameters
Name Description
name string

The backup name.
expireTime DateTimeInterface

​The expiration time of the backup, with microseconds granularity that must be at least 6 hours and at most 366 days. Once the expireTime has passed, the backup is eligible to be automatically deleted by Cloud Spanner.
options array

[optional] Configuration options.
Returns
Type Description
Google\Cloud\Core\LongRunning\LongRunningOperation<Backup>

name

Return the fully-qualified database name.

Example:

$name = $database->name();
Returns
Type Description
string

info

See also:

Parameter
Name Description
options array

[optional] Configuration options.
Returns
Type Description
array

reload

See also:

Parameter
Name Description
options array

[optional] Configuration options.
Returns
Type Description
array

exists

Check if the database exists.

This method sends a service request.

NOTE: Requires https://www.googleapis.com/auth/spanner.admin scope.

Example:

if ($database->exists()) {
    echo 'Database exists!';
}
Parameter
Name Description
options array

[optional] Configuration options.
Returns
Type Description
bool

create

See also:

Parameters
Name Description
options array

Configuration Options
↳ statements string[]

Additional DDL statements.
↳ protoDescriptors Google\Protobuf\FileDescriptorSet|string

The file descriptor set object to be used in the update, or alternatively, an absolute path to the generated file descriptor set. The descriptor set is only used during DDL statements, such as CREATE PROTO BUNDLE.
Returns
Type Description
Google\Cloud\Core\LongRunning\LongRunningOperation<Database>

restore

Restores to this database from a backup.

NOTE: A restore operation can only be made to a non-existing database.

Example:

$operation = $database->restore($backup);
Parameters
Name Description
backup Backup|string

The backup to restore, given as a Backup instance or a string of the form projects/<project>/instances/<instance>/backups/<backup>.
options array

[optional] Configuration options.
Returns
Type Description
Google\Cloud\Core\LongRunning\LongRunningOperation<Database>

updateDatabase

See also:

Parameters
Name Description
options array

Configuration Options
↳ enableDropProtection bool

If true, delete operations for Database and Instance will be blocked. Defaults to false.
Returns
Type Description
Google\Cloud\Core\LongRunning\LongRunningOperation<Database>

updateDdl

See also:

Parameters
Name Description
statement string

A DDL statements to run against a database.
options array

[optional] Configuration options.
Returns
Type Description
Google\Cloud\Core\LongRunning\LongRunningOperation<void>

updateDdlBatch

See also:

Parameters
Name Description
statements string[]

A list of DDL statements to run against a database.
options array

Configuration options. Supports setting the fields of Admin\Database\V1\UpdateDatabaseDdlRequest and Google\ApiCore\Options\CallOptions.
Returns
Type Description
Google\Cloud\Core\LongRunning\LongRunningOperation<void>

drop

See also:

Parameter
Name Description
options array

Configuration options. Supports setting the fields of Admin\Database\V1\DropDatabaseRequest and Google\ApiCore\Options\CallOptions.
Returns
Type Description
void

ddl

See also:

Parameter
Name Description
options array

Configuration options. Supports setting the fields of Admin\Database\V1\GetDatabaseDdlRequest and Google\ApiCore\Options\CallOptions.
Returns
Type Description
array

iam

Manage the database IAM policy

Example:

$iam = $database->iam();
Returns
Type Description
Google\Cloud\Core\Iam\IamManager

snapshot

See also:

Parameters
Name Description
options array

Configuration Options

See [ReadOnly](https://cloud.google.com/spanner/reference/rpc/google.spanner.v1#google.spanner.v1.TransactionOptions.ReadOnly)
for detailed description of available options.

Please note that only one of `$strong`, `$readTimestamp` or
`$exactStaleness` may be set in a request.
↳ returnReadTimestamp bool

If true, the Cloud Spanner-selected read timestamp is included in the Transaction message that describes the transaction.
↳ strong bool

Read at a timestamp where all previously committed transactions are visible.
↳ readTimestamp Timestamp

Executes all reads at the given timestamp.
↳ exactStaleness Duration

Represents a number of seconds. Executes all reads at a timestamp that is $exactStaleness old.
↳ minReadTimestamp Timestamp

Executes all reads at a timestamp >= min_read_timestamp. Only available when $options.singleUse is true.
↳ maxStaleness Duration

Read data at a timestamp >= NOW - max_staleness seconds. Guarantees that all writes that have committed more than the specified number of seconds ago are visible. Only available when $options.singleUse is true.
↳ singleUse bool

If true, a Transaction ID will not be allocated up front. Instead, the transaction will be considered "single-use", and may be used for only a single operation. Defaults to false.
↳ sessionOptions array

Session configuration and request options. Session labels may be applied using the labels key.
Returns
Type Description
TransactionalReadInterface

transaction

See also:

Parameters
Name Description
options array

Configuration Options.
↳ singleUse bool

If true, a Transaction ID will not be allocated up front. Instead, the transaction will be considered "single-use", and may be used for only a single operation. Defaults to false.
↳ sessionOptions array

Session configuration and request options. Session labels may be applied using the labels key.
↳ tag string

A transaction tag. Requests made using this transaction will use this as the transaction tag.
Returns
Type Description
Transaction

runTransaction

See also:

Parameters
Name Description
operation callable

The operations to run in the transaction. Signature:* function (Transaction $transaction).
options array

Configuration Options
↳ retrySettings RetrySettings|array

{ Retry configuration options. Currently, only the maxRetries option is supported.
↳ maxRetries int

The maximum number of retry attempts before the operation fails. Defaults to 10. }
↳ singleUse bool

If true, a Transaction ID will not be allocated up front. Instead, the transaction will be considered "single-use", and may be used for only a single operation. Note that in a single-use transaction, only a single operation may be executed, and rollback is not available. Defaults to false.
↳ sessionOptions array

Session configuration and request options. Session labels may be applied using the labels key.
↳ tag string

A transaction tag. Requests made using this transaction will use this as the transaction tag.
↳ transactionOptions array

Options for the transaction. V1\TransactionOptions for available options
Returns
Type Description
mixed The return value of `$operation`.

insert

See also:

Parameters
Name Description
table string

The table to mutate.
data array

The row data to insert.
options array

Configuration options.
↳ requestOptions array

Request options. For more information on available options, please see RequestOptions. Please note, if using the priority setting you may utilize the constants available on V1\RequestOptions\Priority to set a value. Please note, the transactionTag setting will be ignored as it is not supported for single-use transactions.
Returns
Type Description
Timestamp The commit Timestamp.

insertBatch

See also:

Parameters
Name Description
table string

The table to mutate.
dataSet array

The row data to insert.
options array

Configuration options.
↳ requestOptions array

Request options. For more information on available options, please see RequestOptions. Please note, if using the priority setting you may utilize the constants available on V1\RequestOptions\Priority to set a value. Please note, the transactionTag setting will be ignored as it is not supported for single-use transactions.
Returns
Type Description
Timestamp The commit Timestamp.

update

See also:

Parameters
Name Description
table string

The table to mutate.
data array

The row data to update.
options array

Configuration options.
↳ requestOptions array

Request options. For more information on available options, please see RequestOptions. Please note, if using the priority setting you may utilize the constants available on V1\RequestOptions\Priority to set a value. Please note, the transactionTag setting will be ignored as it is not supported for single-use transactions.
Returns
Type Description
Timestamp The commit Timestamp.

updateBatch

See also:

Parameters
Name Description
table string

The table to mutate.
dataSet array

The row data to update.
options array

Configuration options.
↳ requestOptions array

Request options. For more information on available options, please see RequestOptions. Please note, if using the priority setting you may utilize the constants available on V1\RequestOptions\Priority to set a value. Please note, the transactionTag setting will be ignored as it is not supported for single-use transactions.
Returns
Type Description
Timestamp The commit Timestamp.

insertOrUpdate

See also:

Parameters
Name Description
table string

The table to mutate.
data array

The row data to insert or update.
options array

Configuration options.
↳ requestOptions array

Request options. For more information on available options, please see RequestOptions. Please note, if using the priority setting you may utilize the constants available on V1\RequestOptions\Priority to set a value. Please note, the transactionTag setting will be ignored as it is not supported for single-use transactions.
Returns
Type Description
Timestamp The commit Timestamp.

insertOrUpdateBatch

See also:

Parameters
Name Description
table string

The table to mutate.
dataSet array

The row data to insert or update.
options array

Configuration options.
↳ requestOptions array

Request options. For more information on available options, please see RequestOptions. Please note, if using the priority setting you may utilize the constants available on V1\RequestOptions\Priority to set a value. Please note, the transactionTag setting will be ignored as it is not supported for single-use transactions.
Returns
Type Description
Timestamp The commit Timestamp.

replace

See also:

Parameters
Name Description
table string

The table to mutate.
data array

The row data to replace.
options array

Configuration options.
↳ requestOptions array

Request options. For more information on available options, please see RequestOptions. Please note, if using the priority setting you may utilize the constants available on V1\RequestOptions\Priority to set a value. Please note, the transactionTag setting will be ignored as it is not supported for single-use transactions.
Returns
Type Description
Timestamp The commit Timestamp.

replaceBatch

See also:

Parameters
Name Description
table string

The table to mutate.
dataSet array

The row data to replace.
options array

Configuration options.
↳ requestOptions array

Request options. For more information on available options, please see RequestOptions. Please note, if using the priority setting you may utilize the constants available on V1\RequestOptions\Priority to set a value. Please note, the transactionTag setting will be ignored as it is not supported for single-use transactions.
Returns
Type Description
Timestamp The commit Timestamp.

delete

See also:

Parameters
Name Description
table string

The table to mutate.
keySet KeySet

The KeySet to identify rows to delete.
options array

Configuration options.
↳ requestOptions array

Request options. For more information on available options, please see RequestOptions. Please note, if using the priority setting you may utilize the constants available on V1\RequestOptions\Priority to set a value. Please note, the transactionTag setting will be ignored as it is not supported for single-use transactions.
Returns
Type Description
Timestamp The commit Timestamp.

execute

See also:

Parameters
Name Description
sql string

The query string to execute.
options array

Configuration Options. See V1\TransactionOptions\PBReadOnly for detailed description of available transaction options. Please note that only one of $strong, $minReadTimestamp, $maxStaleness, $readTimestamp or $exactStaleness may be set in a request.
↳ parameters array

A key/value array of Query Parameters, where the key is represented in the query string prefixed by a @ symbol.
↳ types array

A key/value array of Query Parameter types. Generally, Google Cloud PHP can infer types. Explicit type declarations are required in the case of struct parameters, or when a null value exists as a parameter. Accepted values for primitive types are defined as constants on Database, and are as follows: Database::TYPE_BOOL, Database::TYPE_INT64, Database::TYPE_FLOAT64, Database::TYPE_TIMESTAMP, Database::TYPE_DATE, Database::TYPE_STRING, Database::TYPE_BYTES. If the value is an array, use ArrayType to declare the array parameter types. Likewise, for structs, use StructType.
↳ returnReadTimestamp bool

If true, the Cloud Spanner-selected read timestamp is included in the Transaction message that describes the transaction.
↳ strong bool

Read at a timestamp where all previously committed transactions are visible.
↳ minReadTimestamp Timestamp

Execute reads at a timestamp >= the given timestamp. Only available in single-use transactions.
↳ maxStaleness Duration

Read data at a timestamp >= NOW - the given timestamp. Only available in single-use transactions.
↳ readTimestamp Timestamp

Executes all reads at the given timestamp.
↳ exactStaleness Duration

Represents a number of seconds. Executes all reads at a timestamp that is $exactStaleness old.
↳ begin bool|array

If true, will begin a new transaction. If a read/write transaction is desired, set the value of $transactionType. If a transaction or snapshot is created, it will be returned as $result->transaction() or $result->snapshot(). If $begin is an array, see TransactionOptions. Defaults to false.
↳ transactionType string

One of Database::CONTEXT_READ or Database::CONTEXT_READWRITE. If read/write is chosen, any snapshot options will be disregarded. If $begin is false, transaction type MUST be Database::CONTEXT_READ. Defaults to Database::CONTEXT_READ.
↳ sessionOptions array

Session configuration and request options. Session labels may be applied using the labels key.
↳ queryOptions array

Query optimizer configuration.

Properties
Name Description
optimizerVersion string

An option to control the selection of optimizer version. This parameter allows individual queries to pick different query optimizer versions. Specifying "latest" as a value instructs Cloud Spanner to use the latest supported query optimizer version. If not specified, Cloud Spanner uses optimizer version set at the client level options or set by the SPANNER_OPTIMIZER_VERSION environment variable. Any other positive integer (from the list of supported optimizer versions) overrides the default optimizer version for query execution. Executing a SQL statement with an invalid optimizer version will fail with a syntax error (INVALID_ARGUMENT) status.
↳ requestOptions array

Request options. For more information on available options, please see RequestOptions. Please note, if using the priority setting you may utilize the constants available on V1\RequestOptions\Priority to set a value. Please note, the transactionTag setting will be ignored as it is not supported for read-only transactions.
↳ directedReadOptions array

Directed read options. V1\DirectedReadOptions If using the replicaSelection::type setting, utilize the constants available in V1\DirectedReadOptions\ReplicaSelection\Type to set a value.
Returns
Type Description
Result

mutationGroup

Create a new MutationGroup object.

Returns
Type Description
MutationGroup

batchWrite

Batches the supplied mutation groups in a collection of efficient transactions. All mutations in a group are committed atomically. However, mutations across groups can be committed non-atomically in an unspecified order and thus, they must be independent of each other. Partial failure is possible, i.e., some groups may have been committed successfully, while some may have failed. The results of individual batches are streamed into the response as the batches are applied.

BatchWrite requests are not replay protected, meaning that each mutation group may be applied more than once. Replays of non-idempotent mutations may have undesirable effects. For example, replays of an insert mutation may produce an already exists error or if you use generated or commit timestamp-based keys, it may result in additional rows being added to the mutation's table. We recommend structuring your mutation groups to be idempotent to avoid this issue.

Sample code:
Parameters
Name Description
mutationGroups array<MutationGroup>

Required. The groups of mutations to be applied.
options array

Optional.
↳ requestOptions array

Common options for this request.
↳ excludeTxnFromChangeStreams bool

Optional. When exclude_txn_from_change_streams is set to true: * * Mutations from all transactions in this batch write operation will not be recorded in change streams with DDL option allow_txn_exclusion=true that are tracking columns modified by these transactions. * * Mutations from all transactions in this batch write operation will be recorded in change streams with DDL option allow_txn_exclusion=false or not set that are tracking columns modified by these transactions. When exclude_txn_from_change_streams is set to false or not set, mutations from all transactions in this batch write operation will be recorded in all change streams that are tracking columns modified by these transactions.
Returns
Type Description
Generator {@see \Google\Cloud\Spanner\V1\BatchWriteResponse}

executePartitionedUpdate

See also:

Parameters
Name Description
statement string

The DML statement to execute.
options array

Configuration Options.
↳ parameters array

A key/value array of Query Parameters, where the key is represented in the statement prefixed by a @ symbol.
↳ types array

A key/value array of Query Parameter types. Generally, Google Cloud PHP can infer types. Explicit type declarations are required in the case of struct parameters, or when a null value exists as a parameter. Accepted values for primitive types are defined as constants on Database, and are as follows: Database::TYPE_BOOL, Database::TYPE_INT64, Database::TYPE_FLOAT64, Database::TYPE_TIMESTAMP, Database::TYPE_DATE, Database::TYPE_STRING, Database::TYPE_BYTES. If the value is an array, use ArrayType to declare the array parameter types. Likewise, for structs, use StructType.
↳ requestOptions array

Request options. For more information on available options, please see RequestOptions. Please note, if using the priority setting you may utilize the constants available on V1\RequestOptions\Priority to set a value. Please note, the transactionTag setting will be ignored as it is not supported for partitioned DML.
↳ transactionOptions array

Transaction options. V1\TransactionOptions} </xref
Returns
Type Description
int The number of rows modified.

read

See also:

Parameters
Name Description
table string

The table name.
keySet KeySet

The KeySet to select rows.
columns array

A list of column names to return.
options array

Configuration Options.

See [TransactionOptions](https://cloud.google.com/spanner/docs/reference/rpc/google.spanner.v1#google.spanner.v1.TransactionOptions)
for detailed description of available transaction options.

Please note that only one of `$strong`, `$minReadTimestamp`,
`$maxStaleness`, `$readTimestamp` or `$exactStaleness` may be set in
a request.
↳ index string

The name of an index on the table.
↳ limit int

The number of results to return.
↳ returnReadTimestamp bool

If true, the Cloud Spanner-selected read timestamp is included in the Transaction message that describes the transaction.
↳ strong bool

Read at a timestamp where all previously committed transactions are visible.
↳ minReadTimestamp Timestamp

Execute reads at a timestamp >= the given timestamp. Only available in single-use transactions.
↳ maxStaleness Duration

Read data at a timestamp >= NOW - the given timestamp. Only available in single-use transactions.
↳ readTimestamp Timestamp

Executes all reads at the given timestamp.
↳ exactStaleness Duration

Represents a number of seconds. Executes all reads at a timestamp that is $exactStaleness old.
↳ begin bool

If true, will begin a new transaction. If a read/write transaction is desired, set the value of $transactionType. If a transaction or snapshot is created, it will be returned as $result->transaction() or $result->snapshot(). Defaults to false.
↳ transactionType string

One of Database::CONTEXT_READ or Database::CONTEXT_READWRITE. If read/write is chosen, any snapshot options will be disregarded. If $begin is false, transaction type MUST be Database::CONTEXT_READ. Defaults to Database::CONTEXT_READ.
↳ sessionOptions array

Session configuration and request options. Session labels may be applied using the labels key.
↳ requestOptions array

Request options. For more information on available options, please see RequestOptions. Please note, if using the priority setting you may utilize the constants available on V1\RequestOptions\Priority to set a value. Please note, the transactionTag setting will be ignored as it is not supported for read-only transactions.
↳ directedReadOptions array

Directed read options. V1\DirectedReadOptions If using the replicaSelection::type setting, utilize the constants available in V1\DirectedReadOptions\ReplicaSelection\Type to set a value.
↳ orderBy int

Set the OrderBy option for the ReadRequest. V1\ReadRequest and V1\ReadRequest\OrderBy for more information and available options.
↳ lockHint int

Set the LockHint option for the ReadRequest. Only available when transactionType is read/write. V1\ReadRequest and V1\ReadRequest\LockHint for more information and available options.
Returns
Type Description
Result

identity

Retrieves the database's identity.

Returns
Type Description
array

backupOperations

Lists backup operations.

Parameters
Name Description
options array

Configuration options.
↳ pageSize int

The maximum number of resources contained in the underlying API response. The API may return fewer values in a page, even if there are additional values to be retrieved.
↳ resultLimit int

Limit the number of results returned in total. Defaults to 0 (return all results).
↳ pageToken string

A page token is used to specify a page of values to be returned. If no page token is specified (the default), the first page of values will be returned. Any page token used here must have been generated by a previous call to the API.
Returns
Type Description
Google\Cloud\Core\Iterator\ItemIterator<Google\Cloud\Core\LongRunning\LongRunningOperation>

createDatabaseFromBackup

Create a database from a backup.

Parameters
Name Description
name string

The database name.
backup Backup|string

The backup to restore, given as a Backup instance or a string of the form projects/<project>/instances/<instance>/backups/<backup>.
options array

[optional] Configuration options.
Returns
Type Description
Google\Cloud\Core\LongRunning\LongRunningOperation

databaseOperations

Lists database operations.

Parameters
Name Description
options array

Configuration options.
↳ pageSize int

The maximum number of resources contained in the underlying API response. The API may return fewer values in a page, even if there are additional values to be retrieved.
↳ resultLimit int

Limit the number of results returned in total. Defaults to 0 (return all results).
↳ pageToken string

A page token is used to specify a page of values to be returned. If no page token is specified (the default), the first page of values will be returned. Any page token used here must have been generated by a previous call to the API.
Returns
Type Description
Google\Cloud\Core\Iterator\ItemIterator<Google\Cloud\Core\LongRunning\LongRunningOperation>

resumeOperation

Resume a Long Running Operation

Example:

$operation = $database->resumeOperation($operationName);
Parameters
Name Description
operationName string

The Long Running Operation name.
options array
Returns
Type Description
Google\Cloud\Core\LongRunning\LongRunningOperation

longRunningOperations

List long running operations.

Example:

$operations = $database->longRunningOperations();
Parameters
Name Description
options array

Configuration Options.
↳ name string

The name of the operation collection.
↳ filter string

The standard list filter.
↳ pageSize int

Maximum number of results to return per request.
↳ resultLimit int

Limit the number of results returned in total. Defaults to 0 (return all results).
↳ pageToken string

A previously-returned page token used to resume the loading of results from a specific point.
Returns
Type Description
Google\Cloud\Core\Iterator\ItemIterator<Google\Cloud\Core\LongRunning\LongRunningOperation>

session

Get the current multiplex session or create a new one.

Returns
Type Description
Session\SessionCache

__debugInfo

Represent the class in a more readable and digestable fashion.

Constants

CONTEXT_READ

Value: 'r'

CONTEXT_READWRITE

Value: 'rw'

STATE_CREATING

Value: \Google\Cloud\Spanner\Admin\Database\V1\Database\State::CREATING

STATE_READY

Value: \Google\Cloud\Spanner\Admin\Database\V1\Database\State::READY

STATE_READY_OPTIMIZING

Value: \Google\Cloud\Spanner\Admin\Database\V1\Database\State::READY_OPTIMIZING

MAX_RETRIES

Value: 10

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_PROTO

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

TYPE_PG_NUMERIC

Value: 'pgNumeric'

TYPE_PG_JSONB

Value: 'pgJsonb'

TYPE_JSON

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

TYPE_PG_OID

Value: 'pgOid'

TYPE_INTERVAL

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