- 3.46.0 (latest)
- 3.45.0
- 3.44.0
- 3.43.0
- 3.42.0
- 3.41.0
- 3.40.1
- 3.39.0
- 3.38.0
- 3.37.0
- 3.36.0
- 3.35.1
- 3.34.0
- 3.33.0
- 3.32.0
- 3.31.0
- 3.30.0
- 3.29.0
- 3.28.0
- 3.27.1
- 3.26.0
- 3.25.0
- 3.24.0
- 3.23.0
- 3.22.2
- 3.21.0
- 3.20.0
- 3.19.0
- 3.18.0
- 3.17.0
- 3.16.0
- 3.15.1
- 3.14.1
- 3.13.0
- 3.12.1
- 3.11.1
- 3.10.0
- 3.9.0
- 3.8.0
- 3.7.0
- 3.6.0
- 3.5.0
- 3.4.0
- 3.3.0
- 3.2.0
- 3.1.0
- 3.0.0
- 2.1.1
- 2.0.0
- 1.19.3
- 1.18.0
- 1.17.1
- 1.16.0
- 1.15.1
- 1.14.0
- 1.13.0
- 1.12.0
- 1.11.0
- 1.10.0
Snapshot(
session,
read_timestamp=None,
min_read_timestamp=None,
max_staleness=None,
exact_staleness=None,
multi_use=False,
)
Allow a set of reads / SQL statements with shared staleness.
If no options are passed, reads will use the strong
model, reading
at a timestamp where all previously committed transactions are visible.
Parameters | |
---|---|
Name | Description |
session |
Session
the session used to perform the commit. |
read_timestamp |
Execute all reads at the given timestamp. |
min_read_timestamp |
Execute all reads at a timestamp >= |
max_staleness |
Read data at a timestamp >= NOW - |
exact_staleness |
Execute all reads at a timestamp that is |
multi_use |
If true, multipl |
Methods
begin
begin()
Begin a read-only transaction on the database.
Exceptions | |
---|---|
Type | Description |
ValueError | if the transaction is already begun, committed, or rolled back. |
Returns | |
---|---|
Type | Description |
bytes | the ID for the newly-begun transaction. |
execute_sql
execute_sql(sql, params=None, param_types=None, query_mode=None, partition=None, retry=<_MethodDefault._DEFAULT_VALUE: <object object>>, timeout=<_MethodDefault._DEFAULT_VALUE: <object object>>)
Perform an ExecuteStreamingSql
API request.
Parameters | |
---|---|
Name | Description |
sql |
str
SQL query statement |
params |
dict, {str -> column value}
values for parameter replacement. Keys must match the names used in |
param_types |
dict[str -> Union[dict, .types.Type]]
(Optional) maps explicit types for one or more param values; required if parameters are passed. |
query_mode |
QueryMode
Mode governing return of results / query plan. See https://cloud.google.com/spanner/reference/rpc/google.spanner.v1#google.spanner.v1.ExecuteSqlRequest.QueryMode1 |
partition |
bytes
(Optional) one of the partition tokens returned from |
Exceptions | |
---|---|
Type | Description |
ValueError | for reuse of single-use snapshots, or if a transaction ID is already pending for multiple-use snapshots. |
Returns | |
---|---|
Type | Description |
StreamedResultSet | a result set instance which can be used to consume rows. |
partition_query
partition_query(
sql, params=None, param_types=None, partition_size_bytes=None, max_partitions=None
)
Perform a ParitionQuery
API request.
Parameters | |
---|---|
Name | Description |
sql |
str
SQL query statement |
params |
dict, {str -> column value}
values for parameter replacement. Keys must match the names used in |
param_types |
dict[str -> Union[dict, .types.Type]]
(Optional) maps explicit types for one or more param values; required if parameters are passed. |
partition_size_bytes |
int
(Optional) desired size for each partition generated. The service uses this as a hint, the actual partition size may differ. |
max_partitions |
int
(Optional) desired maximum number of partitions generated. The service uses this as a hint, the actual number of partitions may differ. |
Exceptions | |
---|---|
Type | Description |
ValueError | for single-use snapshots, or if a transaction ID is already associtated with the snapshot. |
Returns | |
---|---|
Type | Description |
iterable of bytes | a sequence of partition tokens |
partition_read
partition_read(
table, columns, keyset, index="", partition_size_bytes=None, max_partitions=None
)
Perform a ParitionRead
API request for rows in a table.
Parameters | |
---|---|
Name | Description |
table |
str
name of the table from which to fetch data |
columns |
list of str
names of columns to be retrieved |
keyset |
KeySet
keys / ranges identifying rows to be retrieved |
index |
str
(Optional) name of index to use, rather than the table's primary key |
partition_size_bytes |
int
(Optional) desired size for each partition generated. The service uses this as a hint, the actual partition size may differ. |
max_partitions |
int
(Optional) desired maximum number of partitions generated. The service uses this as a hint, the actual number of partitions may differ. |
Exceptions | |
---|---|
Type | Description |
ValueError | for single-use snapshots, or if a transaction ID is already associtated with the snapshot. |
Returns | |
---|---|
Type | Description |
iterable of bytes | a sequence of partition tokens |
read
read(table, columns, keyset, index="", limit=0, partition=None)
Perform a StreamingRead
API request for rows in a table.
Parameters | |
---|---|
Name | Description |
table |
str
name of the table from which to fetch data |
columns |
list of str
names of columns to be retrieved |
keyset |
KeySet
keys / ranges identifying rows to be retrieved |
index |
str
(Optional) name of index to use, rather than the table's primary key |
limit |
int
(Optional) maximum number of rows to return. Incompatible with |
partition |
bytes
(Optional) one of the partition tokens returned from |
Exceptions | |
---|---|
Type | Description |
ValueError | for reuse of single-use snapshots, or if a transaction ID is already pending for multiple-use snapshots. |
Returns | |
---|---|
Type | Description |
StreamedResultSet | a result set instance which can be used to consume rows. |