Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitc1d15f4

Browse files
plamuttswast
andauthored
fix: error using empty array of structs parameter (#474)
* fix: error using empty array of structs parameter* Add QueryParameterType classes* Use query parameter types with ArrayQueryParameter* Adjust system test to changed ArrayQueryParameter* Clarify a comment about an assertionCo-authored-by: Tim Swast <swast@google.com>* Clarify when name/descr. is omitted from API repr* Rename subtypes to fields* Add fields property to StructQueryParameterType* Add a check for empty struct fields* Define scalar SQL parameter types as type objectsCo-authored-by: Tim Swast <swast@google.com>
1 parentcc3394f commitc1d15f4

File tree

5 files changed

+711
-15
lines changed

5 files changed

+711
-15
lines changed

‎google/cloud/bigquery/__init__.py‎

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -66,8 +66,11 @@
6666
fromgoogle.cloud.bigquery.modelimportModel
6767
fromgoogle.cloud.bigquery.modelimportModelReference
6868
fromgoogle.cloud.bigquery.queryimportArrayQueryParameter
69+
fromgoogle.cloud.bigquery.queryimportArrayQueryParameterType
6970
fromgoogle.cloud.bigquery.queryimportScalarQueryParameter
71+
fromgoogle.cloud.bigquery.queryimportScalarQueryParameterType
7072
fromgoogle.cloud.bigquery.queryimportStructQueryParameter
73+
fromgoogle.cloud.bigquery.queryimportStructQueryParameterType
7174
fromgoogle.cloud.bigquery.queryimportUDFResource
7275
fromgoogle.cloud.bigquery.retryimportDEFAULT_RETRY
7376
fromgoogle.cloud.bigquery.routineimportDeterminismLevel
@@ -93,6 +96,9 @@
9396
"ArrayQueryParameter",
9497
"ScalarQueryParameter",
9598
"StructQueryParameter",
99+
"ArrayQueryParameterType",
100+
"ScalarQueryParameterType",
101+
"StructQueryParameterType",
96102
# Datasets
97103
"Dataset",
98104
"DatasetReference",

‎google/cloud/bigquery/enums.py‎

Lines changed: 21 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -18,6 +18,7 @@
1818
importitertools
1919

2020
fromgoogle.cloud.bigquery_v2importtypesasgapic_types
21+
fromgoogle.cloud.bigquery.queryimportScalarQueryParameterType
2122

2223

2324
classCompression(object):
@@ -215,6 +216,26 @@ class SqlTypeNames(str, enum.Enum):
215216
DATETIME="DATETIME"
216217

217218

219+
classSqlParameterScalarTypes:
220+
"""Supported scalar SQL query parameter types as type objects."""
221+
222+
STRING=ScalarQueryParameterType("STRING")
223+
BYTES=ScalarQueryParameterType("BYTES")
224+
INTEGER=ScalarQueryParameterType("INT64")
225+
INT64=ScalarQueryParameterType("INT64")
226+
FLOAT=ScalarQueryParameterType("FLOAT64")
227+
FLOAT64=ScalarQueryParameterType("FLOAT64")
228+
NUMERIC=ScalarQueryParameterType("NUMERIC")
229+
BIGNUMERIC=ScalarQueryParameterType("BIGNUMERIC")
230+
BOOLEAN=ScalarQueryParameterType("BOOL")
231+
BOOL=ScalarQueryParameterType("BOOL")
232+
GEOGRAPHY=ScalarQueryParameterType("GEOGRAPHY")
233+
TIMESTAMP=ScalarQueryParameterType("TIMESTAMP")
234+
DATE=ScalarQueryParameterType("DATE")
235+
TIME=ScalarQueryParameterType("TIME")
236+
DATETIME=ScalarQueryParameterType("DATETIME")
237+
238+
218239
classWriteDisposition(object):
219240
"""Specifies the action that occurs if destination table already exists.
220241

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp