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);
}
public async Task TearDown()
{
SqlUserDefinedFunction userDefinedFunction = await SqlUserDefinedFunctionCollection.GetIfExistsAsync(_userDefinedFunctionName);
if (userDefinedFunction != null)
{
await userDefinedFunction.DeleteAsync(WaitUntil.Completed);
}
}
private void VerifySqlUserDefinedFunctions(SqlUserDefinedFunction expectedValue, SqlUserDefinedFunction actualValue)
{
Assert.AreEqual(expectedValue.Id, actualValue.Id);
Assert.AreEqual(expectedValue.Name, actualValue.Name);
Assert.AreEqual(expectedValue.Resource.Id, actualValue.Resource.Id);
Assert.AreEqual(expectedValue.Resource.Rid, actualValue.Resource.Rid);
Assert.AreEqual(expectedValue.Resource.Ts, actualValue.Resource.Ts);
Assert.AreEqual(expectedValue.Resource.Etag, actualValue.Resource.Etag);
Assert.AreEqual(expectedValue.Resource.Body, actualValue.Resource.Body);
}
public async Task SqlUserDefinedFunctionListTest()
{
List <SqlUserDefinedFunction> sqlUserDefinedFunctions = await CosmosDBManagementClient.SqlResources.ListSqlUserDefinedFunctionsAsync(
resourceGroupName, databaseAccountName, databaseName, containerName).ToEnumerableAsync();
Assert.NotNull(sqlUserDefinedFunctions);
Assert.AreEqual(1, sqlUserDefinedFunctions.Count);
SqlUserDefinedFunction sqlUserDefinedFunction = await CosmosDBManagementClient.SqlResources.GetSqlUserDefinedFunctionAsync(
resourceGroupName, databaseAccountName, databaseName, containerName, userDefinedFunctionName);
VerifySqlUserDefinedFunctions(sqlUserDefinedFunction, sqlUserDefinedFunctions[0]);
}
public async Task SqlUserDefinedFunctionCreateAndUpdateTest()
{
SqlUserDefinedFunctionCreateUpdateParameters sqlUserDefinedFunctionCreateUpdateParameters = new SqlUserDefinedFunctionCreateUpdateParameters(
resource: new SqlUserDefinedFunctionResource(userDefinedFunctionName)
{
Body = "function () { var updatetext = getContext(); " +
"var response = context.getResponse();" +
"response.setBody('First Hello World');" +
"}"
},
options: new CreateUpdateOptions()
);
SqlUserDefinedFunction sqlUserDefinedFunction1 = await WaitForCompletionAsync(
await CosmosDBManagementClient.SqlResources.StartCreateUpdateSqlUserDefinedFunctionAsync(
resourceGroupName, databaseAccountName, databaseName, containerName, userDefinedFunctionName, sqlUserDefinedFunctionCreateUpdateParameters));
Assert.NotNull(sqlUserDefinedFunction1);
SqlUserDefinedFunction sqlUserDefinedFunction2 = await CosmosDBManagementClient.SqlResources.GetSqlUserDefinedFunctionAsync(
resourceGroupName, databaseAccountName, databaseName, containerName, userDefinedFunctionName);
Assert.NotNull(sqlUserDefinedFunction2);
VerifySqlUserDefinedFunctions(sqlUserDefinedFunction1, sqlUserDefinedFunction2);
sqlUserDefinedFunctionCreateUpdateParameters = new SqlUserDefinedFunctionCreateUpdateParameters(
resource: new SqlUserDefinedFunctionResource(userDefinedFunctionName)
{
Body = "function () { var updatetext = getContext(); " +
"var response = context.getResponse();" +
"response.setBody('Second Hello World');" +
"}"
},
options: new CreateUpdateOptions()
);
SqlUserDefinedFunction sqlUserDefinedFunction3 = await WaitForCompletionAsync(
await CosmosDBManagementClient.SqlResources.StartCreateUpdateSqlUserDefinedFunctionAsync(
resourceGroupName, databaseAccountName, databaseName, containerName, userDefinedFunctionName, sqlUserDefinedFunctionCreateUpdateParameters));
Assert.NotNull(sqlUserDefinedFunction3);
SqlUserDefinedFunction sqlUserDefinedFunction4 = await CosmosDBManagementClient.SqlResources.GetSqlUserDefinedFunctionAsync(
resourceGroupName, databaseAccountName, databaseName, containerName, userDefinedFunctionName);
Assert.NotNull(sqlUserDefinedFunction4);
VerifySqlUserDefinedFunctions(sqlUserDefinedFunction3, sqlUserDefinedFunction4);
}
