/** Example of deleting a table. */ // [TARGET delete(String, String)] // [VARIABLE "my_dataset_name"] // [VARIABLE "my_table_name"] public boolean deleteTable(String datasetName, String tableName) { // [START ] boolean deleted = bigquery.delete(datasetName, tableName); if (deleted) { // the table was deleted } else { // the table was not found } // [END ] return deleted; }
@Override public void run(BigQuery bigquery, DatasetId datasetId) { if (bigquery.delete(datasetId)) { System.out.println("Dataset " + datasetId + " was deleted"); } else { System.out.println("Dataset " + datasetId + " not found"); } } }
@Override public void run(BigQuery bigquery, TableId tableId) { if (bigquery.delete(tableId)) { System.out.println("Table " + tableId + " was deleted"); } else { System.out.println("Table " + tableId + " not found"); } } }
/** * Deletes a dataset, even if non-empty. * * @param bigquery the BigQuery service to be used to issue the delete request * @param dataset the dataset to be deleted * @return {@code true} if deletion succeeded, {@code false} if the dataset was not found * @throws BigQueryException upon failure */ public static boolean forceDelete(BigQuery bigquery, String dataset) { return bigquery.delete(dataset, BigQuery.DatasetDeleteOption.deleteContents()); }
/** Example of deleting a dataset from its id, even if non-empty. */ // [TARGET delete(String, DatasetDeleteOption...)] // [VARIABLE "my_dataset_name"] public boolean deleteDataset(String datasetName) { // [START ] boolean deleted = bigquery.delete(datasetName, DatasetDeleteOption.deleteContents()); if (deleted) { // the dataset was deleted } else { // the dataset was not found } // [END ] return deleted; }
/** Example of deleting a dataset, even if non-empty. */ // [TARGET delete(DatasetId, DatasetDeleteOption...)] // [VARIABLE "my_project_id"] // [VARIABLE "my_dataset_name"] public boolean deleteDatasetFromId(String projectId, String datasetName) { // [START bigquery_delete_dataset] DatasetId datasetId = DatasetId.of(projectId, datasetName); boolean deleted = bigquery.delete(datasetId, DatasetDeleteOption.deleteContents()); if (deleted) { // the dataset was deleted } else { // the dataset was not found } // [END bigquery_delete_dataset] return deleted; }
@Test public void testForceDelete() throws InterruptedException, ExecutionException { BigQuery bigqueryMock = EasyMock.createMock(BigQuery.class); EasyMock.expect(bigqueryMock.delete(DATASET_NAME, DatasetDeleteOption.deleteContents())) .andReturn(true); EasyMock.replay(bigqueryMock); assertTrue(RemoteBigQueryHelper.forceDelete(bigqueryMock, DATASET_NAME)); EasyMock.verify(bigqueryMock); }
@Test public void testDeleteNonExistingTable() { assertFalse(bigquery.delete(DATASET, "test_delete_non_existing_table")); }
@Test public void testDeleteDataset() { EasyMock.expect(bigqueryRpcMock.deleteDataset(PROJECT, DATASET, EMPTY_RPC_OPTIONS)) .andReturn(true); EasyMock.replay(bigqueryRpcMock); bigquery = options.getService(); assertTrue(bigquery.delete(DATASET)); }
@Test public void testDeleteDatasetWithOptions() { EasyMock.expect(bigqueryRpcMock.deleteDataset(PROJECT, DATASET, DATASET_DELETE_OPTIONS)) .andReturn(true); EasyMock.replay(bigqueryRpcMock); bigquery = options.getService(); assertTrue(bigquery.delete(DATASET, DATASET_DELETE_CONTENTS)); }
@Test public void testDeleteTable() { EasyMock.expect(bigqueryRpcMock.deleteTable(PROJECT, DATASET, TABLE)).andReturn(true); EasyMock.replay(bigqueryRpcMock); bigquery = options.getService(); assertTrue(bigquery.delete(DATASET, TABLE)); }
@Test public void testDeleteTableFromTableId() { EasyMock.expect(bigqueryRpcMock.deleteTable(PROJECT, DATASET, TABLE)).andReturn(true); EasyMock.replay(bigqueryRpcMock); bigquery = options.getService(); assertTrue(bigquery.delete(TABLE_ID)); }
@Test public void testDeleteDatasetFromDatasetIdWithProject() { DatasetId datasetId = DatasetId.of(OTHER_PROJECT, DATASET); EasyMock.expect(bigqueryRpcMock.deleteDataset(OTHER_PROJECT, DATASET, EMPTY_RPC_OPTIONS)) .andReturn(true); EasyMock.replay(bigqueryRpcMock); bigquery = options.getService(); assertTrue(bigquery.delete(datasetId)); }
@Test public void testDeleteDatasetFromDatasetId() { EasyMock.expect(bigqueryRpcMock.deleteDataset(PROJECT, DATASET, EMPTY_RPC_OPTIONS)) .andReturn(true); EasyMock.replay(bigqueryRpcMock); bigquery = options.getService(); assertTrue(bigquery.delete(DatasetId.of(DATASET))); }
@Test public void testDeleteFalse() { initializeExpectedTable(1); expect(bigquery.getOptions()).andReturn(mockOptions); expect(bigquery.delete(TABLE_INFO.getTableId())).andReturn(false); replay(bigquery); initializeTable(); assertFalse(table.delete()); }
@Test public void testDeleteTrue() { initializeExpectedDataset(1); expect(bigquery.getOptions()).andReturn(mockOptions); expect(bigquery.delete(DATASET_INFO.getDatasetId())).andReturn(true); replay(bigquery); initializeDataset(); assertTrue(dataset.delete()); }
@Test public void testDeleteFalse() { initializeExpectedDataset(1); expect(bigquery.getOptions()).andReturn(mockOptions); expect(bigquery.delete(DATASET_INFO.getDatasetId())).andReturn(false); replay(bigquery); initializeDataset(); assertFalse(dataset.delete()); }
@Test public void testDeleteTrue() { initializeExpectedTable(1); expect(bigquery.getOptions()).andReturn(mockOptions); expect(bigquery.delete(TABLE_INFO.getTableId())).andReturn(true); replay(bigquery); initializeTable(); assertTrue(table.delete()); }
@Test public void testDeleteTableFromTableIdWithProject() { TableId tableId = TABLE_ID.setProjectId(OTHER_PROJECT); EasyMock.expect(bigqueryRpcMock.deleteTable(OTHER_PROJECT, DATASET, TABLE)).andReturn(true); EasyMock.replay(bigqueryRpcMock); BigQueryOptions bigQueryOptions = createBigQueryOptionsForProject(OTHER_PROJECT, rpcFactoryMock); bigquery = bigQueryOptions.getService(); assertTrue(bigquery.delete(tableId)); }
@Test public void testDeleteTableFromTableIdWithoutProject() { TableId tableId = TableId.of("", TABLE_ID.getDataset(), TABLE_ID.getTable()); EasyMock.expect(bigqueryRpcMock.deleteTable(PROJECT, DATASET, TABLE)).andReturn(true); EasyMock.replay(bigqueryRpcMock); BigQueryOptions bigQueryOptions = createBigQueryOptionsForProject(PROJECT, rpcFactoryMock); bigquery = bigQueryOptions.getService(); assertTrue(bigquery.delete(tableId)); }