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