def test_database_create_with_pre_existing_db(self, mock_hook): mock_hook.return_value.get_database.return_value = {"name": DB_ID} op = CloudSpannerInstanceDatabaseDeployOperator( project_id=PROJECT_ID, instance_id=INSTANCE_ID, database_id=DB_ID, ddl_statements=DDL_STATEMENTS, task_id="id") result = op.execute(None) mock_hook.assert_called_once_with(gcp_conn_id="google_cloud_default") mock_hook.return_value.create_database.assert_not_called() mock_hook.return_value.update_database.assert_not_called() self.assertTrue(result)
def test_database_create_ex_if_param_missing(self, project_id, instance_id, database_id, ddl_statements, exp_msg, mock_hook): with self.assertRaises(AirflowException) as cm: CloudSpannerInstanceDatabaseDeployOperator( project_id=project_id, instance_id=instance_id, database_id=database_id, ddl_statements=ddl_statements, task_id="id") err = cm.exception self.assertIn("The required parameter '{}' is empty".format(exp_msg), str(err)) mock_hook.assert_not_called()
display_name=GCP_SPANNER_DISPLAY_NAME, task_id='spanner_instance_create_task') spanner_instance_update_task = CloudSpannerInstanceDeployOperator( instance_id=GCP_SPANNER_INSTANCE_ID, configuration_name=GCP_SPANNER_CONFIG_NAME, node_count=int(GCP_SPANNER_NODE_COUNT) + 1, display_name=GCP_SPANNER_DISPLAY_NAME + '_updated', task_id='spanner_instance_update_task') # [END howto_operator_spanner_deploy] # [START howto_operator_spanner_database_deploy] spanner_database_deploy_task = CloudSpannerInstanceDatabaseDeployOperator( project_id=GCP_PROJECT_ID, instance_id=GCP_SPANNER_INSTANCE_ID, database_id=GCP_SPANNER_DATABASE_ID, ddl_statements=[ "CREATE TABLE my_table1 (id INT64, name STRING(MAX)) PRIMARY KEY (id)", "CREATE TABLE my_table2 (id INT64, name STRING(MAX)) PRIMARY KEY (id)", ], task_id='spanner_database_deploy_task') spanner_database_deploy_task2 = CloudSpannerInstanceDatabaseDeployOperator( instance_id=GCP_SPANNER_INSTANCE_ID, database_id=GCP_SPANNER_DATABASE_ID, ddl_statements=[ "CREATE TABLE my_table1 (id INT64, name STRING(MAX)) PRIMARY KEY (id)", "CREATE TABLE my_table2 (id INT64, name STRING(MAX)) PRIMARY KEY (id)", ], task_id='spanner_database_deploy_task2') # [END howto_operator_spanner_database_deploy] # [START howto_operator_spanner_database_update]