public async Task SqlUserDefinedFunctionCreateAndUpdate() { var userDefinedFunction = await CreateSqlUserDefinedFunction(null); Assert.AreEqual(_userDefinedFunctionName, userDefinedFunction.Data.Resource.Id); Assert.That(userDefinedFunction.Data.Resource.Body, Contains.Substring("First Hello World")); // Seems bug in swagger definition //Assert.AreEqual(TestThroughput1, container.Data.Options.Throughput); bool ifExists = await SqlUserDefinedFunctionCollection.ExistsAsync(_userDefinedFunctionName); Assert.True(ifExists); SqlUserDefinedFunction userDefinedFunction2 = await SqlUserDefinedFunctionCollection.GetAsync(_userDefinedFunctionName); Assert.AreEqual(_userDefinedFunctionName, userDefinedFunction2.Data.Resource.Id); VerifySqlUserDefinedFunctions(userDefinedFunction, userDefinedFunction2); SqlUserDefinedFunctionCreateUpdateData updateOptions = new SqlUserDefinedFunctionCreateUpdateData(AzureLocation.WestUS, new SqlUserDefinedFunctionResource(_userDefinedFunctionName) { Body = @"function () { var updatetext = getContext(); var response = context.getResponse(); response.setBody('Second Hello World'); }" }); userDefinedFunction = (await SqlUserDefinedFunctionCollection.CreateOrUpdateAsync(WaitUntil.Completed, _userDefinedFunctionName, updateOptions)).Value; Assert.AreEqual(_userDefinedFunctionName, userDefinedFunction.Data.Resource.Id); Assert.That(userDefinedFunction.Data.Resource.Body, Contains.Substring("Second Hello World")); userDefinedFunction2 = await SqlUserDefinedFunctionCollection.GetAsync(_userDefinedFunctionName); VerifySqlUserDefinedFunctions(userDefinedFunction, userDefinedFunction2); }
internal async Task <SqlUserDefinedFunction> CreateSqlUserDefinedFunction(AutoscaleSettings autoscale) { _userDefinedFunctionName = Recording.GenerateAssetName("sql-stored-procedure-"); SqlUserDefinedFunctionCreateUpdateData sqlDatabaseCreateUpdateOptions = new SqlUserDefinedFunctionCreateUpdateData(AzureLocation.WestUS, new SqlUserDefinedFunctionResource(_userDefinedFunctionName) { Body = @"function () { var updatetext = getContext(); var response = context.getResponse(); response.setBody('First Hello World'); }" }) { Options = BuildDatabaseCreateUpdateOptions(TestThroughput1, autoscale), }; var sqlContainerLro = await SqlUserDefinedFunctionCollection.CreateOrUpdateAsync(WaitUntil.Completed, _userDefinedFunctionName, sqlDatabaseCreateUpdateOptions); return(sqlContainerLro.Value); }
public virtual async Task <ArmOperation <SqlUserDefinedFunction> > CreateOrUpdateAsync(WaitUntil waitUntil, string userDefinedFunctionName, SqlUserDefinedFunctionCreateUpdateData createUpdateSqlUserDefinedFunctionParameters, CancellationToken cancellationToken = default) { Argument.AssertNotNullOrEmpty(userDefinedFunctionName, nameof(userDefinedFunctionName)); Argument.AssertNotNull(createUpdateSqlUserDefinedFunctionParameters, nameof(createUpdateSqlUserDefinedFunctionParameters)); using var scope = _sqlUserDefinedFunctionSqlResourcesClientDiagnostics.CreateScope("SqlUserDefinedFunctionCollection.CreateOrUpdate"); scope.Start(); try { var response = await _sqlUserDefinedFunctionSqlResourcesRestClient.CreateUpdateSqlUserDefinedFunctionAsync(Id.SubscriptionId, Id.ResourceGroupName, Id.Parent.Parent.Name, Id.Parent.Name, Id.Name, userDefinedFunctionName, createUpdateSqlUserDefinedFunctionParameters, cancellationToken).ConfigureAwait(false); var operation = new CosmosDBArmOperation <SqlUserDefinedFunction>(new SqlUserDefinedFunctionOperationSource(Client), _sqlUserDefinedFunctionSqlResourcesClientDiagnostics, Pipeline, _sqlUserDefinedFunctionSqlResourcesRestClient.CreateCreateUpdateSqlUserDefinedFunctionRequest(Id.SubscriptionId, Id.ResourceGroupName, Id.Parent.Parent.Name, Id.Parent.Name, Id.Name, userDefinedFunctionName, createUpdateSqlUserDefinedFunctionParameters).Request, response, OperationFinalStateVia.Location); if (waitUntil == WaitUntil.Completed) { await operation.WaitForCompletionAsync(cancellationToken).ConfigureAwait(false); } return(operation); } catch (Exception e) { scope.Failed(e); throw; } }