public void TestAsyncQuery()
{
Job job = BigQuery.Util.AsyncQuery(_bigquery, _projectId, _countUniqueWordsQuery,
false);
var request = new JobsResource.GetRequest(_bigquery, _projectId,
job.JobReference.JobId);
job = BigQuery.Util.PollJob(request, 2000);
var rows = BigQuery.Util.GetRows(_bigquery, job.JobReference);
Assert.IsTrue(IsShakespeare(rows));
}
// [END async_query]
/// <summary>
/// Polls the job for completion.
/// </summary>
/// <param name="request">The bigquery request to poll for completion
/// </param>
/// <param name="interval">Number of milliseconds between each poll
/// </param>
/// <returns>The finished job</returns>
// [START poll_job]
public Job PollJob(JobsResource.GetRequest request, int interval)
{
Job job = request.Execute();
while (job.Status.State != "DONE")
{
Thread.Sleep(interval);
job = request.Execute();
}
return(job);
}
public void TestAsyncQuery()
{
Job job = s_util.AsyncQuery(s_projectId,
s_countUniqueWordsQuery, false);
var request = new JobsResource.GetRequest(s_bigquery, s_projectId,
job.JobReference.JobId);
job = s_util.PollJob(request, 2000);
var rows = s_util.GetRows(job.JobReference);
Assert.IsTrue(IsShakespeare(rows));
}
/// <summary>
/// Tries to refresh job.
/// </summary>
public void RefreshJob()
{
JobsResource.GetRequest jobItem = new JobsResource.GetRequest(new BigqueryService(), this.ProjectId, this.JobId);
jobItem.Oauth_token = BigQueryConnectionManager.GetToken();
jobItem.Fields = BQFields.FieldsMask_Id + "," + BQFields.FieldsMask_Status + "," + BQFields.FieldsMask_Statistics + "," + BQFields.FieldsMask_JobReference + "," + BQFields.FieldsMask_Configuration;
Job job = jobItem.Fetch();
this.jobData = job;
this.jobJsonData = JsonConvert.SerializeObject(job);
}
