Changelog

PyPI History

3.53.0 (2025-03-12)

Features

• Add AddSplitPoints API (7a5afba)

• Add Attempt, Operation and GFE Metrics (#1302) (fb21d9a)

• Add REST Interceptors which support reading metadata (7a5afba)

• Add support for opt-in debug logging (7a5afba)

• Add support for reading selective GAPIC generation methods from service YAML (7a5afba)

• Add the last statement option to ExecuteSqlRequest and ExecuteBatchDmlRequest (7a5afba)

• Add UUID in Spanner TypeCode enum (7a5afba)

• End to end tracing (#1315) (aa5d0e6)

• Exposing FreeInstanceAvailability in InstanceConfig (7a5afba)

• Exposing FreeInstanceMetadata in Instance configuration (to define the metadata related to FREE instance type) (7a5afba)

• Exposing InstanceType in Instance configuration (to define PROVISIONED or FREE spanner instance) (7a5afba)

• Exposing QuorumType in InstanceConfig (7a5afba)

• Exposing storage_limit_per_processing_unit in InstanceConfig (7a5afba)

• Snapshot isolation (#1318) (992fcae)

• spanner: A new enum IsolationLevel is added (#1224) (7a5afba)

Bug Fixes

• Allow Protobuf 6.x (#1320) (1faab91)

• Cleanup after metric integration test (#1322) (d7cf8b9)

• deps: Require grpc-google-iam-v1>=0.14.0 (7a5afba)

• Fix typing issue with gRPC metadata when key ends in -bin (7a5afba)

Performance Improvements

• Add option for last_statement (#1313) (19ab6ef)

Documentation

• A comment for enum DefaultBackupScheduleType is changed (7a5afba)

• A comment for enum value AUTOMATIC in enum DefaultBackupScheduleType is changed (7a5afba)

• A comment for enum value GOOGLE_MANAGED in enum Type is changed (7a5afba)

• A comment for enum value NONE in enum DefaultBackupScheduleType is changed (7a5afba)

• A comment for enum value USER_MANAGED in enum Type is changed (7a5afba)

• A comment for field base_config in message .google.spanner.admin.instance.v1.InstanceConfig is changed (7a5afba)

• A comment for field default_backup_schedule_type in message .google.spanner.admin.instance.v1.Instance is changed (7a5afba)

• A comment for field filter in message .google.spanner.admin.instance.v1.ListInstanceConfigOperationsRequest is changed (7a5afba)

• A comment for field filter in message .google.spanner.admin.instance.v1.ListInstancePartitionOperationsRequest is changed (7a5afba)

• A comment for field instance_config in message .google.spanner.admin.instance.v1.CreateInstanceConfigRequest is changed (7a5afba)

• A comment for field instance_partition_deadline in message .google.spanner.admin.instance.v1.ListInstancePartitionOperationsRequest is changed (7a5afba)

• A comment for field location in message .google.spanner.admin.instance.v1.ReplicaInfo is changed (7a5afba)

• A comment for field node_count in message .google.spanner.admin.instance.v1.Instance is changed (7a5afba)

• A comment for field node_count in message .google.spanner.admin.instance.v1.InstancePartition is changed (7a5afba)

• A comment for field operations in message .google.spanner.admin.instance.v1.ListInstanceConfigOperationsResponse is changed (7a5afba)

• A comment for field operations in message .google.spanner.admin.instance.v1.ListInstancePartitionOperationsResponse is changed (7a5afba)

• A comment for field optional_replicas in message .google.spanner.admin.instance.v1.InstanceConfig is changed (7a5afba)

• A comment for field parent in message .google.spanner.admin.instance.v1.ListInstancePartitionsRequest is changed (7a5afba)

• A comment for field processing_units in message .google.spanner.admin.instance.v1.Instance is changed (7a5afba)

• A comment for field processing_units in message .google.spanner.admin.instance.v1.InstancePartition is changed (7a5afba)

• A comment for field referencing_backups in message .google.spanner.admin.instance.v1.InstancePartition is changed (7a5afba)

• A comment for field replicas in message .google.spanner.admin.instance.v1.InstanceConfig is changed (7a5afba)

• A comment for field storage_utilization_percent in message .google.spanner.admin.instance.v1.AutoscalingConfig is changed (7a5afba)

• A comment for field unreachable in message .google.spanner.admin.instance.v1.ListInstancePartitionsResponse is changed (7a5afba)

• A comment for message CreateInstanceConfigRequest is changed (7a5afba)

• A comment for message DeleteInstanceConfigRequest is changed (7a5afba)

• A comment for message UpdateInstanceConfigRequest is changed (7a5afba)

• A comment for method CreateInstance in service InstanceAdmin is changed (7a5afba)

• A comment for method CreateInstanceConfig in service InstanceAdmin is changed (7a5afba)

• A comment for method CreateInstancePartition in service InstanceAdmin is changed (7a5afba)

• A comment for method ListInstanceConfigOperations in service InstanceAdmin is changed (7a5afba)

• A comment for method ListInstanceConfigs in service InstanceAdmin is changed (7a5afba)

• A comment for method ListInstancePartitionOperations in service InstanceAdmin is changed (7a5afba)

• A comment for method MoveInstance in service InstanceAdmin is changed (7a5afba)

• A comment for method UpdateInstance in service InstanceAdmin is changed (7a5afba)

• A comment for method UpdateInstanceConfig in service InstanceAdmin is changed (7a5afba)

• A comment for method UpdateInstancePartition in service InstanceAdmin is changed (7a5afba)

• Fix typo timzeone -> timezone (7a5afba)

3.52.0 (2025-02-19)

Features

• Add additional opentelemetry span events for session pool (a6811af)

• Add GCP standard otel attributes for python client (#1308) (0839f98)

• Add updated span events + trace more methods (#1259) (ad69c48)

• MetricsTracer implementation (#1291) (8fbde6b)

• Support GRAPH and pipe syntax in dbapi (#1285) (959bb9c)

• Support transaction and request tags in dbapi (#1262) (ee9662f)

• x-goog-spanner-request-id: Introduce AtomicCounter (#1275) (f2483e1)

Bug Fixes

• Retry UNAVAILABLE errors for streaming RPCs (#1278) (ab31078), closes #1150

• tracing: Ensure nesting of Transaction.begin under commit + fix suggestions from feature review (#1287) (d9ee75a)

• tracing: Only set span.status=OK if UNSET (#1248) (1d393fe), closes #1246

• Update retry strategy for mutation calls to handle aborted transactions (#1279) (0887eb4)

3.51.0 (2024-12-05)

Features

• Add connection variable for ignoring transaction warnings (#1249) (eeb7836)

• spanner: Implement custom tracer_provider injection for opentelemetry traces (#1229) (6869ed6)

• Support float32 parameters in dbapi (#1245) (829b799)

Bug Fixes

• Allow setting connection.read_only to same value (#1247) (5e8ca94)

• Allow setting staleness to same value in tx (#1253) (a214885)

• Dbapi raised AttributeError with [] as arguments (#1257) (758bf48)

Performance Improvements

• Optimize ResultSet decoding (#1244) (ccae6e0)

• Remove repeated GetSession calls for FixedSizePool (#1252) (c064815)

Documentation

• samples: Add samples for Cloud Spanner Default Backup Schedules (#1238) (054a186)

3.50.1 (2024-11-14)

Bug Fixes

• Json data type for non object values (#1236) (0007be3)

• spanner: Multi_scm issue in python release (#1230) (6d64e9f)

3.50.0 (2024-11-11)

Features

• spanner: Add support for Cloud Spanner Default Backup Schedules (45d4517)

Bug Fixes

• Add PROTO in streaming chunks (#1213) (43c190b)

• Pass through route-to-leader option in dbapi (#1223) (ec6c204)

• Pin nox version in requirements.in for devcontainer. (#1215) (41604fe)

Documentation

• Allow multiple KMS keys to create CMEK database/backup (68551c2)

3.49.1 (2024-09-06)

Bug Fixes

• Revert “chore(spanner): Issue#1143 - Update dependency” (92f05ed)

3.49.0 (2024-08-27)

Features

• Create a few code snippets as examples for using Spanner Graph in Python (#1186) (f886ebd)

• spanner: Add resource reference annotation to backup schedules (#1176) (b503fc9)

• spanner: Add samples for instance partitions (#1168) (55f83dc)

Bug Fixes

• JsonObject init when called on JsonObject of list (#1166) (c4af6f0)

3.48.0 (2024-07-30)

Features

• Add field lock_hint in spanner.proto (9609ad9)

• Add field order_by in spanner.proto (9609ad9)

• Add support for Cloud Spanner Scheduled Backups (9609ad9)

• spanner: Add support for txn changstream exclusion (#1152) (00ccb7a)

Bug Fixes

• Allow protobuf 5.x (9609ad9)

• spanner: Unskip emulator tests for proto (#1145) (cb74679)

3.47.0 (2024-05-22)

Features

• Add support for multi region encryption config (#1136) (bc71fe9)

• spanner: Add support for Proto Columns (#1084) (3ca2689)

3.46.0 (2024-05-02)

Features

• spanner: Adding EXPECTED_FULFILLMENT_PERIOD to the indicate instance creation times (with FULFILLMENT_PERIOD_NORMAL or FULFILLMENT_PERIOD_EXTENDED ENUM) with the extended instance creation time triggered by On-Demand Capacity Feature (293ecda)

Documentation

• Remove duplicate paramter description (#1052) (1164743)

3.45.0 (2024-04-17)

Features

• Add support for PG.OID in parameterized queries (#1035) (ea5efe4)

Bug Fixes

• Dates before 1000AD should use 4-digit years (#1132) (0ef6565), closes #1131

3.44.0 (2024-03-13)

Features

• Add support of float32 type (#1113) (7e0b46a)

• Changes for float32 in dbapi (#1115) (c9f4fbf)

Bug Fixes

• Correcting name of variable from table_schema to schema_name (#1114) (a92c6d3)

Documentation

• Add sample for managed autoscaler (#1111) (e73c671)

3.43.0 (2024-03-06)

Features

• Add retry and timeout for batch dml (#1107) (4f6340b)

• Add support for max commit delay (#1050) (d5acc26)

• Exposing Spanner client in dbapi connection (#1100) (9299212)

• Include RENAME in DDL regex (#1075) (3669303)

• Support partitioned dml in dbapi (#1103) (3aab0ed)

• Untyped param (#1001) (1750328)

Documentation

• Samples and tests for admin backup APIs (#1105) (5410c32)

• Samples and tests for admin database APIs (#1099) (c25376c)

• Update all public documents to use auto-generated admin clients. (#1109) (d683a14)

• Use autogenerated methods to get names from admin samples (#1110) (3ab74b2)

3.42.0 (2024-01-30)

Features

• Add FLOAT32 enum to TypeCode (5b94dac)

• Add max_commit_delay API (#1078) (ec87c08)

• Add proto descriptors for proto and enum types in create/update/get database ddl requests (5b94dac)

• Fixing and refactoring transaction retry logic in dbapi. Also adding interceptors support for testing (#1056) (6640888)

• Implementation of run partition query (#1080) (f3b23b2)

Bug Fixes

• Few fixes in DBAPI (#1085) (1ed5a47)

• Small fix in description when metadata is not present in cursor’s _result_set (#1088) (57643e6)

• spanner: Add SpannerAsyncClient import to spanner_v1 package (#1086) (2d98b54)

Documentation

• Samples and tests for auto-generated createDatabase and createInstance APIs. (#1065) (16c510e)

3.41.0 (2024-01-10)

Features

• Add BatchWrite API (#1011) (d0e4ffc)

• Add PG.OID type cod annotation (#1023) (2d59dd0)

• Add support for Directed Reads (#1000) (c4210b2)

• Add support for Python 3.12 (#1040) (b28dc9b)

• Batch Write API implementation and samples (#1027) (aa36b07)

• Implementation for batch dml in dbapi (#1055) (7a92315)

• Implementation for Begin and Rollback clientside statements (#1041) (15623cd)

• Implementation for partitioned query in dbapi (#1067) (63daa8a)

• Implementation of client side statements that return (#1046) (bb5fa1f)

• Implementing client side statements in dbapi (starting with commit) (#1037) (eb41b0d)

• Introduce compatibility with native namespace packages (#1036) (5d80ab0)

• Return list of dictionaries for execute streaming sql (#1003) (b534a8a)

• spanner: Add autoscaling config to the instance proto (#1022) (4d490cf)

• spanner: Add directed_read_option in spanner.proto (#1030) (84d662b)

Bug Fixes

• Executing existing DDL statements on executemany statement execution (#1032) (07fbc45)

• Fix for flaky test_read_timestamp_client_side_autocommit test (#1071) (0406ded)

• Require google-cloud-core >= 1.4.4 (#1015) (a2f87b9)

• Require proto-plus 1.22.2 for python 3.11 (#880) (7debe71)

• Use retry_async instead of retry in async client (#1044) (1253ae4)

Documentation

• Minor formatting (498dba2)

3.40.1 (2023-08-17)

Bug Fixes

• Fix to reload table when checking if table exists (#1002) (53bda62)

3.40.0 (2023-08-04)

Features

• Enable leader aware routing by default. This update contains performance optimisations that will reduce the latency of read/write transactions that originate from a region other than the default leader region. (e8dbfe7)

3.39.0 (2023-08-02)

Features

• Foreign key on delete cascade action testing and samples (#910) (681c8ee)

Documentation

• Minor formatting (#991) (60efc42)

3.38.0 (2023-07-21)

Features

• Set LAR as False (#980) (75e8a59)

3.37.0 (2023-07-21)

Features

• Enable leader aware routing by default. This update contains performance optimisations that will reduce the latency of read/write transactions that originate from a region other than the default leader region. (402b101)

Bug Fixes

• Add async context manager return types (#967) (7e2e712)

Documentation

• Fix documentation structure (#949) (b73e47b)

3.36.0 (2023-06-06)

Features

• Add DdlStatementActionInfo and add actions to UpdateDatabaseDdlMetadata (#948) (1ca6874)

• Testing for fgac-pg (#902) (ad1f527)

3.35.1 (2023-05-25)

Bug Fixes

• Catch rst stream error for all transactions (#934) (d317d2e)

3.35.0 (2023-05-16)

Features

• Add support for updateDatabase in Cloud Spanner (#914) (6c7ad29)

3.34.0 (2023-05-16)

Features

• Add support for UpdateDatabase in Cloud Spanner (#941) (38fb890)

Bug Fixes

• Upgrade version of sqlparse (#943) (df57ce6)

3.33.0 (2023-04-27)

Features

• Leader Aware Routing (#899) (f9fefad)

3.32.0 (2023-04-25)

Features

• Enable instance-level connection (#931) (d6963e2)

3.31.0 (2023-04-12)

Features

• Add databoost enabled property for batch transactions (#892) (ffb3915)

Bug Fixes

• Set databoost false (#928) (c9ed9d2)

3.30.0 (2023-03-28)

Features

• Pass custom Client object to dbapi (#911) (52b1a0a)

3.29.0 (2023-03-23)

Features

• Adding new fields for Serverless analytics (#906) (2a5a636)

Bug Fixes

• Correcting the proto field Id for field data_boost_enabled (#915) (428aa1e)

Documentation

• Fix formatting of request arg in docstring (#918) (c022bf8)

3.28.0 (2023-02-28)

Features

• Enable “rest” transport in Python for services supporting numeric enums (#897) (c21a0d5)

3.27.1 (2023-01-30)

Bug Fixes

• Add context manager return types (830f325)

• Change fgac database role tags (#888) (ae92f0d)

• Fix for database name in batch create request (#883) (5e50beb)

Documentation

• Add documentation for enums (830f325)

3.27.0 (2023-01-10)

Features

• Add support for python 3.11 (#879) (4b8c2cf)

• Add typing to proto.Message based class attributes (4683d10)

Bug Fixes

• Add dict typing for client_options (4683d10)

• deps: Require google-api-core >=1.34.0, >=2.11.0 (4683d10)

• Drop packaging dependency (4683d10)

• Drop usage of pkg_resources (4683d10)

• Fix timeout default values (4683d10)

Documentation

• samples: Snippetgen handling of repeated enum field (4683d10)

• samples: Snippetgen should call await on the operation coroutine before calling result (4683d10)

3.26.0 (2022-12-15)

Features

• Inline Begin transction for RW transactions (#840) (c2456be)

Bug Fixes

• Fix for binding of pinging and bursty pool with database role (#871) (89da17e)

3.25.0 (2022-12-13)

Features

• Fgac support and samples (#867) (24fa244)

3.24.0 (2022-11-30)

Features

• Add snippets for Spanner DML with returning clause (#811) (62e55b5)

• Add support and tests for DML returning clauses (#805) (81505cd)

3.23.0 (2022-11-07)

Features

• Adding support and samples for jsonb (#851) (268924d)

• Support request priorities (#834) (ef2159c)

• Support requiest options in !autocommit mode (#838) (ab768e4)

• Update result_set.proto to return undeclared parameters in ExecuteSql API (#841) (0aa4cad)

• Update transaction.proto to include different lock modes (#845) (c191296)

Bug Fixes

• deps: Allow protobuf 3.19.5 (#839) (06725fc)

Documentation

• Describe DB API and transactions retry mechanism (#844) (30a0666), closes #791

3.22.1 (2022-10-04)

Bug Fixes

• deps: Require protobuf >= 3.20.2 (#830) (4d71563)

Documentation

• samples: add samples for CMMR phase 2 (4282340)

3.22.0 (2022-09-26)

Features

• Adding reason, domain, metadata & error_details fields in Custom Exceptions for additional info (#804) (2a74060)

3.21.0 (2022-09-16)

Features

• Add custom instance config operations (#810) (f07333f)

3.20.0 (2022-08-30)

Features

• Adds TypeAnnotationCode PG_JSONB (#792) (6a661d4)

Bug Fixes

• if JsonObject serialized to None then return null_value instead of string_value (#771) (82170b5)

3.19.0 (2022-08-17)

Features

• support JSON object consisting of an array. (#782) (92a3169)

3.18.0 (2022-08-12)

Features

• Add ListDatabaseRoles API to support role based access control (#774) (3867882)

Bug Fixes

• deps: allow protobuf < 5.0.0 (eee5f31)

• deps: require proto-plus >= 1.22.0 (eee5f31)

• target new spanner db admin service config (8c73cb3)

3.17.0 (2022-07-19)

Features

• add audience parameter (60db146)

• add Session creator role (60db146)

• Adding two new fields for Instance create_time and update_time (60db146)

Bug Fixes

• deps: require google-api-core>=1.32.0,>=2.8.0 (#739) (60db146)

Documentation

• clarify transaction semantics (60db146)

3.16.0 (2022-07-11)

Features

• Automated Release Blessing (#767) (19caf44)

• python typing (#646) (169019f)

Bug Fixes

• @421 (#769) (58640a1)

• add pause for the staleness test (#762) (bb7f1db)

• require python 3.7+ (#768) (f2c273d)

3.15.1 (2022-06-17)

Bug Fixes

• don’t use a list for empty arguments (#750) (5d8b055)

3.15.0 (2022-06-17)

Features

• Add support for Postgresql dialect (#741) (d2551b0)

3.14.1 (2022-06-08)

Bug Fixes

• deps: require protobuf <4.0.0dev (#731) (8004ae5)

Documentation

• fix changelog header to consistent size (#732) (97b6d37)

3.14.0 (2022-04-20)

Features

• add support for Cross region backup proto changes (#691) (8ac62cb)

• add support for spanner copy backup feature (#600) (97faf6c)

• AuditConfig for IAM v1 (7642eba)

Bug Fixes

• add NOT_FOUND error check in exit method of SessionCheckout. (#718) (265e207)

• deps: require google-api-core>=1.31.5, >=2.3.2 (#685) (7a46a27)

• deps: require grpc-google-iam-v1 >=0.12.4 (7642eba)

• deps: require proto-plus>=1.15.0 (7a46a27)

Documentation

• add generated snippets (#680) (f21dac4)

3.13.0 (2022-02-04)

Features

• add api key support (819be92)

• add database dialect (#671) (819be92)

Bug Fixes

• add support for row_count in cursor. (#675) (d431339)

• resolve DuplicateCredentialArgs error when using credentials_file (#676) (39ff137)

3.12.1 (2022-01-06)

Bug Fixes

• Django and SQLAlchemy APIs are failing to use rowcount (#654) (698260e)

3.12.0 (2021-11-25)

Features

• add context manager support in client (5ae4be8)

• add context manager support in client (#637) (5ae4be8)

• add support for python 3.10 (#626) (17ca61b), closes #623

• db_api: add an ability to set ReadOnly/ReadWrite connection mode (#475) (cd3b950)

• db_api: make rowcount property NotImplemented (#603) (b5a567f)

• db_api: raise exception with message for executemany() (#595) (95908f6)

• db_api: support JSON data type (#627) (d760c2c)

• db_api: support stale reads (#584) (8ca868c)

Bug Fixes

• db_api: emit warning instead of an exception for rowcount property (#628) (62ff9ae)

• deps: drop packaging dependency (5ae4be8)

• deps: require google-api-core >= 1.28.0 (5ae4be8)

• improper types in pagers generation (5ae4be8)

Performance Improvements

• dbapi: set headers correctly for dynamic routing (#644) (d769ff8)

Documentation

• list oneofs in docstring (5ae4be8)

3.11.1 (2021-10-04)

Bug Fixes

• add support for json data type (#593) (bc5ddc3)

• remove database_version_time param from test_instance_list_backups (#609) (db63aee)

3.11.0 (2021-09-29)

Features

• adding support for spanner request options tags (#276) (e16f376)

3.10.0 (2021-09-17)

Features

• set a separate user agent for the DB API (#566) (b5f977e)

Bug Fixes

• db_api: move connection validation into a separate method (#543) (237ae41)

• handle google.api_core.exceptions.OutOfRange exception and throw InegrityError as expected by dbapi standards (#571) (dffcf13)

3.9.0 (2021-08-26)

Features

• add support for JSON type (#353) (b1dd04d)

3.8.0 (2021-08-15)

Features

• use DML batches in executemany() method (#412) (cbb4ee3)

Bug Fixes

• samples: batch_update() results processing error (#484) (bdd5f8b)

3.7.0 (2021-07-29)

Features

• add always_use_jwt_access (#381) (0f1a5de)

• add configurable leader placement support (#399) (7f1b120)

• add sample for low cost instances (#392) (3f4f93f)

Bug Fixes

• avoid bad version of opentelemetry-instrumentation (#429) (1620c12)

• deps: pin ‘google-{api,cloud}-core’ to allow 2.x versions (#415) (b0455d0)

• disable always_use_jwt_access (c37bf21)

• disable always_use_jwt_access (#395) (c37bf21)

• enable self signed jwt for grpc (#427) (2487800)

• support merging for NUMERIC values (#434) (06b4215), closes #433

Documentation

• fix docstring for session.py (#387) (3132587)

3.6.0 (2021-06-23)

Features

• add RPC priority support (#324) (51533b8)

• add support for low-cost instances (#313) (44aa7cc)

• spanner: add processing_units to Instance resource (#364) (113505c)

• update query stats samples (#373) (c1ee8c2)

Bug Fixes

• db_api: use sqlparse to split DDL statements (#372) (ed9e124)

• db_api: classify batched DDL statements (#360) (b8b24e1)

• deps: add packaging requirement (#368) (89c126c)

Documentation

• omit mention of Python 2.7 in ‘CONTRIBUTING.rst’ (#1127) (#374) (b7b3c38), closes #1126

3.5.0 (2021-06-11)

Features

• add decimal validation for numeric precision and scale supported by Spanner (#340) (aa36c5e)

• add progress field to UpdateDatabaseDdlMetadata (#361) (1c03dcc)

• add query statistics package support (#129) (6598dea)

Bug Fixes

• an Aborted exception isn’t properly retried (#345) (e69e6ab)

• correctly classify select statements that begin with brackets (#351) (d526acc)

• update to support the open-telemetry status code spec change (#358) (0f894f1)

3.4.0 (2021-04-29)

Features

• add samples for CMEK support (#275) (f8d9bd3)

• added support for numeric field for python decimal value (#316) (070a171)

• dbapi: remove string conversion for numeric fields (#317) (772aa3c)

Bug Fixes

• correctly set resume token when restarting streams (#314) (0fcfc23)

• support INSERT from SELECT clause with args (#306) (0dcda5e)

Performance Improvements

• use protobuf for metadata to reduce type conversions (#325) (5110b9b)

3.3.0 (2021-03-25)

Features

• add encryption_info to Database (#284) (2fd0352)

• add support for CMEK (#105) (e990ff7)

• add support for custom timeout and retry parameters in execute_update method in transactions (#251) (8abaebd)

• added retry and timeout params to partition read in database and snapshot class (#278) (1a7c9d2)

• db_api: support executing several DDLs separated by semicolon (#277) (801ddc8)

Bug Fixes

• avoid consuming pending null values when merging (#286) (c6cba9f)

• db_api: allow file path for credentials (#221) (1de0284)

• db_api: ensure DDL statements are being executed (#290) (baa02ee)

• db_api: revert Mutations API usage (#285) (e5d4901)

Documentation

• fix docstring types and typos (#259) (1b0ce1d)

• fix snapshot usage (#291) (eee2181)

3.2.0 (2021-03-02)

Features

• add Database.list_tables method (#219) (28bde8c)

• add sample for commit stats (#241) (1343656)

• add samples for PITR (#222) (da146b7)

Bug Fixes

• remove print statement (#245) (1c2a64f)

3.1.0 (2021-02-23)

Features

• add support for Point In Time Recovery (PITR) (#148) (a082e5d)

• add support to log commit stats (#205) (434967e)

Bug Fixes

• connection attribute of connection class and include related unit tests (#228) (4afea77)

• db_api: add dummy lastrowid attribute (#227) (0375914)

• fix execute insert for homogeneous statement (#233) (36b12a7)

• use datetime timezone info when generating timestamp strings (#236) (539f145)

Performance Improvements

• improve streaming performance (#240) (3e35d4a)

3.0.0 (2021-01-15)

⚠ BREAKING CHANGES

• convert operations pbs into Operation objects when listing operations (#186)

Features

• add support for instance labels (#193) (ed462b5)

• add support for ssl credentials; add throttled field to UpdateDatabaseDdlMetadata (#161) (2faf01b)

• adding missing docstrings for functions & classes (#188) (9788cf8)

• autocommit sample (#172) (4ef793c)

Bug Fixes

• convert operations pbs into Operation objects when listing operations (#186) (ed7152a)

• Convert PBs in system test cleanup (#199) (ede4343)

• dbapi: autocommit enabling fails if no transactions begun (#177) (e981adb)

• dbapi: executemany() hiding all the results except the last (#181) (020dc17)

• dbapi: Spanner protobuf changes causes KeyError’s (#206) (f1e21ed)

• remove client side gRPC receive limits (#192) (90effc4)

• Rename to fix “Mismatched region tag” check (#201) (c000ec4)

Documentation

• homogenize region tags (#194) (1501022)

• homogenize region tags pt 2 (#202) (87789c9)

• update CHANGELOG breaking change comment (#180) (c7b3b9e)

2.1.0 (2020-11-24)

Features

• dbapi: add aborted transactions retry support (#168) (d59d502), closes #34 googleapis/python-spanner-django#544

• remove adding a dummy WHERE clause into UPDATE and DELETE statements (#169) (7f4d478)

Bug Fixes

• Add sqlparse dependency (#171) (e801a2e)

Reverts

• Revert “test: unskip list_backup_operations sample test (#170)” (#174) (6053f4a), closes #170 #174

2.0.0 (2020-11-11)

⚠ BREAKING CHANGES

• list_instances, list_databases, list_instance_configs, and list_backups will now return protos rather than the handwritten wrapper (#147)

Features

• DB-API driver + unit tests (#160) (2493fa1)

• migrate to v2.0.0 (#147) (bf4b278)

1.19.1 (2020-10-13)

Bug Fixes

• handle Unmergable errors when merging struct responses (#152) (d132409)

Documentation

• update samples dep to ‘google-cloud-spanner==1.19.0’ (#137) (0fba41a)

• update samples from python-docs-samples (#146) (7549383)

1.19.0 (2020-09-08)

Features

• add support for NUMERIC type (#86) (a79786e)

Bug Fixes

• list_instances() uses filter_ arg (#143) (340028c)

• Remove stray bigquery lines (#138) (cbfcc8b)

1.18.0 (2020-08-25)

Features

• add client_options to base class (#132) (6851bb8)

• add OpenTelemetry tracing to spanner calls (#107) (4069c37)

Bug Fixes

• resume iterator on EOS internal error (#122) (45a1538)

Documentation

• add install reference for cloud trace exporter (opentelemetry) (#127) (23fcd4c)

• add instructions for using a Cloud Spanner emulator (#136) (808837b)

• add samples from spanner/cloud-client (#117) (8910771), closes #804 #815 #818 #887 #914 #922 #928 #962 #992 #1004 #1035 #1055 #1063 #1093 #1107 #1121 #1158 #1138 #1186 #1192 #1207 #1254 #1316 #1354 #1376 #1377 #1402 #1406 #1425 #1441 #1464 #1519 #1548 #1633 #1742 #1836 #1846 #1872 #1980 #2068 #2153 #2224 #2198 #2251 #2295 #2356 #2392 #2439 #2535 #2005 #2721 #3093 #3101 #2806 #3377

• typo fix (#109) (63b4324)

1.17.1 (2020-06-24)

Documentation

• remove client-usage sections that no longer apply (#95) (16a812f)

• update batch-usage reflect the correct usage (#93) (6ec64d8)

• update documentation for database-usage (#96) (44e398c)

• update documentation for snapshot usage (#94) (613d9c8)

1.17.0 (2020-05-26)

Features

• add support for using the emulator programatically (#87) (b22630b)

Bug Fixes

• update backup timeouts (via synth) (#82) (f5d74a0)

1.16.0 (2020-05-05)

Features

• add support for retrying aborted partitioned DML statements (#66) (8a3d700)

Bug Fixes

• add keepalive changes to synth.py (#55) (805bbb7)

• pass gRPC config options to gRPC channel creation (#26) (6c9a1ba)

1.15.1 (2020-04-08)

Bug Fixes

• add keepalive to gRPC channel (#49) (dfbc656)

• increment seqno before execute calls to prevent InvalidArgument … (#19) (adeacee)

• Pin Sphnix version to last working release (#51) (430ca32)

1.15.0 (2020-03-17)

Features

• Add emulator support (#14) (b315593)

• Export transaction._rolled_back as transaction.rolled_back (#16) (974ee92)

• Add support for backups (#35) (39288e7)

• Implement query options versioning support (#30) (5147921)

Bug Fixes

• Remove erroneous timeouts for batch_create_session calls (#18) (997a034)

1.14.0 (2020-01-31)

Features

• Add deprecation warnings; add field_mask to get_instance; add endpoint_uris to Instance proto; update timeouts; make mutations optional for commits (via synth) (62edbe1)

• Add resource based routing implementation (#10183) (e072d5d)

• Un-deprecate resource name helper functions, add 3.8 tests (via synth) (#10062) (dbb79b0)

Bug Fixes

• Be permssive about merging an empty struct (#10079) (cfae63d)

• Fix imports for doc samples (#10283) (55a21d9)

1.13.0

11-11-2019 15:59 PST

Implementation Changes

Fix TransactionPingingPool to stop thowing ‘’NoneType’ object is not callable’ error. (#9609) Return sessions from pool in LIFO order. (#9454)

Documentation

• Add Python 2 sunset banner to documentation. (#9036)

• Update description of the timeout_secs parameter. (#9381)

Internal / Testing Changes

• Harden test_transaction_batch_update\* systests against partial success + abort. (#9579)

1.12.0

10-23-2019 19:09 PDT

Implementation Changes

• Add batch_create_session calls to session pools. (#9488)

New Features

• Add client_options to client constructor. (#9151)

Internal / Testing Changes

• Harden ‘test_reload_instance’ systest against eventual consistency failures. (#9394)

• Harden ‘test_transaction_batch_update_w_syntax_error’ systest. (#9395)

• Propagate errors from ‘Transaction.batch_update’ in systest. (#9393)

1.11.0

10-15-2019 06:55 PDT

Implementation Changes

• Adjust gRPC timeouts (via synth). (#9330)

• Make session_count optional for SpannerClient.batch_create_sessions (via synth). (#9280)

• Remove send / receive message size limit, update docstrings (via synth). (#8968)

New Features

• Add batch_create_sessions method to generated client (via synth). (#9087)

Dependencies

• Pin ‘google-cloud-core >= 1.0.3, < 2.0.0dev’. (#9445)

Documentation

• Remove references to old authentication credentials in docs. (#9456)

• Fix intersphinx reference to requests. (#9294)

• Fix run_in_transaction return value docs. (#9264)

• Remove CI for gh-pages, use googleapis.dev for api_core refs. (#9085)

• Remove compatability badges from READMEs. (#9035)

• Add DML insert and update examples to README. (#8698)

• Update intersphinx mapping for requests. (#8805)

1.10.0

07-24-2019 17:32 PDT

Implementation Changes

• Add backoff for run_in_transaction when backend does not provide ‘RetryInfo’ in response. (#8461)

• Adjust gRPC timeouts (via synth). (#8445)

• Allow kwargs to be passed to create_channel (via synth). (#8403)

New Features

• Add ‘options_’ argument to clients’ ‘get_iam_policy’; pin black version (via synth). (#8659)

• Add ‘client_options’ support, update list method docstrings (via synth). (#8522)

Dependencies

• Bump minimum version for google-api-core to 1.14.0. (#8709)

• Update pin for ‘grpc-google-iam-v1’ to 0.12.3+. (#8647)

Documentation

• Link to googleapis.dev documentation in READMEs. (#8705)

• Add compatibility check badges to READMEs. (#8288)

Internal / Testing Changes

• Fixes #8545 by removing typing information for kwargs to not conflict with type checkers (#8546)

• Add docs job to publish to googleapis.dev. (#8464)

• Declare encoding as utf-8 in pb2 files (via synth). (#8363)

• Add disclaimer to auto-generated template files (via synth). (#8327)

• Suppress checking ‘cov-fail-under’ in nox default session (via synth). (#8251)

• Blacken noxfile.py, setup.py (via synth). (#8131)

• Harden synth replacement against template adding whitespace. (#8103)

1.9.0

05-16-2019 12:54 PDT

Implementation Changes

• Add routing header to method metadata (via synth). (#7750)

• Remove classifier for Python 3.4 for end-of-life. (#7535)

New Features

• Add client_info support to client. (#7878)

Dependencies

• Pin google-cloud-core >= 1.0.0, < 2.0dev. (#7993)

Documentation

• Expand API reference for snapshot / transaction. (#7618)

Internal / Testing Changes

• Add nox session docs, remove retries for DEADLINE_EXCEEDED (via synth). (#7781)

• Added matching END tags to Spanner Tests (#7529)

1.8.0

03-05-2019 12:57 PST

Implementation Changes

• Protoc-generated serialization update. (#7095)

• Fix typo in exported param type name. (#7295)

New Features

• Add Batch DML support. (#7485)

Documentation

• Copy lintified proto files, update docstrings (via synth). (#7453)

• Fix Batch object creation instructions. (#7341)

• Updated client library documentation URLs. (#7307)

• Fix README to install spanner instead of datastore. (#7301)

Internal / Testing Changes

• Add clarifying comment to blacken nox target. (#7403)

• Ensure that GRPC config file is included in MANIFEST.in after templating. (#7046)

• Add protos as an artifact to library. (#7205)

• Update copyright headers.

1.7.1

12-14-2018 15:18 PST

Documentation

• Announce Python 2 deprecation (#6910)

• Normalize documentation for ‘page_size’ / ‘max_results’ / ‘page_token’ (#6842)

Internal / Testing Changes

• Include grpc config in manifest (#6928)

1.7.0

12-10-2018 13:10 PST

Implementation Changes

• Add PingingPool and TransactionPingingPool to toplevel module (#6886)

• Add operation_id parameter to Database.update_ddl. (#6825)

• Pick up changes to GAPIC method configuration (#6615)

• Add timeout + retry settings to Sessions/Snapshots (#6536)

• Pick up fixes to GAPIC generator. (#6576)

Dependencies

• Update dependency to google-cloud-core (#6835)

Internal / Testing Changes

• Add baseline for synth.metadata

• Blacken. (#6846)

• Update noxfile.

• Blacken all gen’d libs (#6792)

• Omit local deps (#6701)

• Run black at end of synth.py (#6698)

• Run Black on Generated libraries (#6666)

• Add templates for flake8, coveragerc, noxfile, and black. (#6642)

• Add tags to DML system tests (#6580)

1.6.1

11-09-2018 14:49 PST

Implementation Changes

• Fix client_info bug, update docstrings. (#6420)

Documentation

• Update README service links in quickstart guides. (#6322)

• Normalize use of support level badges (#6159)

• Fix typo in spanner usage documentation (#6209)

Internal / Testing Changes

• Rationalize ‘all_types’ round-trip systest (#6379)

• Bump minimum ‘api_core’ version for all GAPIC libs to 1.4.1. (#6391)

• Add systest for returning empty array struct (#4449)

• Add systests not needing tables (#6308)

• Use new Nox (#6175)

1.6.0

10-08-2018 08:25 PDT

New Features

• Add support for DML/PDML. (#6151)

Implementation Changes

• Add ‘synth.py’ and regen GAPIC code. (#6040)

Documentation

• Remove invalid examples of database.transaction(). (#6032)

• Redirect renamed usage.html/client.html -> index.html. (#5996)

• Fix leakage of sections into sidebar menu. (#5986)

• Prepare documentation for repo split. (#5938)

Internal / Testing Changes

• Remove extra grpc_gcp system tests. (#6049)

1.5.0

New Features

• Add support for session / pool labels (#5734)

• Add support for gRPC connection management (#5553)

Dependencies

• Add grpcio-gcp dependency for Cloud Spanner (#5904)

Internal / Testing Changes

• Don’t hardcode endpoint URL in grpc_gcp unit tests. (#5893)

• Run grpc_gcp unit tests only with Python 2.7 / 3.6. (#5871)

• Nox: use inplace installs (#5865)

• Benchmarks: print() is a function in Python 3 (#5862)

• Retry test_transaction_read_and_insert_then_rollback when aborted. (#5737)

• Skip the flaky test_update_database_ddl systest. (#5704)

1.4.0

Implementation Changes

• Ensure that initial resume token is bytes, not text. (#5450)

• Prevent process_read_batch from mutating params (#5416)

• Avoid overwriting ‘module’ of messages from shared modules. (#5364)

New Features

• Add support for Python 3.7 (#5288)

• Add support for Spanner struct params. (#5463)

Internal / Testing Changes

• Modify system tests to use prerelease versions of grpcio (#5304)

1.3.0

Interface additions

• Added spanner_v1.COMMIT_TIMESTAMP. (#5102)

1.2.0

New features

• Added batch query support (#4938)

Implementation changes

• Removed custom timestamp class in favor of the one in google-api-core. (#4980)

Dependencies

• Update minimum version for google-api-core to 1.1.0 (#5030)

Documentation

• Update package metadata release status to ‘Stable’ (#5031)

1.1.0

Dependencies

• The minimum version for google-api-core has been updated to version 1.0.0. This may cause some incompatibility with older google-cloud libraries, you will need to update those libraries if you have a dependency conflict. (#4944, #4946)

Testing and internal changes

• Fix load_keys() in YCSB-like benchmark for cloud spanner. (#4919)

• Install local dependencies when running lint (#4936)

• Re-enable lint for tests, remove usage of pylint (#4921)

• Normalize all setup.py files (#4909)

• Fix system test util to populate streaming (#4888)

• Retry conflict errors in system test (#4850)

1.0.0

Breaking Changes

• to_pb has now been made private (_to_pb) in KeySet and KeyRange (#4740)

Documentation Changes

• Database update_ddl missing param in documentation (#4749)

0.30.0

Breaking Changes

• The underlying autogenerated client library was re-generated to pick up new features and resolve bugs, this may change the exceptions raised from various methods. (#4695)

• Made StreamedResultSet’s row, consume_all, and consume_next members private (#4492)

Implementation Changes

• Keyset can now infer defaults to start_closed or end_closed when only one argument is specified. (#4735)

Documentation

• Brought Spanner README more in line with others. (#4306, #4317)

Testing

• Added several new system tests and fixed minor issues with existing tests. (

  4631, #4569, #4573, #4572, #4416, #4411, #4407, #4386, #4419, #4489,

  4678, #4620, #4418, #4403, #4397, #4383, #4371, #4372, #4374, #4370, #4285,

  4321)

• Excluded generated code from linting. (#4375)

• Added a nox -s default session for all packages. (#4324)

0.29.0

Implementation Changes

• Bugfix: Clear session._transaction before calling _delay_until_retry (#4185)

• Bugfix: Be permissive about merging an empty list. (#4170, fixes #4164)

Documentation

• Added link to “Python Development Environment Setup Guide” in project README (#4187, h/t to @michaelawyu)

Dependencies

• Upgrading to google-cloud-core >= 0.28.0 and adding dependency on google-api-core (#4221, #4280)

• Deferring to google-api-core for grpcio and googleapis-common-protos dependencies (#4096, #4098)

PyPI: https://pypi.org/project/google-cloud-spanner/0.29.0/