public async Task SqlStoredProcedureCreateAndUpdate()
{
var storedProcedure = await CreateSqlStoredProcedure(null);
Assert.AreEqual(_storedProcedureName, storedProcedure.Data.Resource.Id);
// Seems bug in swagger definition
//Assert.AreEqual(TestThroughput1, container.Data.Options.Throughput);
bool ifExists = await SqlStoredProcedureCollection.ExistsAsync(_storedProcedureName);
Assert.True(ifExists);
// NOT WORKING API
//ThroughputSettingsData throughtput = await container.GetMongoDBCollectionThroughputAsync();
SqlStoredProcedureResource storedProcedure2 = await SqlStoredProcedureCollection.GetAsync(_storedProcedureName);
Assert.AreEqual(_storedProcedureName, storedProcedure2.Data.Resource.Id);
//Assert.AreEqual(TestThroughput1, container2.Data.Options.Throughput);
VerifySqlStoredProcedures(storedProcedure, storedProcedure2);
// TODO: use original tags see defect: https://github.com/Azure/autorest.csharp/issues/1590
var updateOptions = new SqlStoredProcedureCreateOrUpdateContent(AzureLocation.WestUS, storedProcedure.Data.Resource)
{
Options = new CreateUpdateOptions {
Throughput = TestThroughput2
}
};
storedProcedure = (await SqlStoredProcedureCollection.CreateOrUpdateAsync(WaitUntil.Completed, _storedProcedureName, updateOptions)).Value;
Assert.AreEqual(_storedProcedureName, storedProcedure.Data.Resource.Id);
storedProcedure2 = await SqlStoredProcedureCollection.GetAsync(_storedProcedureName);
VerifySqlStoredProcedures(storedProcedure, storedProcedure2);
}
public async Task TearDown()
{
if (await SqlStoredProcedureCollection.ExistsAsync(_storedProcedureName))
{
var id = SqlStoredProcedureCollection.Id;
id = SqlStoredProcedureResource.CreateResourceIdentifier(id.SubscriptionId, id.ResourceGroupName, id.Parent.Parent.Name, id.Parent.Name, id.Name, _storedProcedureName);
SqlStoredProcedureResource storedProcedure = this.ArmClient.GetSqlStoredProcedureResource(id);
await storedProcedure.DeleteAsync(WaitUntil.Completed);
}
}
private void VerifySqlStoredProcedures(SqlStoredProcedureResource expectedValue, SqlStoredProcedureResource actualValue)
{
Assert.AreEqual(expectedValue.Id, actualValue.Id);
Assert.AreEqual(expectedValue.Data.Name, actualValue.Data.Name);
Assert.AreEqual(expectedValue.Data.Resource.Id, actualValue.Data.Resource.Id);
Assert.AreEqual(expectedValue.Data.Resource.Rid, actualValue.Data.Resource.Rid);
Assert.AreEqual(expectedValue.Data.Resource.Ts, actualValue.Data.Resource.Ts);
Assert.AreEqual(expectedValue.Data.Resource.Etag, actualValue.Data.Resource.Etag);
Assert.AreEqual(expectedValue.Data.Resource.Body, actualValue.Data.Resource.Body);
}
public SqlContainerImpl WithStoredProcedure(string name, SqlStoredProcedureResource resource = default(SqlStoredProcedureResource), CreateUpdateOptions options = default(CreateUpdateOptions))
{
var parameter = new SqlStoredProcedureCreateUpdateParameters()
{
Location = this.Location,
Resource = resource ?? new SqlStoredProcedureResource(),
Options = options ?? new CreateUpdateOptions(),
};
parameter.Resource.Id = name;
this.storedProcedureToUpdate.Add(name, parameter);
return(this);
}
public async Task SqlStoredProcedureListTest()
{
List <SqlStoredProcedureResource> sqlStoredProcedures = await CosmosDBManagementClient.SqlResources.ListSqlStoredProceduresAsync(
resourceGroupName, databaseAccountName, databaseName, containerName).ToEnumerableAsync();
Assert.NotNull(sqlStoredProcedures);
Assert.AreEqual(1, sqlStoredProcedures.Count);
SqlStoredProcedureResource sqlStoredProcedure = await CosmosDBManagementClient.SqlResources.GetSqlStoredProcedureAsync(
resourceGroupName, databaseAccountName, databaseName, containerName, storedProcedureName);
Assert.NotNull(sqlStoredProcedure);
VerifySqlStoredProcedures(sqlStoredProcedure, sqlStoredProcedures[0]);
}
public async Task SqlStoredProcedureCreateAndUpdateTest()
{
SqlStoredProcedureCreateUpdateParameters sqlStoredProcedureCreateUpdateParameters = new SqlStoredProcedureCreateUpdateParameters(
new SqlStoredProcedureResource(storedProcedureName)
{
Body = "function () { var updatetext = getContext(); " +
"var response = context.getResponse();" +
"response.setBody('First Hello World');" +
"}"
},
new CreateUpdateOptions()
);
;
SqlStoredProcedureResource sqlStoredProcedure1 = await WaitForCompletionAsync(
await CosmosDBManagementClient.SqlResources.StartCreateUpdateSqlStoredProcedureAsync(
resourceGroupName, databaseAccountName, databaseName, containerName, storedProcedureName, sqlStoredProcedureCreateUpdateParameters));
Assert.NotNull(sqlStoredProcedure1);
SqlStoredProcedureResource sqlStoredProcedure2 = await CosmosDBManagementClient.SqlResources.GetSqlStoredProcedureAsync(
resourceGroupName, databaseAccountName, databaseName, containerName, storedProcedureName);
Assert.NotNull(sqlStoredProcedure2);
VerifySqlStoredProcedures(sqlStoredProcedure1, sqlStoredProcedure2);
sqlStoredProcedureCreateUpdateParameters = new SqlStoredProcedureCreateUpdateParameters(
new SqlStoredProcedureResource(storedProcedureName)
{
Body = "function () { var updatetext = getContext(); " +
"var response = context.getResponse();" +
"response.setBody('Second Hello World');" +
"}"
},
new CreateUpdateOptions()
);
SqlStoredProcedureResource sqlStoredProcedure3 = await WaitForCompletionAsync(
await CosmosDBManagementClient.SqlResources.StartCreateUpdateSqlStoredProcedureAsync(
resourceGroupName, databaseAccountName, databaseName, containerName, storedProcedureName, sqlStoredProcedureCreateUpdateParameters));
Assert.NotNull(sqlStoredProcedure3);
SqlStoredProcedureResource sqlStoredProcedure4 = await CosmosDBManagementClient.SqlResources.GetSqlStoredProcedureAsync(
resourceGroupName, databaseAccountName, databaseName, containerName, storedProcedureName);
Assert.NotNull(sqlStoredProcedure4);
VerifySqlStoredProcedures(sqlStoredProcedure3, sqlStoredProcedure4);
}
