Module database (3.55.0)

User-friendly container for Cloud Spanner Database.

Classes

BatchCheckout

BatchCheckout(database,request_options=None,max_commit_delay=None,exclude_txn_from_change_streams=False,isolation_level=IsolationLevel.ISOLATION_LEVEL_UNSPECIFIED,**kw)

Context manager for using a batch from a database.

Inside the context manager, checks out a session from the database,creates a batch from it, making the batch available.

Caller mustnot use the batch to perform API requests outside the scopeof the context manager.

Parameters
NameDescription
databaseDatabase

database to use

request_optionsRequestOptions

(Optional) Common options for the commit request. If a dict is provided, it must be of the same form as the protobuf messageRequestOptions.

max_commit_delaydatetime.timedelta

(Optional) The amount of latency this request is willing to incur in order to improve throughput.

BatchSnapshot

BatchSnapshot(database,read_timestamp=None,exact_staleness=None,session_id=None,transaction_id=None,)

Wrapper for generating and processing read / query batches.

Parameters
NameDescription
databaseDatabase

database to use

read_timestampdatetime.datetime

Execute all reads at the given timestamp.

exact_stalenessdatetime.timedelta

Execute all reads at a timestamp that isexact_staleness old.

Database

Database(database_id,instance,ddl_statements=(),pool=None,logger=None,encryption_config=None,database_dialect=DatabaseDialect.DATABASE_DIALECT_UNSPECIFIED,database_role=None,enable_drop_protection=False,proto_descriptors=None,)

Representation of a Cloud Spanner Database.

We can use aDatabase to:

  • create the database
  • reload the database
  • update the database
  • drop the database
Parameters
NameDescription
database_idstr

The ID of the database.

instanceInstance

The instance that owns the database.

ddl_statementslist of string

(Optional) DDL statements, excluding the CREATE DATABASE statement.

poolconcrete subclass ofAbstractSessionPool.

(Optional) session pool to be used by database. If not passed, the database will construct an instance ofBurstyPool.

loggerlogging.Logger

(Optional) a custom logger that is used iflog_commit_stats isTrue to log commit statistics. If not passed, a logger will be created when needed that will log the commit statistics to stdout.

encryption_configEncryptionConfig orRestoreDatabaseEncryptionConfig ordict

(Optional) Encryption configuration for the database. If a dict is provided, it must be of the same form as either of the protobuf messagesEncryptionConfig orRestoreDatabaseEncryptionConfig

database_dialectDatabaseDialect

(Optional) database dialect for the database

database_rolestr or None

(Optional) user-assigned database_role for the session.

enable_drop_protectionboolean

(Optional) Represents whether the database has drop protection enabled or not.

proto_descriptorsbytes

(Optional) Proto descriptors used by CREATE/ALTER PROTO BUNDLE statements in 'ddl_statements' above.

MutationGroupsCheckout

MutationGroupsCheckout(database)

Context manager for using mutation groups from a database.

Inside the context manager, checks out a session from the database,creates mutation groups from it, making the groups available.

Caller mustnot use the object to perform API requests outside the scopeof the context manager.

Parameter
NameDescription
databaseDatabase

database to use

SnapshotCheckout

SnapshotCheckout(database,**kw)

Context manager for using a snapshot from a database.

Inside the context manager, checks out a session from the database,creates a snapshot from it, making the snapshot available.

Caller mustnot use the snapshot to perform API requests outside thescope of the context manager.

Parameters
NameDescription
databaseDatabase

database to use

kwdict

Passed through toSnapshot constructor.

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-07-18 UTC.