Cloud Spanner Client - Class Database (1.65.0)

Version 1.65.0

• 1.89.0 (latest)
• 1.88.0
• 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 Database.

Represents a Cloud Spanner Database.

Example:

use Google\Cloud\Spanner\SpannerClient;

$spanner = new SpannerClient();

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

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

$spanner = new SpannerClient();

$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
connection	Google\Cloud\Spanner\Connection\ConnectionInterface The connection to the Cloud Spanner Admin API. This object is created by SpannerClient, and should not be instantiated outside of this client.
instance	Google\Cloud\Spanner\Instance The instance in which the database exists.
lroConnection	Google\Cloud\Core\LongRunning\LongRunningConnectionInterface An implementation mapping to methods which handle LRO resolution in the service.
lroCallables	array
projectId	string The project ID.
name	string The database name or ID.
sessionPool	Google\Cloud\Spanner\Session\SessionPoolInterface [optional] The session pool implementation.
returnInt64AsObject	bool [optional If true, 64 bit integers will be returned as a Google\Cloud\Core\Int64 object for 32 bit platform compatibility. Defaults to false.
info	array
databaseRole	string The user created database role which creates the session.

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 Google\Cloud\Spanner\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<\google\cloud\spanner\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<\google\cloud\spanner\backup>

name

Return the fully-qualified database name.

Example:

$name = $database->name();

Returns
Type	Description
string

info

See also:

• Database

Parameter
Name	Description
options	array [optional] Configuration options.

Returns
Type	Description
array

reload

See also:

• Database

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:

• CreateDatabaseRequest

Parameters
Name	Description
options	array Configuration Options
↳ statements	string[] Additional DDL statements.

Returns
Type	Description
Google\Cloud\Core\LongRunning\LongRunningOperation<\google\cloud\spanner\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	Google\Cloud\Spanner\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<\google\cloud\spanner\database>

updateDatabase

See also:

• UpdateDatabaseRequest

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<\google\cloud\spanner\database>

updateDdl

See also:

• Data Definition Language
• UpdateDDLRequest

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

updateDdlBatch

See also:

• Data Definition Language
• UpdateDDLRequest

Parameters
Name	Description
statements	string[] A list of DDL statements to run against a database.
options	array [optional] Configuration options.

Returns
Type	Description
Google\Cloud\Core\LongRunning\LongRunningOperation

drop

See also:

• DropDatabaseRequest

Parameter
Name	Description
options	array [optional] Configuration options.

Returns
Type	Description
void

ddl

See also:

• GetDatabaseDdlRequest

Parameter
Name	Description
options	array [optional] Configuration options.

Returns
Type	Description
array

iam

Manage the database IAM policy

Example:

$iam = $database->iam();

Returns
Type	Description
Google\Cloud\Core\Iam\Iam

snapshot

See also:

• BeginTransactionRequest
• Transactions

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
Google\Cloud\Spanner\Snapshot

transaction

See also:

• BeginTransactionRequest
• Transactions

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
Google\Cloud\Spanner\Transaction

runTransaction

See also:

• BeginTransactionRequest
• Transactions

Parameters
Name	Description
operation	callable The operations to run in the transaction. Signature: function (Transaction $transaction).
options	array Configuration Options
↳ maxRetries	int The number of times to attempt to apply the operation before failing. **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.

Returns
Type	Description
mixed	The return value of `$operation`.

insert

See also:

• CommitRequest

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 the upstream documentation. Please note, if using the priority setting you may utilize the constants available on Google\Cloud\Spanner\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
Google\Cloud\Spanner\Timestamp	The commit Timestamp.

insertBatch

See also:

• CommitRequest

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 the upstream documentation. Please note, if using the priority setting you may utilize the constants available on Google\Cloud\Spanner\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
Google\Cloud\Spanner\Timestamp	The commit Timestamp.

update

See also:

• CommitRequest

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 the upstream documentation. Please note, if using the priority setting you may utilize the constants available on Google\Cloud\Spanner\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
Google\Cloud\Spanner\Timestamp	The commit Timestamp.

updateBatch

See also:

• CommitRequest

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 the upstream documentation. Please note, if using the priority setting you may utilize the constants available on Google\Cloud\Spanner\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
Google\Cloud\Spanner\Timestamp	The commit Timestamp.

insertOrUpdate

See also:

• CommitRequest

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 the upstream documentation. Please note, if using the priority setting you may utilize the constants available on Google\Cloud\Spanner\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
Google\Cloud\Spanner\Timestamp	The commit Timestamp.

insertOrUpdateBatch

See also:

• CommitRequest

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 the upstream documentation. Please note, if using the priority setting you may utilize the constants available on Google\Cloud\Spanner\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
Google\Cloud\Spanner\Timestamp	The commit Timestamp.

replace

See also:

• CommitRequest

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 the upstream documentation. Please note, if using the priority setting you may utilize the constants available on Google\Cloud\Spanner\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
Google\Cloud\Spanner\Timestamp	The commit Timestamp.

replaceBatch

See also:

• CommitRequest

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 the upstream documentation. Please note, if using the priority setting you may utilize the constants available on Google\Cloud\Spanner\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
Google\Cloud\Spanner\Timestamp	The commit Timestamp.

delete

See also:

• CommitRequest

Parameters
Name	Description
table	string The table to mutate.
keySet	Google\Cloud\Spanner\KeySet The KeySet to identify rows to delete.
options	array Configuration options.
↳ requestOptions	array Request options. For more information on available options, please see the upstream documentation. Please note, if using the priority setting you may utilize the constants available on Google\Cloud\Spanner\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
Google\Cloud\Spanner\Timestamp	The commit Timestamp.

execute

See also:

• ExecuteSqlRequest

Parameters
Name	Description
sql	string The query string to execute.
options	array Configuration Options. See 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.
↳ 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 Google\Cloud\Spanner\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 Google\Cloud\Spanner\ArrayType to declare the array parameter types. Likewise, for structs, use Google\Cloud\Spanner\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 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 SessionPoolInterface::CONTEXT_READ or SessionPoolInterface::CONTEXT_READWRITE. If read/write is chosen, any snapshot options will be disregarded. If $begin is false, transaction type MUST be SessionPoolInterface::CONTEXT_READ. Defaults to SessionPoolInterface::CONTEXT_READ.
↳ sessionOptions	array Session configuration and request options. Session labels may be applied using the labels key.
↳ queryOptions	array Query optimizer configuration.
↳ queryOptions	string .optimizerVersion 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 the upstream documentation. Please note, if using the priority setting you may utilize the constants available on Google\Cloud\Spanner\V1\RequestOptions\Priority to set a value. Please note, the transactionTag setting will be ignored as it is not supported for read-only transactions.

Returns
Type	Description
Google\Cloud\Spanner\Result

executePartitionedUpdate

See also:

• TransactionOptions
• ExecuteSqlRequest

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 Google\Cloud\Spanner\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 Google\Cloud\Spanner\ArrayType to declare the array parameter types. Likewise, for structs, use Google\Cloud\Spanner\StructType.
↳ requestOptions	array Request options. For more information on available options, please see the upstream documentation. Please note, if using the priority setting you may utilize the constants available on Google\Cloud\Spanner\V1\RequestOptions\Priority to set a value. Please note, the transactionTag setting will be ignored as it is not supported for partitioned DML.

Returns
Type	Description
int	The number of rows modified.

read

See also:

• ReadRequest

Parameters
Name	Description
table	string The table name.
keySet	Google\Cloud\Spanner\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 SessionPoolInterface::CONTEXT_READ or SessionPoolInterface::CONTEXT_READWRITE. If read/write is chosen, any snapshot options will be disregarded. If $begin is false, transaction type MUST be SessionPoolInterface::CONTEXT_READ. Defaults to SessionPoolInterface::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 the upstream documentation. Please note, if using the priority setting you may utilize the constants available on Google\Cloud\Spanner\V1\RequestOptions\Priority to set a value. Please note, the transactionTag setting will be ignored as it is not supported for read-only transactions.

Returns
Type	Description
Google\Cloud\Spanner\Result

sessionPool

Get the underlying session pool implementation.

Example:

$pool = $database->sessionPool();

Returns
Type	Description
Google\Cloud\Spanner\Session\SessionPoolInterface|null

close

Closes the database connection by returning the active session back to the session pool queue or by deleting the session if there is no pool associated.

It is highly important to ensure this is called as it is not always safe to rely soley on Google\Cloud\Spanner\Database::__destruct().

Example:

$database->close();

__destruct

Closes the database connection.

createSession

Create a new session.

Sessions are handled behind the scenes and this method does not need to be called directly.

Parameter
Name	Description
options	array [optional] Configuration options.

Returns
Type	Description
Google\Cloud\Spanner\Session\Session

session

Lazily instantiates a session. There are no network requests made at this point. To see the operations that can be performed on a session please see Google\Cloud\Spanner\Session\Session.

Sessions are handled behind the scenes and this method does not need to be called directly.

Parameter
Name	Description
sessionName	string The session's name.

Returns
Type	Description
Google\Cloud\Spanner\Session\Session

identity

Retrieves the database's identity.

Returns
Type	Description
array

connection

Returns the underlying connection.

Returns
Type	Description
Google\Cloud\Spanner\Connection\ConnectionInterface

__debugInfo

Represent the class in a more readable and digestable fashion.

resumeOperation

{ Resume a Long Running Operation

Example:
```php
$operation = $database->resumeOperation($operationName);
```

@param string $operationName The Long Running Operation name.
@param array $info [optional] The operation data.
@return LongRunningOperation

}

Returns
Type	Description
void

longRunningOperations

{ List long running operations.

Example:
```php
$operations = $database->longRunningOperations();
```

@param array $options [optional] {
    Configuration Options.

    @type string $name The name of the operation collection.
    @type string $filter The standard list filter.
    @type int $pageSize Maximum number of results to return per
          request.
    @type int $resultLimit Limit the number of results returned in total.
          **Defaults to** `0` (return all results).
    @type string $pageToken A previously-returned page token used to
          resume the loading of results from a specific point.
}
@return ItemIterator<InstanceConfiguration>

}

Returns
Type	Description
void

Constants

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_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_PG_NUMERIC

Value: 'pgNumeric'

TYPE_PG_JSONB

Value: 'pgJsonb'

TYPE_JSON

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