/// <inheritdoc /> public async override Task <BigQueryRoutine> CreateRoutineAsync(RoutineReference routineReference, Routine resource, CreateRoutineOptions options = null, CancellationToken cancellationToken = default) { var request = CreateInsertRoutineRequest(routineReference, resource, options); var result = await request.ExecuteAsync(cancellationToken).ConfigureAwait(false); return(new BigQueryRoutine(this, result)); }
private InsertRequest CreateInsertRoutineRequest(RoutineReference routineReference, Routine resource, CreateRoutineOptions options) { CheckResourceReference(routineReference, resource); resource.RoutineReference ??= routineReference; var request = Service.Routines.Insert(resource, routineReference.ProjectId, routineReference.DatasetId); options?.ModifyRequest(request); request.PrettyPrint = PrettyPrint; return(request); }
/// <inheritdoc /> public override BigQueryRoutine CreateRoutine(RoutineReference routineReference, Routine resource, CreateRoutineOptions options = null) { var request = CreateInsertRoutineRequest(routineReference, resource, options); var result = request.Execute(); return(new BigQueryRoutine(this, result)); }
/// <inheritdoc /> public override BigQueryRoutine GetOrCreateRoutine(RoutineReference routineReference, Routine resource, GetRoutineOptions getOptions = null, CreateRoutineOptions createOptions = null) { CheckResourceReference(routineReference, resource); try { return(GetRoutine(routineReference, getOptions)); } catch (GoogleApiException ex) when(ex.HttpStatusCode == HttpStatusCode.NotFound) { try { return(CreateRoutine(routineReference, resource, createOptions)); } catch (GoogleApiException ex2) when(ex2.HttpStatusCode == HttpStatusCode.Conflict) { return(GetRoutine(routineReference, getOptions)); } } }
/// <inheritdoc /> public async override Task <BigQueryRoutine> GetOrCreateRoutineAsync(RoutineReference routineReference, Routine resource, GetRoutineOptions getOptions = null, CreateRoutineOptions createOptions = null, CancellationToken cancellationToken = default) { CheckResourceReference(routineReference, resource); try { return(await GetRoutineAsync(routineReference, getOptions, cancellationToken).ConfigureAwait(false)); } catch (GoogleApiException ex) when(ex.HttpStatusCode == HttpStatusCode.NotFound) { try { return(await CreateRoutineAsync(routineReference, resource, createOptions, cancellationToken).ConfigureAwait(false)); } catch (GoogleApiException ex2) when(ex2.HttpStatusCode == HttpStatusCode.Conflict) { return(await GetRoutineAsync(routineReference, getOptions, cancellationToken).ConfigureAwait(false)); } } }
/// <summary> /// Asynchronously attempts to fetch the specified routine, creating it if it doesn't exist. /// This method just creates a <see cref="RoutineReference"/> and delegates to <see cref="GetOrCreateRoutineAsync(RoutineReference, Routine, GetRoutineOptions, CreateRoutineOptions, CancellationToken)"/>. /// </summary> /// <param name="projectId">The project ID. Must not be null.</param> /// <param name="datasetId">The dataset ID. Must not be null.</param> /// <param name="routineId">The routine ID. Must not be null.</param> /// <param name="resource">The routine resource representation to use for the creation. Must not be null. If this routine's <see cref="Routine.RoutineReference"/> is specified, then it must be the same as the one obtained from the other parameters, else it will be set to the one obtained from the other parameters.</param> /// <param name="getOptions">The options for the "get" operation. May be null, in which case defaults will be supplied.</param> /// <param name="createOptions">The options for the "create" 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 existing or new routine.</returns> public virtual Task <BigQueryRoutine> GetOrCreateRoutineAsync(string projectId, string datasetId, string routineId, Routine resource, GetRoutineOptions getOptions = null, CreateRoutineOptions createOptions = null, CancellationToken cancellationToken = default) => GetOrCreateRoutineAsync(GetRoutineReference(projectId, datasetId, routineId), resource, getOptions, createOptions, cancellationToken);
/// <summary> /// Asynchronously attempts to fetch the specified routine, creating it if it doesn't exist. /// </summary> /// <param name="routineReference">A fully-qualified identifier for the routine. Must not be null.</param> /// <param name="resource">The routine resource representation to use for the creation. Must not be null. If this routine's <see cref="Routine.RoutineReference"/> is specified, then it must be the same as the one obtained from the other parameters, else it will be set to the one obtained from the other parameters.</param> /// <param name="getOptions">The options for the "get" operation. May be null, in which case defaults will be supplied.</param> /// <param name="createOptions">The options for the "create" 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 existing or new routine.</returns> public virtual Task <BigQueryRoutine> GetOrCreateRoutineAsync(RoutineReference routineReference, Routine resource, GetRoutineOptions getOptions = null, CreateRoutineOptions createOptions = null, CancellationToken cancellationToken = default) => throw new NotImplementedException();
/// <summary> /// Attempts to fetch the specified routine, creating it if it doesn't exist. /// </summary> /// <param name="routineReference">A fully-qualified identifier for the routine. Must not be null.</param> /// <param name="resource">The routine resource representation to use for the creation. Must not be null. If this routine's <see cref="Routine.RoutineReference"/> is specified, then it must be the same as the one obtained from the other parameters, else it will be set to the one obtained from the other parameters.</param> /// <param name="getOptions">The options for the "get" operation. May be null, in which case defaults will be supplied.</param> /// <param name="createOptions">The options for the "create" operation. May be null, in which case defaults will be supplied.</param> /// <returns>The existing or new routine.</returns> public virtual BigQueryRoutine GetOrCreateRoutine(RoutineReference routineReference, Routine resource, GetRoutineOptions getOptions = null, CreateRoutineOptions createOptions = null) => throw new NotImplementedException();
/// <summary> /// Attempts to fetch the specified routine, creating it if it doesn't exist. /// This method just creates a <see cref="RoutineReference"/> and delegates to <see cref="GetOrCreateRoutine(RoutineReference, Routine, GetRoutineOptions, CreateRoutineOptions)"/>. /// </summary> /// <param name="projectId">The project ID. Must not be null.</param> /// <param name="datasetId">The dataset ID. Must not be null.</param> /// <param name="routineId">The routine ID. Must not be null.</param> /// <param name="resource">The routine resource representation to use for the creation. Must not be null. If this routine's <see cref="Routine.RoutineReference"/> is specified, then it must be the same as the one obtained from the other parameters, else it will be set to the one obtained from the other parameters.</param> /// <param name="getOptions">The options for the "get" operation. May be null, in which case defaults will be supplied.</param> /// <param name="createOptions">The options for the "create" operation. May be null, in which case defaults will be supplied.</param> /// <returns>The existing or new routine.</returns> public virtual BigQueryRoutine GetOrCreateRoutine(string projectId, string datasetId, string routineId, Routine resource, GetRoutineOptions getOptions = null, CreateRoutineOptions createOptions = null) => GetOrCreateRoutine(GetRoutineReference(projectId, datasetId, routineId), resource, getOptions, createOptions);
/// <summary> /// Asynchronously creates the specified routine within this client's project. /// This method just creates a <see cref="RoutineReference"/> and delegates to <see cref="CreateRoutineAsync(RoutineReference, Routine, CreateRoutineOptions, CancellationToken)"/>. /// </summary> /// <param name="datasetId">The dataset ID. Must not be null.</param> /// <param name="routineId">The routine ID. Must not be null.</param> /// <param name="resource">The routine resource representation to use for the creation. Must not be null. If this routine's <see cref="Routine.RoutineReference"/> is specified, then it must be the same as the one obtained from the other parameters, else it will be set to the one obtained from the other parameters.</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 newly created routine.</returns> public virtual Task <BigQueryRoutine> CreateRoutineAsync(string datasetId, string routineId, Routine resource, CreateRoutineOptions options = null, CancellationToken cancellationToken = default) => CreateRoutineAsync(GetRoutineReference(datasetId, routineId), resource, options, cancellationToken);
/// <summary> /// Creates the specified routine. /// </summary> /// <param name="routineReference">A fully-qualified identifier for the routine. Must not be null.</param> /// <param name="resource">The routine resource representation to use for the creation. Must not be null. If this routine's <see cref="Routine.RoutineReference"/> is specified, then it must be the same as the one obtained from the other parameters, else it will be set to the one obtained from the other parameters.</param> /// <param name="options">The options for the operation. May be null, in which case defaults will be supplied.</param> /// <returns>The newly created routine.</returns> public virtual BigQueryRoutine CreateRoutine(RoutineReference routineReference, Routine resource, CreateRoutineOptions options = null) => throw new NotImplementedException();
/// <summary> /// Creates the specified routine. /// This method just creates a <see cref="RoutineReference"/> and delegates to <see cref="CreateRoutine(RoutineReference, Routine, CreateRoutineOptions)"/>. /// </summary> /// <param name="projectId">The project ID. Must not be null.</param> /// <param name="datasetId">The dataset ID. Must not be null.</param> /// <param name="routineId">The routine ID. Must not be null.</param> /// <param name="resource">The routine resource representation to use for the creation. Must not be null. If this routine's <see cref="Routine.RoutineReference"/> is specified, then it must be the same as the one obtained from the other parameters, else it will be set to the one obtained from the other parameters.</param> /// <param name="options">The options for the operation. May be null, in which case defaults will be supplied.</param> /// <returns>The newly created routine.</returns> public virtual BigQueryRoutine CreateRoutine(string projectId, string datasetId, string routineId, Routine resource, CreateRoutineOptions options = null) => CreateRoutine(GetRoutineReference(projectId, datasetId, routineId), resource, options);