def test_project_is_pulled_from_creds_and_can_be_overriden_at_anytime(
self, monkeypatch):
task = BigQueryStreamingInsert(dataset_id="id", table="table")
task_proj = BigQueryStreamingInsert(dataset_id="id",
table="table",
project="test-init")
client = MagicMock()
service_account_info = MagicMock(return_value=MagicMock(
project_id="default"))
monkeypatch.setattr(
"prefect.tasks.google.bigquery.Credentials",
MagicMock(from_service_account_info=service_account_info),
)
monkeypatch.setattr("prefect.tasks.google.bigquery.bigquery.Client",
client)
with set_temporary_config({"cloud.use_local_secrets": True}):
with prefect.context(secrets=dict(
GOOGLE_APPLICATION_CREDENTIALS={})):
task.run(records=[])
task_proj.run(records=[])
task_proj.run(records=[], project="run-time")
x, y, z = client.call_args_list
assert x[1]["project"] == "default" ## pulled from credentials
assert y[1]["project"] == "test-init" ## pulled from init
assert z[1]["project"] == "run-time" ## pulled from run kwarg
def test_dataset_dest_and_table_dest_are_required_together_eventually(
self, attr):
task = BigQueryStreamingInsert(**{attr: "some-value"})
with pytest.raises(ValueError) as exc:
task.run(records=[])
assert attr in str(exc.value)
assert "must be provided" in str(exc.value)
def test_creds_are_pulled_from_secret_at_runtime(self, monkeypatch):
task = BigQueryStreamingInsert(dataset_id="id", table="table")
creds_loader = MagicMock()
monkeypatch.setattr("prefect.tasks.google.bigquery.Credentials", creds_loader)
monkeypatch.setattr(
"prefect.tasks.google.bigquery.bigquery.Client", MagicMock()
)
with set_temporary_config({"cloud.use_local_secrets": True}):
with prefect.context(secrets=dict(GOOGLE_APPLICATION_CREDENTIALS=42)):
task.run(records=[])
assert creds_loader.from_service_account_info.call_args[0][0] == 42
def test_additional_kwargs_passed_upstream(self):
task = BigQueryStreamingInsert(name="test-task",
checkpoint=True,
tags=["bob"])
assert task.name == "test-task"
assert task.checkpoint is True
assert task.tags == {"bob"}
def test_initializes_with_nothing_and_sets_defaults(self):
task = BigQueryStreamingInsert()
assert task.project is None
assert task.location == "US"
assert task.credentials_secret == "GOOGLE_APPLICATION_CREDENTIALS"
assert task.dataset_id is None
assert task.table is None
def test_creds_secret_name_can_be_overwritten_at_anytime(self, monkeypatch):
task = BigQueryStreamingInsert(
dataset_id="id", table="table", credentials_secret="TEST"
)
creds_loader = MagicMock()
monkeypatch.setattr("prefect.tasks.google.bigquery.Credentials", creds_loader)
monkeypatch.setattr(
"prefect.tasks.google.bigquery.bigquery.Client", MagicMock()
)
with set_temporary_config({"cloud.use_local_secrets": True}):
with prefect.context(secrets=dict(TEST="42", RUN={})):
task.run(records=[])
task.run(records=[], credentials_secret="RUN")
first_call, second_call = creds_loader.from_service_account_info.call_args_list
assert first_call[0][0] == "42"
assert second_call[0][0] == {}
def test_initializes_attr_from_kwargs(self, attr):
task = BigQueryStreamingInsert(**{attr: "my-value"})
assert getattr(task, attr) == "my-value"
