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