def test_async_query(cloud_config, capsys):
query = "SELECT corpus FROM publicdata:samples.shakespeare " "GROUP BY corpus;"
main(
project_id=cloud_config.project, query_string=query, batch=False, num_retries=5, interval=1, use_legacy_sql=True
)
out, _ = capsys.readouterr()
value = out.strip().split("\n").pop()
assert json.loads(value) is not None
def test_async_query(cloud_config, capsys):
query = ('SELECT corpus FROM publicdata:samples.shakespeare '
'GROUP BY corpus;')
main(project_id=cloud_config.project,
query_string=query,
batch=False,
num_retries=5,
interval=1)
out, _ = capsys.readouterr()
value = out.strip().split('\n').pop()
assert json.loads(value) is not None
def test_async_query_standard_sql(cloud_config, capsys):
query = 'SELECT [1, 2, 3] AS arr;' # Only valid in standard SQL
main(project_id=cloud_config.project,
query_string=query,
batch=False,
num_retries=5,
interval=1,
use_legacy_sql=False)
out, _ = capsys.readouterr()
value = out.strip().split('\n').pop()
assert json.loads(value) is not None
def test_async_query_standard_sql(cloud_config, capsys):
query = 'SELECT [1, 2, 3] AS arr;' # Only valid in standard SQL
main(
project_id=cloud_config.project,
query_string=query,
batch=False,
num_retries=5,
interval=1,
use_legacy_sql=False)
out, _ = capsys.readouterr()
value = out.strip().split('\n').pop()
assert json.loads(value) is not None
def test_async_query(cloud_config, capsys):
query = (
'SELECT corpus FROM publicdata:samples.shakespeare '
'GROUP BY corpus;')
main(
project_id=cloud_config.GCLOUD_PROJECT,
query_string=query,
batch=False,
num_retries=5,
interval=1)
out, _ = capsys.readouterr()
value = out.strip().split('\n').pop()
assert json.loads(value) is not None
