/// <summary>
/// Create upgrade start parameters for testing
/// </summary>
/// <param name="version">The version to upgrade the server to</param>
/// <param name="scheduleUpgradeAfter">The earliest time to upgrade the server</param>
/// <param name="database">The database to map to new edition and SLO. Target SLO and edition are in the constants at the top of this file</param>
/// <returns>The server upgrade start parameters object</returns>
private ServerUpgradeStartParameters CreateUpgradeStartParameters(
string version = upgradedVersion,
DateTime?scheduleUpgradeAfter = null,
Database database = null)
{
var parameters = new ServerUpgradeStartParameters()
{
Properties = new ServerUpgradeProperties()
{
Version = version,
ScheduleUpgradeAfterUtcDateTime = scheduleUpgradeAfter
}
};
if (database != null)
{
parameters.Properties.DatabaseCollection = new List <RecommendedDatabaseProperties>()
{
new RecommendedDatabaseProperties()
{
Name = database.Name,
TargetServiceLevelObjective = targetServiceLevelObjective,
TargetEdition = targetEdition
}
};
}
return(parameters);
}
/// <summary>
/// Create upgrade start parameters for testing
/// </summary>
/// <param name="version">The version to upgrade the server to</param>
/// <param name="scheduleUpgradeAfter">The earliest time to upgrade the server</param>
/// <param name="recommendedDatabase">The database to map to new edition and SLO. Target SLO and edition are in the constants at the top of this file</param>
/// <param name="databaseInElasticPool">The database to be put in new elastic pool. Elastic pool properties are in the constants at the top of this file</param>
/// <returns>The server upgrade start parameters object</returns>
private ServerUpgradeStartParameters CreateUpgradeStartParameters(
string version = upgradedVersion,
DateTime?scheduleUpgradeAfter = null,
Database recommendedDatabase = null,
Database databaseInElasticPool = null)
{
var parameters = new ServerUpgradeStartParameters()
{
Properties = new ServerUpgradeProperties()
{
Version = version,
ScheduleUpgradeAfterUtcDateTime = scheduleUpgradeAfter
}
};
if (recommendedDatabase != null)
{
parameters.Properties.DatabaseCollection = new List <RecommendedDatabaseProperties>()
{
new RecommendedDatabaseProperties()
{
Name = recommendedDatabase.Name,
TargetServiceLevelObjective = targetServiceLevelObjective,
TargetEdition = targetEdition
}
};
}
if (databaseInElasticPool != null)
{
parameters.Properties.ElasticPoolCollection = new List <UpgradeRecommendedElasticPoolProperties>()
{
// Create an elastic pool with default values and contain only the provided database
new UpgradeRecommendedElasticPoolProperties()
{
Name = TestUtilities.GenerateName("csm-ep-"),
Edition = targetEdition,
Dtu = defaultElasticPoolDtu,
StorageMb = defaultElasticPoolStorageMb,
DatabaseDtuMax = defaultElasticPoolDatabaseDtuMax,
DatabaseDtuMin = defaultElasticPoolDatabaseDtuMin,
DatabaseCollection = new List <string>()
{
databaseInElasticPool.Name
}
}
};
}
return(parameters);
}
/// <summary>
/// Start a server upgrade
/// </summary>
/// <param name="model">The server upgrade model to start the upgrade</param>
public void Start(AzureSqlServerUpgradeStartModel model)
{
ServerUpgradeStartParameters parameters = new ServerUpgradeStartParameters()
{
Properties = new ServerUpgradeProperties()
{
Version = model.ServerVersion,
ScheduleUpgradeAfterUtcDateTime = model.ScheduleUpgradeAfterUtcDateTime,
DatabaseCollection = model.DatabaseCollection
}
};
Communicator.Start(model.ResourceGroupName, model.ServerName, parameters, Util.GenerateTracingId());
}
/// <summary>
/// Start an Azure Sql Database Server Upgrade
/// </summary>
public void Start(string resourceGroupName, string serverName, ServerUpgradeStartParameters parameters, string clientRequestId)
{
GetCurrentSqlClient(clientRequestId).ServerUpgrades.Start(resourceGroupName, serverName, parameters);
}
/// <summary>
/// Start an Azure SQL Database Server Upgrade.
/// </summary>
/// <param name='operations'>
/// Reference to the
/// Microsoft.Azure.Management.Sql.IServerUpgradeOperations.
/// </param>
/// <param name='resourceGroupName'>
/// Required. The name of the Resource Group to which the server
/// belongs.
/// </param>
/// <param name='serverName'>
/// Required. The name of the Azure SQL Database Server to upgrade.
/// </param>
/// <param name='parameters'>
/// Required. The required parameters for the Azure SQL Database Server
/// Upgrade.
/// </param>
/// <returns>
/// A standard service response including an HTTP status code and
/// request ID.
/// </returns>
public static Task <AzureOperationResponse> StartAsync(this IServerUpgradeOperations operations, string resourceGroupName, string serverName, ServerUpgradeStartParameters parameters)
{
return(operations.StartAsync(resourceGroupName, serverName, parameters, CancellationToken.None));
}
/// <summary>
/// Start an Azure SQL Database Server Upgrade.
/// </summary>
/// <param name='operations'>
/// Reference to the
/// Microsoft.Azure.Management.Sql.IServerUpgradeOperations.
/// </param>
/// <param name='resourceGroupName'>
/// Required. The name of the Resource Group to which the server
/// belongs.
/// </param>
/// <param name='serverName'>
/// Required. The name of the Azure SQL Database Server to upgrade.
/// </param>
/// <param name='parameters'>
/// Required. The required parameters for the Azure SQL Database Server
/// Upgrade.
/// </param>
/// <returns>
/// A standard service response including an HTTP status code and
/// request ID.
/// </returns>
public static AzureOperationResponse Start(this IServerUpgradeOperations operations, string resourceGroupName, string serverName, ServerUpgradeStartParameters parameters)
{
return(Task.Factory.StartNew((object s) =>
{
return ((IServerUpgradeOperations)s).StartAsync(resourceGroupName, serverName, parameters);
}
, operations, CancellationToken.None, TaskCreationOptions.None, TaskScheduler.Default).Unwrap().GetAwaiter().GetResult());
}
/// <summary>
/// Start an Azure SQL Database Server Upgrade.
/// </summary>
/// <param name='resourceGroupName'>
/// Required. The name of the Resource Group to which the server
/// belongs.
/// </param>
/// <param name='serverName'>
/// Required. The name of the Azure SQL Database Server to upgrade.
/// </param>
/// <param name='parameters'>
/// Required. The required parameters for the Azure SQL Database Server
/// Upgrade.
/// </param>
/// <param name='cancellationToken'>
/// Cancellation token.
/// </param>
/// <returns>
/// A standard service response including an HTTP status code and
/// request ID.
/// </returns>
public async Task <AzureOperationResponse> StartAsync(string resourceGroupName, string serverName, ServerUpgradeStartParameters parameters, CancellationToken cancellationToken)
{
// Validate
if (resourceGroupName == null)
{
throw new ArgumentNullException("resourceGroupName");
}
if (serverName == null)
{
throw new ArgumentNullException("serverName");
}
if (parameters == null)
{
throw new ArgumentNullException("parameters");
}
if (parameters.Properties == null)
{
throw new ArgumentNullException("parameters.Properties");
}
if (parameters.Properties.Version == null)
{
throw new ArgumentNullException("parameters.Properties.Version");
}
// Tracing
bool shouldTrace = TracingAdapter.IsEnabled;
string invocationId = null;
if (shouldTrace)
{
invocationId = TracingAdapter.NextInvocationId.ToString();
Dictionary <string, object> tracingParameters = new Dictionary <string, object>();
tracingParameters.Add("resourceGroupName", resourceGroupName);
tracingParameters.Add("serverName", serverName);
tracingParameters.Add("parameters", parameters);
TracingAdapter.Enter(invocationId, this, "StartAsync", tracingParameters);
}
// Construct URL
string url = "";
url = url + "/subscriptions/";
if (this.Client.Credentials.SubscriptionId != null)
{
url = url + Uri.EscapeDataString(this.Client.Credentials.SubscriptionId);
}
url = url + "/resourceGroups/";
url = url + Uri.EscapeDataString(resourceGroupName);
url = url + "/providers/";
url = url + "Microsoft.Sql";
url = url + "/servers/";
url = url + Uri.EscapeDataString(serverName);
url = url + "/upgrade";
List <string> queryParameters = new List <string>();
queryParameters.Add("api-version=2014-04-01");
if (queryParameters.Count > 0)
{
url = url + "?" + string.Join("&", queryParameters);
}
string baseUrl = this.Client.BaseUri.AbsoluteUri;
// Trim '/' character from the end of baseUrl and beginning of url.
if (baseUrl[baseUrl.Length - 1] == '/')
{
baseUrl = baseUrl.Substring(0, baseUrl.Length - 1);
}
if (url[0] == '/')
{
url = url.Substring(1);
}
url = baseUrl + "/" + url;
url = url.Replace(" ", "%20");
// Create HTTP transport objects
HttpRequestMessage httpRequest = null;
try
{
httpRequest = new HttpRequestMessage();
httpRequest.Method = HttpMethod.Post;
httpRequest.RequestUri = new Uri(url);
// Set Headers
// Set Credentials
cancellationToken.ThrowIfCancellationRequested();
await this.Client.Credentials.ProcessHttpRequestAsync(httpRequest, cancellationToken).ConfigureAwait(false);
// Serialize Request
string requestContent = null;
JToken requestDoc = null;
JObject serverUpgradeStartParametersValue = new JObject();
requestDoc = serverUpgradeStartParametersValue;
JObject serverUpgradePropertiesValue = new JObject();
serverUpgradeStartParametersValue["serverUpgradeProperties"] = serverUpgradePropertiesValue;
serverUpgradePropertiesValue["Version"] = parameters.Properties.Version;
if (parameters.Properties.ScheduleUpgradeAfterUtcDateTime != null)
{
serverUpgradePropertiesValue["ScheduleUpgradeAfterUtcDateTime"] = parameters.Properties.ScheduleUpgradeAfterUtcDateTime.Value;
}
if (parameters.Properties.DatabaseCollection != null)
{
if (parameters.Properties.DatabaseCollection is ILazyCollection == false || ((ILazyCollection)parameters.Properties.DatabaseCollection).IsInitialized)
{
JArray databaseCollectionArray = new JArray();
foreach (RecommendedDatabaseProperties databaseCollectionItem in parameters.Properties.DatabaseCollection)
{
JObject recommendedDatabasePropertiesValue = new JObject();
databaseCollectionArray.Add(recommendedDatabasePropertiesValue);
if (databaseCollectionItem.Name != null)
{
recommendedDatabasePropertiesValue["Name"] = databaseCollectionItem.Name;
}
if (databaseCollectionItem.TargetEdition != null)
{
recommendedDatabasePropertiesValue["TargetEdition"] = databaseCollectionItem.TargetEdition;
}
if (databaseCollectionItem.TargetServiceLevelObjective != null)
{
recommendedDatabasePropertiesValue["TargetServiceLevelObjective"] = databaseCollectionItem.TargetServiceLevelObjective;
}
}
serverUpgradePropertiesValue["DatabaseCollection"] = databaseCollectionArray;
}
}
if (parameters.Properties.ElasticPoolCollection != null)
{
if (parameters.Properties.ElasticPoolCollection is ILazyCollection == false || ((ILazyCollection)parameters.Properties.ElasticPoolCollection).IsInitialized)
{
JArray elasticPoolCollectionArray = new JArray();
foreach (UpgradeRecommendedElasticPoolProperties elasticPoolCollectionItem in parameters.Properties.ElasticPoolCollection)
{
JObject upgradeRecommendedElasticPoolPropertiesValue = new JObject();
elasticPoolCollectionArray.Add(upgradeRecommendedElasticPoolPropertiesValue);
if (elasticPoolCollectionItem.Name != null)
{
upgradeRecommendedElasticPoolPropertiesValue["Name"] = elasticPoolCollectionItem.Name;
}
if (elasticPoolCollectionItem.Edition != null)
{
upgradeRecommendedElasticPoolPropertiesValue["Edition"] = elasticPoolCollectionItem.Edition;
}
upgradeRecommendedElasticPoolPropertiesValue["Dtu"] = elasticPoolCollectionItem.Dtu;
upgradeRecommendedElasticPoolPropertiesValue["StorageMb"] = elasticPoolCollectionItem.StorageMb;
upgradeRecommendedElasticPoolPropertiesValue["DatabaseDtuMin"] = elasticPoolCollectionItem.DatabaseDtuMin;
upgradeRecommendedElasticPoolPropertiesValue["DatabaseDtuMax"] = elasticPoolCollectionItem.DatabaseDtuMax;
if (elasticPoolCollectionItem.DatabaseCollection != null)
{
if (elasticPoolCollectionItem.DatabaseCollection is ILazyCollection == false || ((ILazyCollection)elasticPoolCollectionItem.DatabaseCollection).IsInitialized)
{
JArray databaseCollectionArray2 = new JArray();
foreach (string databaseCollectionItem2 in elasticPoolCollectionItem.DatabaseCollection)
{
databaseCollectionArray2.Add(databaseCollectionItem2);
}
upgradeRecommendedElasticPoolPropertiesValue["DatabaseCollection"] = databaseCollectionArray2;
}
}
if (elasticPoolCollectionItem.IncludeAllDatabases != null)
{
upgradeRecommendedElasticPoolPropertiesValue["IncludeAllDatabases"] = elasticPoolCollectionItem.IncludeAllDatabases.Value;
}
}
serverUpgradePropertiesValue["ElasticPoolCollection"] = elasticPoolCollectionArray;
}
}
requestContent = requestDoc.ToString(Newtonsoft.Json.Formatting.Indented);
httpRequest.Content = new StringContent(requestContent, Encoding.UTF8);
httpRequest.Content.Headers.ContentType = MediaTypeHeaderValue.Parse("application/json; charset=utf-8");
// Send Request
HttpResponseMessage httpResponse = null;
try
{
if (shouldTrace)
{
TracingAdapter.SendRequest(invocationId, httpRequest);
}
cancellationToken.ThrowIfCancellationRequested();
httpResponse = await this.Client.HttpClient.SendAsync(httpRequest, cancellationToken).ConfigureAwait(false);
if (shouldTrace)
{
TracingAdapter.ReceiveResponse(invocationId, httpResponse);
}
HttpStatusCode statusCode = httpResponse.StatusCode;
if (statusCode != HttpStatusCode.Accepted)
{
cancellationToken.ThrowIfCancellationRequested();
CloudException ex = CloudException.Create(httpRequest, requestContent, httpResponse, await httpResponse.Content.ReadAsStringAsync().ConfigureAwait(false));
if (shouldTrace)
{
TracingAdapter.Error(invocationId, ex);
}
throw ex;
}
// Create Result
AzureOperationResponse result = null;
// Deserialize Response
result = new AzureOperationResponse();
result.StatusCode = statusCode;
if (httpResponse.Headers.Contains("x-ms-request-id"))
{
result.RequestId = httpResponse.Headers.GetValues("x-ms-request-id").FirstOrDefault();
}
if (shouldTrace)
{
TracingAdapter.Exit(invocationId, result);
}
return(result);
}
finally
{
if (httpResponse != null)
{
httpResponse.Dispose();
}
}
}
finally
{
if (httpRequest != null)
{
httpRequest.Dispose();
}
}
}
