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