sqlalchemy-bigquery - pypi Package Compare versions

Comparing version 1.12.1 to 1.13.0

PKG-INFO

 Metadata-Version: 2.1
 Name: sqlalchemy-bigquery
-Version: 1.12.1
+Version: 1.13.0
 Summary: SQLAlchemy dialect for BigQuery
@@ -27,7 +27,7 @@ Home-page: https://github.com/googleapis/python-bigquery-sqlalchemy
 License-File: AUTHORS
-Requires-Dist: google-api-core!=2.0.*,!=2.1.*,!=2.2.*,!=2.3.0,<3.0.0dev,>=1.31.5
-Requires-Dist: google-auth<3.0.0dev,>=1.25.0
-Requires-Dist: google-cloud-bigquery<4.0.0dev,>=3.3.6
+Requires-Dist: google-api-core!=2.0.*,!=2.1.*,!=2.2.*,!=2.3.0,<3.0.0,>=1.31.5
+Requires-Dist: google-auth<3.0.0,>=1.25.0
+Requires-Dist: google-cloud-bigquery<4.0.0,>=3.3.6
 Requires-Dist: packaging
-Requires-Dist: sqlalchemy<3.0.0dev,>=1.4.16
+Requires-Dist: sqlalchemy<3.0.0,>=1.4.16
 Provides-Extra: geography
@@ -42,16 +42,16 @@ Requires-Dist: GeoAlchemy2; extra == "geography"
 Provides-Extra: bqstorage
-Requires-Dist: google-cloud-bigquery-storage<3.0.0dev,>=2.0.0; extra == "bqstorage"
-Requires-Dist: grpcio<2.0dev,>=1.47.0; extra == "bqstorage"
-Requires-Dist: grpcio<2.0dev,>=1.49.1; python_version >= "3.11" and extra == "bqstorage"
+Requires-Dist: google-cloud-bigquery-storage<3.0.0,>=2.0.0; extra == "bqstorage"
+Requires-Dist: grpcio<2.0.0,>=1.47.0; extra == "bqstorage"
+Requires-Dist: grpcio<2.0.0,>=1.49.1; python_version >= "3.11" and extra == "bqstorage"
 Requires-Dist: pyarrow>=3.0.0; extra == "bqstorage"
 Provides-Extra: all
+Requires-Dist: grpcio<2.0.0,>=1.47.0; extra == "all"
 Requires-Dist: GeoAlchemy2; extra == "all"
+Requires-Dist: alembic; extra == "all"
 Requires-Dist: shapely; extra == "all"
-Requires-Dist: grpcio<2.0dev,>=1.47.0; extra == "all"
 Requires-Dist: pytz; extra == "all"
 Requires-Dist: packaging; extra == "all"
+Requires-Dist: google-cloud-bigquery-storage<3.0.0,>=2.0.0; extra == "all"
+Requires-Dist: grpcio<2.0.0,>=1.49.1; python_version >= "3.11" and extra == "all"
 Requires-Dist: pyarrow>=3.0.0; extra == "all"
-Requires-Dist: google-cloud-bigquery-storage<3.0.0dev,>=2.0.0; extra == "all"
-Requires-Dist: alembic; extra == "all"
-Requires-Dist: grpcio<2.0dev,>=1.49.1; python_version >= "3.11" and extra == "all"
 
@@ -58,0 +58,0 @@ SQLAlchemy Dialect for BigQuery

setup.py

@@ -56,3 +56,3 @@ #!/usr/bin/env python
     "bqstorage": [
-        "google-cloud-bigquery-storage >= 2.0.0, <3.0.0dev",
+        "google-cloud-bigquery-storage >= 2.0.0, <3.0.0",
         # Due to an issue in pip's dependency resolver, the `grpc` extra is not
@@ -64,4 +64,4 @@ # installed, even though `google-cloud-bigquery-storage` specifies it
         # https://github.com/grpc/grpc/pull/15254
-        "grpcio >= 1.47.0, < 2.0dev",
-        "grpcio >= 1.49.1, < 2.0dev; python_version>='3.11'",
+        "grpcio >= 1.47.0, < 2.0.0",
+        "grpcio >= 1.49.1, < 2.0.0; python_version>='3.11'",
         "pyarrow >= 3.0.0",
@@ -114,10 +114,10 @@ ],
     install_requires=[
-        "google-api-core >= 1.31.5, <3.0.0dev,!=2.0.*,!=2.1.*,!=2.2.*,!=2.3.0",
+        "google-api-core >= 1.31.5, <3.0.0,!=2.0.*,!=2.1.*,!=2.2.*,!=2.3.0",
         # NOTE: Maintainers, please do not require google-auth>=2.x.x
         # Until this issue is closed
         # https://github.com/googleapis/google-cloud-python/issues/10566
-        "google-auth>=1.25.0,<3.0.0dev",  # Work around pip wack.
-        "google-cloud-bigquery>=3.3.6,<4.0.0dev",
+        "google-auth>=1.25.0,<3.0.0",  # Work around pip wack.
+        "google-cloud-bigquery>=3.3.6,<4.0.0",
         "packaging",
-        "sqlalchemy>=1.4.16,<3.0.0dev",
+        "sqlalchemy>=1.4.16,<3.0.0",
     ],
@@ -124,0 +124,0 @@ extras_require=extras,

sqlalchemy_bigquery.egg-info/PKG-INFO

 Metadata-Version: 2.1
 Name: sqlalchemy-bigquery
-Version: 1.12.1
+Version: 1.13.0
 Summary: SQLAlchemy dialect for BigQuery
@@ -27,7 +27,7 @@ Home-page: https://github.com/googleapis/python-bigquery-sqlalchemy
 License-File: AUTHORS
-Requires-Dist: google-api-core!=2.0.*,!=2.1.*,!=2.2.*,!=2.3.0,<3.0.0dev,>=1.31.5
-Requires-Dist: google-auth<3.0.0dev,>=1.25.0
-Requires-Dist: google-cloud-bigquery<4.0.0dev,>=3.3.6
+Requires-Dist: google-api-core!=2.0.*,!=2.1.*,!=2.2.*,!=2.3.0,<3.0.0,>=1.31.5
+Requires-Dist: google-auth<3.0.0,>=1.25.0
+Requires-Dist: google-cloud-bigquery<4.0.0,>=3.3.6
 Requires-Dist: packaging
-Requires-Dist: sqlalchemy<3.0.0dev,>=1.4.16
+Requires-Dist: sqlalchemy<3.0.0,>=1.4.16
 Provides-Extra: geography
@@ -42,16 +42,16 @@ Requires-Dist: GeoAlchemy2; extra == "geography"
 Provides-Extra: bqstorage
-Requires-Dist: google-cloud-bigquery-storage<3.0.0dev,>=2.0.0; extra == "bqstorage"
-Requires-Dist: grpcio<2.0dev,>=1.47.0; extra == "bqstorage"
-Requires-Dist: grpcio<2.0dev,>=1.49.1; python_version >= "3.11" and extra == "bqstorage"
+Requires-Dist: google-cloud-bigquery-storage<3.0.0,>=2.0.0; extra == "bqstorage"
+Requires-Dist: grpcio<2.0.0,>=1.47.0; extra == "bqstorage"
+Requires-Dist: grpcio<2.0.0,>=1.49.1; python_version >= "3.11" and extra == "bqstorage"
 Requires-Dist: pyarrow>=3.0.0; extra == "bqstorage"
 Provides-Extra: all
+Requires-Dist: grpcio<2.0.0,>=1.47.0; extra == "all"
 Requires-Dist: GeoAlchemy2; extra == "all"
+Requires-Dist: alembic; extra == "all"
 Requires-Dist: shapely; extra == "all"
-Requires-Dist: grpcio<2.0dev,>=1.47.0; extra == "all"
 Requires-Dist: pytz; extra == "all"
 Requires-Dist: packaging; extra == "all"
+Requires-Dist: google-cloud-bigquery-storage<3.0.0,>=2.0.0; extra == "all"
+Requires-Dist: grpcio<2.0.0,>=1.49.1; python_version >= "3.11" and extra == "all"
 Requires-Dist: pyarrow>=3.0.0; extra == "all"
-Requires-Dist: google-cloud-bigquery-storage<3.0.0dev,>=2.0.0; extra == "all"
-Requires-Dist: alembic; extra == "all"
-Requires-Dist: grpcio<2.0dev,>=1.49.1; python_version >= "3.11" and extra == "all"
 
@@ -58,0 +58,0 @@ SQLAlchemy Dialect for BigQuery

sqlalchemy_bigquery.egg-info/requires.txt

@@ -1,6 +0,6 @@
-google-api-core!=2.0.*,!=2.1.*,!=2.2.*,!=2.3.0,<3.0.0dev,>=1.31.5
-google-auth<3.0.0dev,>=1.25.0
-google-cloud-bigquery<4.0.0dev,>=3.3.6
+google-api-core!=2.0.*,!=2.1.*,!=2.2.*,!=2.3.0,<3.0.0,>=1.31.5
+google-auth<3.0.0,>=1.25.0
+google-cloud-bigquery<4.0.0,>=3.3.6
 packaging
-sqlalchemy<3.0.0dev,>=1.4.16
+sqlalchemy<3.0.0,>=1.4.16
 
@@ -11,21 +11,21 @@ [alembic]
 [all]
+grpcio<2.0.0,>=1.47.0
 GeoAlchemy2
+alembic
 shapely
-grpcio<2.0dev,>=1.47.0
 pytz
 packaging
+google-cloud-bigquery-storage<3.0.0,>=2.0.0
 pyarrow>=3.0.0
-google-cloud-bigquery-storage<3.0.0dev,>=2.0.0
-alembic
 
 [all:python_version >= "3.11"]
-grpcio<2.0dev,>=1.49.1
+grpcio<2.0.0,>=1.49.1
 
 [bqstorage]
-google-cloud-bigquery-storage<3.0.0dev,>=2.0.0
-grpcio<2.0dev,>=1.47.0
+google-cloud-bigquery-storage<3.0.0,>=2.0.0
+grpcio<2.0.0,>=1.47.0
 pyarrow>=3.0.0
 
 [bqstorage:python_version >= "3.11"]
-grpcio<2.0dev,>=1.49.1
+grpcio<2.0.0,>=1.49.1
 
@@ -32,0 +32,0 @@ [geography]

sqlalchemy_bigquery/base.py

@@ -1127,2 +1127,8 @@ # Copyright (c) 2017 The sqlalchemy-bigquery Authors
 
+    def do_execute(self, cursor, statement, parameters, context=None):
+        kwargs = {}
+        if context is not None and context.execution_options.get("job_config"):
+            kwargs["job_config"] = context.execution_options.get("job_config")
+        cursor.execute(statement, parameters, **kwargs)
+
     def create_connect_args(self, url):
@@ -1129,0 +1135,0 @@ (

sqlalchemy_bigquery/version.py

@@ -20,2 +20,2 @@ # Copyright (c) 2021 The sqlalchemy-bigquery Authors
 
-__version__ = "1.12.1"
+__version__ = "1.13.0"

tests/unit/test_sqlalchemy_bigquery.py

@@ -243,1 +243,22 @@ # Copyright 2021 The sqlalchemy-bigquery Authors
     assert not mock_create_bigquery_client.called
+
+
+def test_do_execute():
+    # Ensures the do_execute() method overrides that of the parent class.
+    import sqlalchemy_bigquery  # noqa
+    from sqlalchemy_bigquery.base import BigQueryExecutionContext
+
+    job_config_kwargs = {}
+    job_config_kwargs["use_query_cache"] = False
+    job_config = bigquery.QueryJobConfig(**job_config_kwargs)
+    execution_options = {"job_config": job_config}
+    context = mock.MagicMock(spec=BigQueryExecutionContext)
+    type(context).execution_options = mock.PropertyMock(return_value=execution_options)
+
+    cursor = mock.MagicMock()
+
+    sqlalchemy_bigquery.BigQueryDialect().do_execute(
+        cursor, sqlalchemy.text("SELECT 'a' AS `1`"), mock.MagicMock(), context=context
+    )
+
+    assert cursor.execute.call_args.kwargs["job_config"] is job_config

Alert delta unavailable

Currently unable to show alert delta for PyPI packages.

Improved metrics

Total package byte prevSize

593849

0.17%

Lines of code

9198

0.22%