/// <summary>
/// Gets all SQL virtual machines in a subscription.
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='nextPageLink'>
/// The NextLink from the previous successful call to List operation.
/// </param>
/// <param name='cancellationToken'>
/// The cancellation token.
/// </param>
public static async Task <IPage <SqlVirtualMachineModel> > ListNextAsync(this ISqlVirtualMachinesOperations operations, string nextPageLink, CancellationToken cancellationToken = default(CancellationToken))
{
using (var _result = await operations.ListNextWithHttpMessagesAsync(nextPageLink, null, cancellationToken).ConfigureAwait(false))
{
return(_result.Body);
}
}
/// <summary>
/// Gets a SQL virtual machine.
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='resourceGroupName'>
/// Name of the resource group that contains the resource. You can obtain this
/// value from the Azure Resource Manager API or the portal.
/// </param>
/// <param name='sqlVirtualMachineName'>
/// Name of the SQL virtual machine.
/// </param>
/// <param name='expand'>
/// The child resources to include in the response.
/// </param>
/// <param name='cancellationToken'>
/// The cancellation token.
/// </param>
public static async Task <SqlVirtualMachineModel> GetAsync(this ISqlVirtualMachinesOperations operations, string resourceGroupName, string sqlVirtualMachineName, string expand = default(string), CancellationToken cancellationToken = default(CancellationToken))
{
using (var _result = await operations.GetWithHttpMessagesAsync(resourceGroupName, sqlVirtualMachineName, expand, null, cancellationToken).ConfigureAwait(false))
{
return(_result.Body);
}
}
/// <summary>
/// Updates a SQL virtual machine.
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='resourceGroupName'>
/// Name of the resource group that contains the resource. You can obtain this
/// value from the Azure Resource Manager API or the portal.
/// </param>
/// <param name='sqlVirtualMachineName'>
/// Name of the SQL virtual machine.
/// </param>
/// <param name='parameters'>
/// The SQL virtual machine.
/// </param>
/// <param name='cancellationToken'>
/// The cancellation token.
/// </param>
public static async Task <SqlVirtualMachineModel> BeginUpdateAsync(this ISqlVirtualMachinesOperations operations, string resourceGroupName, string sqlVirtualMachineName, SqlVirtualMachineUpdate parameters, CancellationToken cancellationToken = default(CancellationToken))
{
using (var _result = await operations.BeginUpdateWithHttpMessagesAsync(resourceGroupName, sqlVirtualMachineName, parameters, null, cancellationToken).ConfigureAwait(false))
{
return(_result.Body);
}
}
public void TestCreateGetUpdateDeleteSqlVirtualMachine()
{
using (SqlVirtualMachineTestContext context = new SqlVirtualMachineTestContext(this))
{
// Create SQL VM
ISqlVirtualMachinesOperations sqlOperations = context.getSqlClient().SqlVirtualMachines;
Dictionary <string, SqlVirtualMachineModel> sqlVirtualMachines = new Dictionary <string, SqlVirtualMachineModel>();
SqlVirtualMachineModel sqlVM = null;
for (int i = 0; i < 3; i++)
{
sqlVM = SqlVirtualMachineTestBase.CreateSqlVirtualMachine(context);
Assert.NotNull(sqlVM);
sqlVirtualMachines[sqlVM.Id] = sqlVM;
}
// Recover
foreach (string id in sqlVirtualMachines.Keys)
{
sqlVM = sqlOperations.Get(context.resourceGroup.Name, sqlVirtualMachines[id].Name);
Assert.NotNull(sqlVM);
SqlVirtualMachineTestBase.ValidateSqlVirtualMachine(sqlVM, sqlVirtualMachines[id]);
}
// Update
string key = "test", value = "updateTag";
sqlOperations.Update(context.resourceGroup.Name, sqlVM.Name, new SqlVirtualMachineUpdate
{
Tags = new Dictionary <string, string>
{
{ key, value }
}
});
SqlVirtualMachineModel sqlVM2 = sqlOperations.Get(context.resourceGroup.Name, sqlVM.Name);
SqlVirtualMachineTestBase.ValidateSqlVirtualMachine(sqlVM, sqlVM2, sameTags: false);
Assert.Equal(1, sqlVM2.Tags.Keys.Count);
Assert.Equal(value, sqlVM2.Tags[key]);
// Delete
sqlOperations.Delete(context.resourceGroup.Name, sqlVM2.Name);
sqlVirtualMachines.Remove(sqlVM2.Id);
// List
IPage <SqlVirtualMachineModel> recovered = sqlOperations.List();
var iter = recovered.GetEnumerator();
while (iter.MoveNext())
{
sqlVM = iter.Current;
Assert.NotEqual(sqlVM.Id, sqlVM2.Id);
if (sqlVirtualMachines.ContainsKey(sqlVM.Id))
{
SqlVirtualMachineTestBase.ValidateSqlVirtualMachine(sqlVM, sqlVirtualMachines[sqlVM.Id]);
sqlVirtualMachines.Remove(sqlVM.Id);
}
}
Assert.Empty(sqlVirtualMachines.Keys);
iter.Dispose();
}
}
/// <summary>
/// Initializes client properties.
/// </summary>
private void Initialize()
{
AvailabilityGroupListeners = new AvailabilityGroupListenersOperations(this);
Operations = new Operations(this);
SqlVirtualMachineGroups = new SqlVirtualMachineGroupsOperations(this);
SqlVirtualMachines = new SqlVirtualMachinesOperations(this);
BaseUri = new System.Uri("https://management.azure.com");
ApiVersion = "2017-03-01-preview";
AcceptLanguage = "en-US";
LongRunningOperationRetryTimeout = 30;
GenerateClientRequestId = true;
SerializationSettings = new JsonSerializerSettings
{
Formatting = Newtonsoft.Json.Formatting.Indented,
DateFormatHandling = Newtonsoft.Json.DateFormatHandling.IsoDateFormat,
DateTimeZoneHandling = Newtonsoft.Json.DateTimeZoneHandling.Utc,
NullValueHandling = Newtonsoft.Json.NullValueHandling.Ignore,
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Serialize,
ContractResolver = new ReadOnlyJsonContractResolver(),
Converters = new List <JsonConverter>
{
new Iso8601TimeSpanConverter()
}
};
SerializationSettings.Converters.Add(new TransformationJsonConverter());
DeserializationSettings = new JsonSerializerSettings
{
DateFormatHandling = Newtonsoft.Json.DateFormatHandling.IsoDateFormat,
DateTimeZoneHandling = Newtonsoft.Json.DateTimeZoneHandling.Utc,
NullValueHandling = Newtonsoft.Json.NullValueHandling.Ignore,
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Serialize,
ContractResolver = new ReadOnlyJsonContractResolver(),
Converters = new List <JsonConverter>
{
new Iso8601TimeSpanConverter()
}
};
CustomInitialize();
DeserializationSettings.Converters.Add(new TransformationJsonConverter());
DeserializationSettings.Converters.Add(new CloudErrorJsonConverter());
}
public void TestListByGroupSqlVirtualMachine()
{
using (SqlVirtualMachineTestContext context = new SqlVirtualMachineTestContext(this))
{
// Create Sql VM
ISqlVirtualMachinesOperations sqlOperations = context.getSqlClient().SqlVirtualMachines;
SqlVirtualMachineModel sqlVM = SqlVirtualMachineTestBase.CreateSqlVirtualMachine(context);
Assert.NotNull(sqlVM);
// List by group
IPage <SqlVirtualMachineModel> recovered = sqlOperations.ListByResourceGroup(context.resourceGroup.Name);
var iter = recovered.GetEnumerator();
Assert.NotNull(iter);
iter.MoveNext();
SqlVirtualMachineModel sqlVM2 = iter.Current;
Assert.NotNull(sqlVM2);
SqlVirtualMachineTestBase.ValidateSqlVirtualMachine(sqlVM, sqlVM2);
Assert.False(iter.MoveNext());
iter.Dispose();
}
}
public static SqlVirtualMachineModel CreateSqlVirtualMachine(SqlVirtualMachineTestContext context, SqlVirtualMachineGroup group = null, VirtualMachine virtualMachine = null)
{
ISqlVirtualMachinesOperations sqlOperations = context.getSqlClient().SqlVirtualMachines;
VirtualMachine vm = virtualMachine == null?VirtualMachineTestBase.CreateVM(context) : virtualMachine;
SqlVirtualMachineModel sqlVM = sqlOperations.CreateOrUpdate(context.resourceGroup.Name, vm.Name, new SqlVirtualMachineModel()
{
Location = context.location,
VirtualMachineResourceId = vm.Id,
SqlServerLicenseType = SqlServerLicenseType.PAYG,
SqlManagement = SqlManagementMode.Full,
SqlImageSku = Constants.imageSku,
SqlImageOffer = Constants.imageOffer,
SqlVirtualMachineGroupResourceId = (group != null) ? group.Id : null,
ServerConfigurationsManagementSettings = new ServerConfigurationsManagementSettings()
{
SqlConnectivityUpdateSettings = new SqlConnectivityUpdateSettings()
{
SqlAuthUpdateUserName = Constants.sqlLogin,
SqlAuthUpdatePassword = Constants.adminPassword,
ConnectivityType = "Private",
Port = 1433
},
SqlStorageUpdateSettings = new SqlStorageUpdateSettings()
{
DiskCount = 1,
DiskConfigurationType = "NEW",
StartingDeviceId = 2
},
SqlWorkloadTypeUpdateSettings = new SqlWorkloadTypeUpdateSettings()
{
SqlWorkloadType = "OLTP"
}
},
AutoPatchingSettings = new AutoPatchingSettings(false)
});
sqlVM.Validate();
return(sqlVM);
}
/// <summary>
/// Gets a SQL virtual machine.
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='resourceGroupName'>
/// Name of the resource group that contains the resource. You can obtain this
/// value from the Azure Resource Manager API or the portal.
/// </param>
/// <param name='sqlVirtualMachineName'>
/// Name of the SQL virtual machine.
/// </param>
/// <param name='expand'>
/// The child resources to include in the response.
/// </param>
public static SqlVirtualMachineModel Get(this ISqlVirtualMachinesOperations operations, string resourceGroupName, string sqlVirtualMachineName, string expand = default(string))
{
return(operations.GetAsync(resourceGroupName, sqlVirtualMachineName, expand).GetAwaiter().GetResult());
}
/// <summary>
/// Gets all SQL virtual machines in a resource group.
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='nextPageLink'>
/// The NextLink from the previous successful call to List operation.
/// </param>
public static IPage <SqlVirtualMachineModel> ListByResourceGroupNext(this ISqlVirtualMachinesOperations operations, string nextPageLink)
{
return(operations.ListByResourceGroupNextAsync(nextPageLink).GetAwaiter().GetResult());
}
/// <summary>
/// Updates a SQL virtual machine.
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='resourceGroupName'>
/// Name of the resource group that contains the resource. You can obtain this
/// value from the Azure Resource Manager API or the portal.
/// </param>
/// <param name='sqlVirtualMachineName'>
/// Name of the SQL virtual machine.
/// </param>
/// <param name='parameters'>
/// The SQL virtual machine.
/// </param>
public static SqlVirtualMachineModel BeginUpdate(this ISqlVirtualMachinesOperations operations, string resourceGroupName, string sqlVirtualMachineName, SqlVirtualMachineUpdate parameters)
{
return(operations.BeginUpdateAsync(resourceGroupName, sqlVirtualMachineName, parameters).GetAwaiter().GetResult());
}
/// <summary>
/// Deletes a SQL virtual machine.
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='resourceGroupName'>
/// Name of the resource group that contains the resource. You can obtain this
/// value from the Azure Resource Manager API or the portal.
/// </param>
/// <param name='sqlVirtualMachineName'>
/// Name of the SQL virtual machine.
/// </param>
/// <param name='cancellationToken'>
/// The cancellation token.
/// </param>
public static async Task BeginDeleteAsync(this ISqlVirtualMachinesOperations operations, string resourceGroupName, string sqlVirtualMachineName, CancellationToken cancellationToken = default(CancellationToken))
{
(await operations.BeginDeleteWithHttpMessagesAsync(resourceGroupName, sqlVirtualMachineName, null, cancellationToken).ConfigureAwait(false)).Dispose();
}
/// <summary>
/// Deletes a SQL virtual machine.
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='resourceGroupName'>
/// Name of the resource group that contains the resource. You can obtain this
/// value from the Azure Resource Manager API or the portal.
/// </param>
/// <param name='sqlVirtualMachineName'>
/// Name of the SQL virtual machine.
/// </param>
public static void BeginDelete(this ISqlVirtualMachinesOperations operations, string resourceGroupName, string sqlVirtualMachineName)
{
operations.BeginDeleteAsync(resourceGroupName, sqlVirtualMachineName).GetAwaiter().GetResult();
}
/// <summary>
/// Gets all SQL virtual machines in a subscription.
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
public static IPage <SqlVirtualMachineModel> List(this ISqlVirtualMachinesOperations operations)
{
return(operations.ListAsync().GetAwaiter().GetResult());
}
/// <summary>
/// Gets all SQL virtual machines in a resource group.
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='resourceGroupName'>
/// Name of the resource group that contains the resource. You can obtain this
/// value from the Azure Resource Manager API or the portal.
/// </param>
/// <param name='cancellationToken'>
/// The cancellation token.
/// </param>
public static async Task <IPage <SqlVirtualMachineModel> > ListByResourceGroupAsync(this ISqlVirtualMachinesOperations operations, string resourceGroupName, CancellationToken cancellationToken = default(CancellationToken))
{
using (var _result = await operations.ListByResourceGroupWithHttpMessagesAsync(resourceGroupName, null, cancellationToken).ConfigureAwait(false))
{
return(_result.Body);
}
}
/// <summary>
/// Gets all SQL virtual machines in a resource group.
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='resourceGroupName'>
/// Name of the resource group that contains the resource. You can obtain this
/// value from the Azure Resource Manager API or the portal.
/// </param>
public static IPage <SqlVirtualMachineModel> ListByResourceGroup(this ISqlVirtualMachinesOperations operations, string resourceGroupName)
{
return(operations.ListByResourceGroupAsync(resourceGroupName).GetAwaiter().GetResult());
}
