/// <inheritdoc />
public override BigqueryQueryJob ExecuteQuery(string sql, ExecuteQueryOptions options = null)
{
GaxPreconditions.CheckNotNull(sql, nameof(sql));
var queryRequest = new QueryRequest {
Query = sql, UseLegacySql = false
};
options?.ModifyRequest(queryRequest);
var request = Service.Jobs.Query(queryRequest, ProjectId);
var queryResponse = request.Execute();
return(new BigqueryQueryJob(this, queryResponse, options));
}
/// <inheritdoc />
public override async Task <BigqueryQueryJob> ExecuteQueryAsync(string sql, ExecuteQueryOptions options = null, CancellationToken cancellationToken = default(CancellationToken))
{
GaxPreconditions.CheckNotNull(sql, nameof(sql));
var queryRequest = new QueryRequest {
Query = sql, UseLegacySql = false
};
options?.ModifyRequest(queryRequest);
var request = Service.Jobs.Query(queryRequest, ProjectId);
var queryResponse = await request.ExecuteAsync(cancellationToken).ConfigureAwait(false);
return(new BigqueryQueryJob(this, queryResponse, options));
}
/// <inheritdoc />
public override BigqueryResult ExecuteQuery(string sql, ExecuteQueryOptions options = null)
{
GaxRestPreconditions.CheckNotNull(sql, nameof(sql));
var queryRequest = new Apis.Bigquery.v2.Data.QueryRequest {
Query = sql
};
options?.ModifyRequest(queryRequest);
var request = Service.Jobs.Query(queryRequest, ProjectId);
var queryResponse = request.Execute();
return(new BigqueryResult(this, queryResponse));
}
/// <inheritdoc />
public override BigqueryQueryJob ExecuteQuery(BigqueryCommand command, ExecuteQueryOptions options = null)
{
GaxPreconditions.CheckNotNull(command, nameof(command));
var queryRequest = new QueryRequest {
UseLegacySql = false
};
command.PopulateQueryRequest(queryRequest);
options?.ModifyRequest(queryRequest);
var request = Service.Jobs.Query(queryRequest, ProjectId);
var queryResponse = request.Execute();
return(new BigqueryQueryJob(this, queryResponse, options));
}
/// <summary>
/// Executes a query synchronously.
/// </summary>
/// <param name="sql">The query in BigQuery's SQL dialect. Must not be null.</param>
/// <param name="options">The options for the operation. May be null, in which case defaults will be supplied.</param>
/// <returns>The result of the query.</returns>
public virtual BigqueryResult ExecuteQuery(string sql, ExecuteQueryOptions options = null)
{
throw new NotImplementedException();
}
/// <summary>
/// Executes a command. This overload allows query parameterization, and is preferred over
/// <see cref="ExecuteQuery(string, ExecuteQueryOptions)"/> when values need to be passed in.
/// </summary>
/// <param name="command">The command to execute. Must not be null.</param>
/// <param name="options">The options for the operation. May be null, in which case defaults will be supplied.</param>
/// <returns>The result of the query.</returns>
public virtual BigqueryQueryJob ExecuteQuery(BigqueryCommand command, ExecuteQueryOptions options = null)
{
throw new NotImplementedException();
}
/// <summary>
/// Asynchronously executes a command. This overload allows query parameterization, and is preferred over
/// <see cref="ExecuteQueryAsync(string, ExecuteQueryOptions,CancellationToken)"/> when values need to be passed in.
/// </summary>
/// <param name="command">The command to execute. Must not be null.</param>
/// <param name="options">The options for the operation. May be null, in which case defaults will be supplied.</param>
/// <param name="cancellationToken">The token to monitor for cancellation requests.</param>
/// <returns>A task representing the asynchronous operation. When complete, the result is
/// the <see cref="BigqueryQueryJob"/> representing the query.</returns>
public virtual Task <BigqueryQueryJob> ExecuteQueryAsync(BigqueryCommand command, ExecuteQueryOptions options = null, CancellationToken cancellationToken = default(CancellationToken))
{
throw new NotImplementedException();
}
internal BigqueryQueryJob(BigqueryClient client, QueryResponse response, ExecuteQueryOptions options)
: this(client, ConvertQueryResponse(GaxPreconditions.CheckNotNull(response, nameof(response))), options?.ToGetQueryResultsOptions())
{
}
