@Override public void run(BigQuery bigquery, Void arg) { for (Job job : bigquery.listJobs().iterateAll()) { System.out.println(job); } } }
/** Example of listing jobs, specifying the page size. */ // [TARGET listJobs(JobListOption...)] public Page<Job> listJobs() { // [START bigquery_list_jobs] Page<Job> jobs = bigquery.listJobs(JobListOption.pageSize(100)); for (Job job : jobs.iterateAll()) { // do something with the job } // [END bigquery_list_jobs] return jobs; }
@Test public void testListJobs() { bigquery = options.getService(); ImmutableList<Job> jobList = ImmutableList.of( new Job(bigquery, new JobInfo.BuilderImpl(COMPLETE_QUERY_JOB)), new Job(bigquery, new JobInfo.BuilderImpl(COMPLETE_LOAD_JOB))); Tuple<String, Iterable<com.google.api.services.bigquery.model.Job>> result = Tuple.of( CURSOR, Iterables.transform( jobList, new Function<Job, com.google.api.services.bigquery.model.Job>() { @Override public com.google.api.services.bigquery.model.Job apply(Job job) { return job.toPb(); } })); EasyMock.expect(bigqueryRpcMock.listJobs(PROJECT, EMPTY_RPC_OPTIONS)).andReturn(result); EasyMock.replay(bigqueryRpcMock); Page<Job> page = bigquery.listJobs(); assertEquals(CURSOR, page.getNextPageToken()); assertArrayEquals(jobList.toArray(), Iterables.toArray(page.getValues(), Job.class)); }
@Test public void testListJobsWithOptions() { bigquery = options.getService(); ImmutableList<Job> jobList = ImmutableList.of( new Job(bigquery, new JobInfo.BuilderImpl(COMPLETE_QUERY_JOB)), new Job(bigquery, new JobInfo.BuilderImpl(COMPLETE_LOAD_JOB))); Tuple<String, Iterable<com.google.api.services.bigquery.model.Job>> result = Tuple.of( CURSOR, Iterables.transform( jobList, new Function<Job, com.google.api.services.bigquery.model.Job>() { @Override public com.google.api.services.bigquery.model.Job apply(Job job) { return job.toPb(); } })); EasyMock.expect(bigqueryRpcMock.listJobs(PROJECT, JOB_LIST_OPTIONS)).andReturn(result); EasyMock.replay(bigqueryRpcMock); Page<Job> page = bigquery.listJobs( JOB_LIST_ALL_USERS, JOB_LIST_STATE_FILTER, JOB_LIST_PAGE_TOKEN, JOB_LIST_PAGE_SIZE); assertEquals(CURSOR, page.getNextPageToken()); assertArrayEquals(jobList.toArray(), Iterables.toArray(page.getValues(), Job.class)); }
.andReturn(result); EasyMock.replay(bigqueryRpcMock); Page<Job> page = bigquery.listJobs(JOB_LIST_OPTION_FIELD); assertEquals(CURSOR, page.getNextPageToken()); assertArrayEquals(jobList.toArray(), Iterables.toArray(page.getValues(), Job.class));
@Test public void testListJobs() { Page<Job> jobs = bigquery.listJobs(); for (Job job : jobs.getValues()) { assertNotNull(job.getJobId()); assertNotNull(job.getStatistics()); assertNotNull(job.getStatus()); assertNotNull(job.getUserEmail()); assertNotNull(job.getGeneratedId()); } }
@Test public void testListJobsWithSelectedFields() { Page<Job> jobs = bigquery.listJobs(JobListOption.fields(JobField.USER_EMAIL)); for (Job job : jobs.getValues()) { assertNotNull(job.getJobId()); assertNotNull(job.getStatus()); assertNotNull(job.getUserEmail()); assertNull(job.getStatistics()); assertNull(job.getGeneratedId()); } }