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); SqlUserDefinedFunctionResource userDefinedFunction2 = await SqlUserDefinedFunctionCollection.GetAsync(_userDefinedFunctionName); Assert.AreEqual(_userDefinedFunctionName, userDefinedFunction2.Data.Resource.Id); VerifySqlUserDefinedFunctions(userDefinedFunction, userDefinedFunction2); var updateOptions = new SqlUserDefinedFunctionCreateOrUpdateContent(AzureLocation.WestUS, new Models.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 <SqlUserDefinedFunctionResource> CreateSqlUserDefinedFunction(AutoscaleSettings autoscale) { _userDefinedFunctionName = Recording.GenerateAssetName("sql-stored-procedure-"); var sqlDatabaseCreateUpdateOptions = new SqlUserDefinedFunctionCreateOrUpdateContent(AzureLocation.WestUS, new Models.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 ArmOperation <SqlUserDefinedFunctionResource> Update(WaitUntil waitUntil, SqlUserDefinedFunctionCreateOrUpdateContent content, CancellationToken cancellationToken = default) { Argument.AssertNotNull(content, nameof(content)); using var scope = _sqlUserDefinedFunctionSqlResourcesClientDiagnostics.CreateScope("SqlUserDefinedFunctionResource.Update"); scope.Start(); try { var response = _sqlUserDefinedFunctionSqlResourcesRestClient.CreateUpdateSqlUserDefinedFunction(Id.SubscriptionId, Id.ResourceGroupName, Id.Parent.Parent.Parent.Name, Id.Parent.Parent.Name, Id.Parent.Name, Id.Name, content, cancellationToken); var operation = new CosmosDBArmOperation <SqlUserDefinedFunctionResource>(new SqlUserDefinedFunctionOperationSource(Client), _sqlUserDefinedFunctionSqlResourcesClientDiagnostics, Pipeline, _sqlUserDefinedFunctionSqlResourcesRestClient.CreateCreateUpdateSqlUserDefinedFunctionRequest(Id.SubscriptionId, Id.ResourceGroupName, Id.Parent.Parent.Parent.Name, Id.Parent.Parent.Name, Id.Parent.Name, Id.Name, content).Request, response, OperationFinalStateVia.Location); if (waitUntil == WaitUntil.Completed) { operation.WaitForCompletion(cancellationToken); } return(operation); } catch (Exception e) { scope.Failed(e); throw; } }