Add BigQuery delete dataset sample (GoogleCloudPlatform#1758)

stephaniewang526 · kurtisvg · commit 1a09f63d10f7 · 2019-11-27T08:57:14.000-08:00
* bigquery_delete_dataset sample

* update sample based on comments

* update sample based on comments - more meaningful print output

* fix lint error
diff --git a/bigquery/cloud-client/src/main/java/com/example/bigquery/DeleteDataset.java b/bigquery/cloud-client/src/main/java/com/example/bigquery/DeleteDataset.java
@@ -0,0 +1,48 @@
+/*
+ * Copyright 2019 Google LLC
+ *
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package com.example.bigquery;
+
+// [START bigquery_delete_dataset]
+import com.google.cloud.bigquery.BigQuery;
+import com.google.cloud.bigquery.BigQuery.DatasetDeleteOption;
+import com.google.cloud.bigquery.BigQueryOptions;
+import com.google.cloud.bigquery.DatasetId;
+
+public class DeleteDataset {
+
+  public static void runDeleteDataset() {
+    // TODO(developer): Replace these variables before running the sample.\
+    String projectId = "my-project-id";
+    String datasetName = "my-dataset-name";
+    deleteDataset(projectId, datasetName);
+  }
+
+  public static void deleteDataset(String projectId, String datasetName) {
+    // Initialize client that will be used to send requests. This client only needs to be created
+    // once, and can be reused for multiple requests.
+    BigQuery bigquery = BigQueryOptions.getDefaultInstance().getService();
+
+    DatasetId datasetId = DatasetId.of(projectId, datasetName);
+    boolean success = bigquery.delete(datasetId, DatasetDeleteOption.deleteContents());
+    if (success) {
+      System.out.println("Dataset deleted successfully");
+    } else {
+      System.out.println("Dataset was not found");
+    }
+  }
+}
+// [END bigquery_delete_dataset]
diff --git a/bigquery/cloud-client/src/test/java/com/example/bigquery/DeleteDatasetIT.java b/bigquery/cloud-client/src/test/java/com/example/bigquery/DeleteDatasetIT.java
@@ -0,0 +1,63 @@
+/*
+ * Copyright 2019 Google LLC
+ *
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package com.example.bigquery;
+
+import static com.google.common.truth.Truth.assertThat;
+
+import com.google.cloud.bigquery.BigQuery;
+import com.google.cloud.bigquery.BigQueryOptions;
+import com.google.cloud.bigquery.DatasetId;
+import com.google.cloud.bigquery.DatasetInfo;
+import com.google.cloud.bigquery.testing.RemoteBigQueryHelper;
+import java.io.ByteArrayOutputStream;
+import java.io.PrintStream;
+import org.junit.After;
+import org.junit.Before;
+import org.junit.Test;
+
+public class DeleteDatasetIT {
+  private ByteArrayOutputStream bout;
+  private PrintStream out;
+
+  @Before
+  public void setUp() {
+    bout = new ByteArrayOutputStream();
+    out = new PrintStream(bout);
+    System.setOut(out);
+  }
+
+  @After
+  public void tearDown() {
+    System.setOut(null);
+  }
+
+  @Test
+  public void deleteDataset() {
+    BigQuery bigquery = BigQueryOptions.getDefaultInstance().getService();
+
+    //create the dataset to be deleted
+    String generatedDatasetName = RemoteBigQueryHelper.generateDatasetName();
+    DatasetInfo datasetInfo = DatasetInfo.newBuilder(generatedDatasetName).build();
+    bigquery.create(datasetInfo);
+
+    //delete the dataset that was just created
+    DatasetId datasetId = DatasetId.of(bigquery.getOptions().getProjectId(), generatedDatasetName);
+    DeleteDataset.deleteDataset(datasetId.getProject(), generatedDatasetName);
+
+    assertThat(bout.toString()).contains("Dataset deleted successfully");
+  }
+}
