public void TestGetRows()
{
var query = new Google.Apis.Bigquery.v2.JobsResource.QueryRequest(
_bigquery, new Google.Apis.Bigquery.v2.Data.QueryRequest()
{
Query = _countUniqueWordsQuery,
MaxResults = 3, // Small pages to test the paging code.
}, _projectId).Execute();
Assert.IsTrue(query.JobComplete ?? false);
var rows = BigQuery.Util.GetRows(_bigquery, query.JobReference, 3);
Assert.IsTrue(IsShakespeare(rows));
}
// [END build_service]
public IList <TableRow> ExecuteQuery(string querySql, BigqueryService bigquery, string projectId)
{
var request = new Google.Apis.Bigquery.v2.JobsResource.QueryRequest(
bigquery, new Google.Apis.Bigquery.v2.Data.QueryRequest()
{
Query = querySql,
}, projectId);
var query = request.Execute();
GetQueryResultsResponse queryResult = bigquery.Jobs.GetQueryResults(
projectId, query.JobReference.JobId).Execute();
return(queryResult.Rows);
}
// [END build_service]
// [START run_query]
/// <summary>
/// Executes the given query synchronously.
/// </summary>
/// <param name="querySql">the query to execute.</param>
/// <param name="bigquery">the BigquerService object.</param>
/// <param name="projectId">the id of the project under which to run the query.</param>
/// <returns>a list of the results of the query.</returns>
public static async Task<IList<TableRow>> ExecuteQueryAsync(
string querySql, BigqueryService bigquery, string projectId)
{
var request = new Google.Apis.Bigquery.v2.JobsResource.QueryRequest(
bigquery, new Google.Apis.Bigquery.v2.Data.QueryRequest()
{
Query = querySql,
}, projectId);
var query = await request.ExecuteAsync();
GetQueryResultsResponse queryResult = await
bigquery.Jobs.GetQueryResults(projectId, query.JobReference.JobId).ExecuteAsync();
return queryResult.Rows;
}
public void TestGetRows()
{
var query = new Google.Apis.Bigquery.v2.JobsResource.QueryRequest(
s_bigquery, new Google.Apis.Bigquery.v2.Data.QueryRequest()
{
Query = s_countUniqueWordsQuery,
MaxResults = 3, // Small pages to test the paging code.
}, s_projectId).Execute();
Assert.IsTrue(query.JobComplete ?? false);
var rows = s_util.GetRows(query.JobReference, 3);
Assert.IsTrue(IsShakespeare(rows));
}
