@Override public void run(BigQuery bigquery, TableId tableId) { for (FieldValueList row : bigquery.listTableData(tableId).iterateAll()) { System.out.println(row); } } }
/** * Returns the paginated list rows in this table. * * <p>Example of listing rows in the table. * * <pre>{@code * // This example reads the result 100 rows per RPC call. If there's no need to limit the number, * // simply omit the option. * Page<FieldValueList> page = table.list(TableDataListOption.pageSize(100)); * for (FieldValueList row : page.iterateAll()) { * // do something with the row * } * }</pre> * * @param options table data list options * @throws BigQueryException upon failure */ public TableResult list(TableDataListOption... options) throws BigQueryException { return bigquery.listTableData(getTableId(), options); }
/** * Returns the paginated list rows in this table. * * <p>Example of listing rows in the table given a schema. * * <pre>{@code * Schema schema = ...; * String field = "my_field"; * Page<FieldValueList> page = table.list(schema); * for (FieldValueList row : page.iterateAll()) { * row.get(field); * } * }</pre> * * @param options table data list options * @throws BigQueryException upon failure */ public TableResult list(Schema schema, TableDataListOption... options) throws BigQueryException { return bigquery.listTableData(getTableId(), schema, options); }
/** Example of listing table rows with schema. */ // [TARGET listTableData(String, String, Schema, TableDataListOption...)] // [VARIABLE "my_dataset_name"] // [VARIABLE "my_table_name"] // [VARIABLE ...] // [VARIABLE "field"] public TableResult listTableDataSchema( String datasetName, String tableName, Schema schema, String field) { // [START ] TableResult tableData = bigquery.listTableData(datasetName, tableName, schema); for (FieldValueList row : tableData.iterateAll()) { row.get(field); } // [END ] return tableData; }
/** Example of listing table rows, specifying the page size. */ // [TARGET listTableData(String, String, TableDataListOption...)] // [VARIABLE "my_dataset_name"] // [VARIABLE "my_table_name"] public TableResult listTableData(String datasetName, String tableName) { // [START ] // This example reads the result 100 rows per RPC call. If there's no need to limit the number, // simply omit the option. TableResult tableData = bigquery.listTableData(datasetName, tableName, TableDataListOption.pageSize(100)); for (FieldValueList row : tableData.iterateAll()) { // do something with the row } // [END ] return tableData; }
/** Example of listing table rows, specifying the page size. */ // [TARGET listTableData(TableId, TableDataListOption...)] // [VARIABLE "my_dataset_name"] // [VARIABLE "my_table_name"] public TableResult listTableDataFromId(String datasetName, String tableName) { // [START bigquery_browse_table] TableId tableIdObject = TableId.of(datasetName, tableName); // This example reads the result 100 rows per RPC call. If there's no need to limit the number, // simply omit the option. TableResult tableData = bigquery.listTableData(tableIdObject, TableDataListOption.pageSize(100)); for (FieldValueList row : tableData.iterateAll()) { // do something with the row } // [END bigquery_browse_table] return tableData; }
/** Example of listing table rows with schema. */ // [TARGET listTableData(TableId, Schema, TableDataListOption...)] public FieldValueList listTableDataSchemaId() { // [START ] Schema schema = Schema.of( Field.of("word", LegacySQLTypeName.STRING), Field.of("word_count", LegacySQLTypeName.STRING), Field.of("corpus", LegacySQLTypeName.STRING), Field.of("corpus_date", LegacySQLTypeName.STRING)); TableResult tableData = bigquery.listTableData( TableId.of("bigquery-public-data", "samples", "shakespeare"), schema); FieldValueList row = tableData.getValues().iterator().next(); System.out.println(row.get("word").getStringValue()); // [END ] return row; }
@Test public void testList() throws Exception { Page<FieldValueList> page = new PageImpl<>(null, "c", ROWS); initializeExpectedTable(1); expect(bigquery.getOptions()).andReturn(mockOptions); expect(bigquery.listTableData(TABLE_ID1)).andReturn(new TableResult(null, ROWS.size(), page)); expect(bigquery.listTableData(TABLE_ID1, SCHEMA)) .andReturn(new TableResult(SCHEMA, ROWS.size(), page)); replay(bigquery); initializeTable(); Page<FieldValueList> dataPage = table.list(); assertThat(dataPage.getValues()).containsExactlyElementsIn(ROWS).inOrder(); dataPage = table.list(SCHEMA); assertThat(dataPage.getValues()).containsExactlyElementsIn(ROWS_WITH_SCHEMA).inOrder(); }
@Test public void testListTableData() { EasyMock.expect(bigqueryRpcMock.listTableData(PROJECT, DATASET, TABLE, EMPTY_RPC_OPTIONS)) .andReturn(TABLE_DATA_PB); EasyMock.replay(bigqueryRpcMock); bigquery = options.getService(); Page<FieldValueList> page = bigquery.listTableData(DATASET, TABLE); assertEquals(CURSOR, page.getNextPageToken()); assertArrayEquals(TABLE_DATA.toArray(), Iterables.toArray(page.getValues(), List.class)); }
@Test public void testListTableDataFromTableId() { EasyMock.expect(bigqueryRpcMock.listTableData(PROJECT, DATASET, TABLE, EMPTY_RPC_OPTIONS)) .andReturn(TABLE_DATA_PB); EasyMock.replay(bigqueryRpcMock); bigquery = options.getService(); Page<FieldValueList> page = bigquery.listTableData(TableId.of(DATASET, TABLE)); assertEquals(CURSOR, page.getNextPageToken()); assertArrayEquals(TABLE_DATA.toArray(), Iterables.toArray(page.getValues(), List.class)); }
@Test public void testListWithOptions() throws Exception { Page<FieldValueList> page = new PageImpl<>(null, "c", ROWS); initializeExpectedTable(1); expect(bigquery.getOptions()).andReturn(mockOptions); expect(bigquery.listTableData(TABLE_ID1, BigQuery.TableDataListOption.pageSize(10L))) .andReturn(new TableResult(null, ROWS.size(), page)); expect(bigquery.listTableData(TABLE_ID1, SCHEMA, BigQuery.TableDataListOption.pageSize(10L))) .andReturn(new TableResult(SCHEMA, ROWS.size(), page)); replay(bigquery); initializeTable(); Page<FieldValueList> dataPage = table.list(BigQuery.TableDataListOption.pageSize(10L)); assertThat(dataPage.getValues()).containsExactlyElementsIn(ROWS).inOrder(); dataPage = table.list(SCHEMA, BigQuery.TableDataListOption.pageSize(10L)); assertThat(dataPage.getValues()).containsExactlyElementsIn(ROWS_WITH_SCHEMA).inOrder(); }
@Test public void testListTableDataWithOptions() { EasyMock.expect(bigqueryRpcMock.listTableData(PROJECT, DATASET, TABLE, TABLE_DATA_LIST_OPTIONS)) .andReturn(TABLE_DATA_PB); EasyMock.replay(bigqueryRpcMock); bigquery = options.getService(); Page<FieldValueList> page = bigquery.listTableData( DATASET, TABLE, TABLE_DATA_LIST_PAGE_SIZE, TABLE_DATA_LIST_PAGE_TOKEN, TABLE_DATA_LIST_START_INDEX); assertEquals(CURSOR, page.getNextPageToken()); assertArrayEquals(TABLE_DATA.toArray(), Iterables.toArray(page.getValues(), List.class)); }
@Test public void testListTableDataFromTableIdWithProject() { TableId tableId = TABLE_ID.setProjectId(OTHER_PROJECT); EasyMock.expect(bigqueryRpcMock.listTableData(OTHER_PROJECT, DATASET, TABLE, EMPTY_RPC_OPTIONS)) .andReturn(TABLE_DATA_PB); EasyMock.replay(bigqueryRpcMock); BigQueryOptions bigQueryOptions = createBigQueryOptionsForProject(OTHER_PROJECT, rpcFactoryMock); bigquery = bigQueryOptions.getService(); Page<FieldValueList> page = bigquery.listTableData(tableId); assertEquals(CURSOR, page.getNextPageToken()); assertArrayEquals(TABLE_DATA.toArray(), Iterables.toArray(page.getValues(), List.class)); }
return bigquery.listTableData( table, response.getSchema(), listOptions.toArray(new TableDataListOption[0]));
expect(bigquery.getQueryResults(jobInfo.getJobId(), Job.DEFAULT_QUERY_WAIT_OPTIONS)) .andReturn(completedQuery); expect(bigquery.listTableData(eq(TABLE_ID1), anyObject(Schema.class))).andReturn(result);
assertNull(jobConfiguration.getSourceUris()); assertNull(job.getStatus().getError()); Page<FieldValueList> rows = bigquery.listTableData(tableId); int rowCount = 0; for (FieldValueList row : rows.getValues()) {
@Test public void testListAllTableData() { Page<FieldValueList> rows = bigquery.listTableData(TABLE_ID); int rowCount = 0; for (FieldValueList row : rows.getValues()) {
/** * Returns the paginated list rows in this table. * * @param options table data list options * @throws BigQueryException upon failure */ public Page<List<FieldValue>> list(BigQuery.TableDataListOption... options) throws BigQueryException { return bigquery.listTableData(tableId(), options); }
/** * Returns the paginated list rows in this table. * * <p>Example of listing rows in the table given a schema. * * <pre>{@code * Schema schema = ...; * String field = "my_field"; * Page<FieldValueList> page = table.list(schema); * for (FieldValueList row : page.iterateAll()) { * row.get(field); * } * }</pre> * * @param options table data list options * @throws BigQueryException upon failure */ public TableResult list(Schema schema, TableDataListOption... options) throws BigQueryException { return bigquery.listTableData(getTableId(), schema, options); }
/** * Returns the paginated list rows in this table. * * <p>Example of listing rows in the table. * * <pre>{@code * // This example reads the result 100 rows per RPC call. If there's no need to limit the number, * // simply omit the option. * Page<FieldValueList> page = table.list(TableDataListOption.pageSize(100)); * for (FieldValueList row : page.iterateAll()) { * // do something with the row * } * }</pre> * * @param options table data list options * @throws BigQueryException upon failure */ public TableResult list(TableDataListOption... options) throws BigQueryException { return bigquery.listTableData(getTableId(), options); }