Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We鈥檒l occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

feat: support RANGE query parameters #1827

Merged
merged 14 commits into from
Mar 4, 2024
Merged

feat: support RANGE query parameters #1827

Show file tree
Hide file tree
Changes from 1 commit
Commits
Show all changes
14 commits
Select commit Hold shift + click to select a range
51cd069
feat: RANGE query parameters and unit tests
Linchin Feb 23, 2024
adf7150
unit test
Linchin Feb 23, 2024
094e47c
unit test coverage
Linchin Feb 24, 2024
ac0e042
lint
Linchin Feb 24, 2024
cb6ed75
lint
Linchin Feb 24, 2024
c154622
lint
Linchin Feb 24, 2024
36529b5
system test
Linchin Feb 24, 2024
5f8d7a8
fix system test
Linchin Feb 24, 2024
9beb7ec
ajust init items order
Linchin Feb 26, 2024
5a4c783
Merge branch 'main' into range-query-params
Linchin Feb 27, 2024
1d20a5e
Merge branch 'main' into range-query-params
Linchin Feb 27, 2024
f7994be
Merge branch 'main' into range-query-params
Linchin Feb 29, 2024
7b6fc41
fix typos and improve docstrings
Linchin Feb 29, 2024
9c3907b
Merge branch 'main' into range-query-params
Linchin Mar 4, 2024
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Jump to
Jump to file
Failed to load files.
Diff view
Diff view
Prev Previous commit
Next Next commit
unit test coverage
  • Loading branch information
@Linchin
Linchin committed Feb 24, 2024
commit 094e47ca23bd3d74d390d666f9fc64e127ed07d5
6 changes: 3 additions & 3 deletions google/cloud/bigquery/query.py
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -994,9 +994,9 @@ def _serialize_range_element_value(self, value, type_):
return converter(value) # type: ignore
else:
raise ValueError(
f"Cannot covert range element value {type(value)}:{value}, "
"must be a datetime.datetime or datetime.date object, or "
"a string."
f"Cannot covert range element value from type {type_}, "
Linchin marked this conversation as resolved.
Show resolved Hide resolved
"must be one of the strings 'TIMESTAMP', 'DATE' "
"'DATETIME' or a RangeQueryParameterType object."
)

def __init__(
Expand Down
6 changes: 4 additions & 2 deletions tests/unit/test_query.py
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -1144,8 +1144,10 @@ def test_to_api_repr_wo_values(self):
self.assertEqual(param.to_api_repr(), EXPECTED)

def test_to_api_repr_unsupported_value_type(self):
with self.assertRaises(ValueError):
self._make_one(range_element_type="LONGSTRING")
with self.assertRaisesRegex(ValueError, "Cannot covert range element value from type"):
range_param = self._make_one(range_element_type="DATE", start = datetime.date.today())
range_param.range_element_type.type_._type = "LONG"
range_param.to_api_repr()

def test___eq__(self):
param = self._make_one(range_element_type="DATE", start="2016-08-11", name="foo")
Expand Down