public void TestCancelManagedInstanceOperation()
{
using (SqlManagementTestContext context = new SqlManagementTestContext(this))
{
SqlManagementClient sqlClient = context.GetClient <SqlManagementClient>();
string managedInstanceName = "v-urmila-mi-test";
string resourceGroup = "v-urmila";
Microsoft.Azure.Management.Sql.Models.Sku sku = new Microsoft.Azure.Management.Sql.Models.Sku();
sku.Name = "MIGP4G5";
sku.Tier = "GeneralPurpose";
sku.Family = "Gen5";
var managedInstance = sqlClient.ManagedInstances.Get(resourceGroup, managedInstanceName);
// Old operations should be excluded from validation.
var managedInstanceOperations = sqlClient.ManagedInstanceOperations.ListByManagedInstance(resourceGroup, managedInstanceName);
int oldOperations = managedInstanceOperations.Count();
// Sync update managed server.
sqlClient.ManagedInstances.Update(resourceGroup, managedInstanceName, new ManagedInstanceUpdate {
StorageSizeInGB = 128
});
managedInstanceOperations = sqlClient.ManagedInstanceOperations.ListByManagedInstance(resourceGroup, managedInstanceName);
var operationId = managedInstanceOperations.ElementAt(oldOperations).Name;
var firstManagedInstanceOperation = sqlClient.ManagedInstanceOperations.Get(resourceGroup, managedInstanceName, System.Guid.Parse(operationId));
// Validate that operation finished successfully.
SqlManagementTestUtilities.ValidateManagedInstanceOperation(firstManagedInstanceOperation, operationId, "UPDATE MANAGED SERVER", 100, "Succeeded", false);
// Async update server
var updateManagedInstance = sqlClient.ManagedInstances.UpdateAsync(resourceGroup, managedInstanceName, new ManagedInstanceUpdate {
VCores = 16
});
do
{
managedInstanceOperations = sqlClient.ManagedInstanceOperations.ListByManagedInstance(resourceGroup, managedInstanceName);
Thread.Sleep(20000);
} while (managedInstanceOperations.Count() < oldOperations + 2 || !managedInstanceOperations.ElementAt(oldOperations + 1).IsCancellable.Value);
operationId = managedInstanceOperations.ElementAt(oldOperations + 1).Name;
// Initiate cancel of second update which is in progress.
sqlClient.ManagedInstanceOperations.Cancel(resourceGroup, managedInstanceName, System.Guid.Parse(operationId));
var secondManagedInstanceOperation = sqlClient.ManagedInstanceOperations.Get(resourceGroup, managedInstanceName, System.Guid.Parse(operationId));
while (!secondManagedInstanceOperation.State.Equals("Cancelled"))
{
secondManagedInstanceOperation = sqlClient.ManagedInstanceOperations.Get(resourceGroup, managedInstanceName, System.Guid.Parse(operationId));
Thread.Sleep(20000);
}
// Validate that operation was cancelled.
SqlManagementTestUtilities.ValidateManagedInstanceOperation(secondManagedInstanceOperation, operationId, "UPDATE MANAGED SERVER", 100, "Cancelled", false);
}
}
public void TestCancelManagedInstanceOperation()
{
using (SqlManagementTestContext context = new SqlManagementTestContext(this))
{
SqlManagementClient sqlClient = context.GetClient <SqlManagementClient>();
var resourceGroup = context.CreateResourceGroup(ManagedInstanceTestUtilities.Region);
var managedInstance = context.CreateManagedInstance(resourceGroup);
var managedInstanceName = managedInstance.Name;
var resourceGroupName = resourceGroup.Name;
// Old operations should be excluded from validation.
var managedInstanceOperations = sqlClient.ManagedInstanceOperations.ListByManagedInstance(resourceGroupName, managedInstanceName);
int oldOperations = managedInstanceOperations.Count();
// Sync update managed server.
sqlClient.ManagedInstances.Update(resourceGroupName, managedInstanceName, new ManagedInstanceUpdate {
StorageSizeInGB = 128
});
managedInstanceOperations = sqlClient.ManagedInstanceOperations.ListByManagedInstance(resourceGroupName, managedInstanceName);
var operationId = managedInstanceOperations.ElementAt(oldOperations).Name;
var firstManagedInstanceOperation = sqlClient.ManagedInstanceOperations.Get(resourceGroupName, managedInstanceName, System.Guid.Parse(operationId));
// Validate that operation finished successfully.
SqlManagementTestUtilities.ValidateManagedInstanceOperation(firstManagedInstanceOperation, operationId, "UPDATE MANAGED SERVER", 100, "Succeeded", false);
// Async update server
var updateManagedInstance = sqlClient.ManagedInstances.UpdateAsync(resourceGroupName, managedInstanceName, new ManagedInstanceUpdate {
VCores = 16
});
do
{
managedInstanceOperations = sqlClient.ManagedInstanceOperations.ListByManagedInstance(resourceGroupName, managedInstanceName);
if (HttpMockServer.Mode == HttpRecorderMode.Record)
{
Thread.Sleep(20000);
}
} while (managedInstanceOperations.Count() < oldOperations + 2 || !managedInstanceOperations.ElementAt(oldOperations + 1).IsCancellable.Value);
operationId = managedInstanceOperations.ElementAt(oldOperations + 1).Name;
// Initiate cancel of second update which is in progress.
sqlClient.ManagedInstanceOperations.Cancel(resourceGroupName, managedInstanceName, System.Guid.Parse(operationId));
var secondManagedInstanceOperation = sqlClient.ManagedInstanceOperations.Get(resourceGroupName, managedInstanceName, System.Guid.Parse(operationId));
while (!secondManagedInstanceOperation.State.Equals("Cancelled"))
{
secondManagedInstanceOperation = sqlClient.ManagedInstanceOperations.Get(resourceGroupName, managedInstanceName, System.Guid.Parse(operationId));
if (HttpMockServer.Mode == HttpRecorderMode.Record)
{
Thread.Sleep(20000);
}
}
// Validate that operation was cancelled.
SqlManagementTestUtilities.ValidateManagedInstanceOperation(secondManagedInstanceOperation, operationId, "UPDATE MANAGED SERVER", 100, "Cancelled", false);
}
}