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)); }