/// <summary>
/// Retrieves the list of all operations on the database.
/// </summary>
/// <param name="databaseName">The name of database to retrieve operations.</param>
/// <returns>An array of all operations on the database.</returns>
public DatabaseOperation[] GetDatabaseOperations(string databaseName)
{
this.clientRequestId = SqlDatabaseCmdletBase.GenerateClientTracingId();
// Get the SQL management client
SqlManagementClient sqlManagementClient = this.subscription.CreateClient <SqlManagementClient>();
this.AddTracingHeaders(sqlManagementClient);
// Retrieve all operations on specified database
DatabaseOperationListResponse response = sqlManagementClient.DatabaseOperations.ListByDatabase(
this.serverName,
databaseName);
// For any database which has ever been created, there should be at least one operation
if (response.Count() == 0)
{
throw new InvalidOperationException(
string.Format(
CultureInfo.InvariantCulture,
Resources.DatabaseOperationNotFoundOnDatabase,
this.ServerName,
databaseName));
}
// Construct the resulting database operations
DatabaseOperation[] operations = response.Select(operation => CreateDatabaseOperationsFromResponse(operation)).ToArray();
return(operations);
}
private DatabaseOperation[] CreateDatabaseOperationsFromResponse(DatabaseOperationListResponse response)
{
return(response.DatabaseOperations.Select(dbOperation => CreateDatabaseOperation(
dbOperation.Name,
dbOperation.State,
dbOperation.Id,
dbOperation.StateId,
dbOperation.SessionActivityId,
dbOperation.DatabaseName,
dbOperation.PercentComplete,
dbOperation.ErrorCode,
dbOperation.Error,
dbOperation.ErrorSeverity,
dbOperation.ErrorState,
dbOperation.StartTime,
dbOperation.LastModifyTime)).ToArray());
}
/// <summary>
/// Retrieves the list of all databases' operations on the server.
/// </summary>
/// <returns>An array of all operations on the server.</returns>
public DatabaseOperation[] GetDatabasesOperations()
{
this.clientRequestId = SqlDatabaseCmdletBase.GenerateClientTracingId();
// Get the SQL management client
SqlManagementClient sqlManagementClient = this.subscription.CreateClient <SqlManagementClient>();
this.AddTracingHeaders(sqlManagementClient);
// Retrieve the operations on specified server
// We do not validate the number of operations returned since it's possible that there is no
// database operations on a new created server.
DatabaseOperationListResponse response = sqlManagementClient.DatabaseOperations.ListByServer(
this.serverName);
// Construct the resulting database operations array
DatabaseOperation[] operations = response.Select(operation => CreateDatabaseOperationsFromResponse(operation)).ToArray();
return(operations);
}
/// <summary>
/// Retrieves all of the operations that occured on the Azure SQL
/// Database Server.
/// </summary>
/// <param name='serverName'>
/// Required. The name of the Azure SQL Database Server to be queried.
/// </param>
/// <param name='cancellationToken'>
/// Cancellation token.
/// </param>
/// <returns>
/// Represents the response containing the list of database operations
/// for a given server or database.
/// </returns>
public async System.Threading.Tasks.Task <Microsoft.WindowsAzure.Management.Sql.Models.DatabaseOperationListResponse> ListByServerAsync(string serverName, CancellationToken cancellationToken)
{
// Validate
if (serverName == null)
{
throw new ArgumentNullException("serverName");
}
// Tracing
bool shouldTrace = CloudContext.Configuration.Tracing.IsEnabled;
string invocationId = null;
if (shouldTrace)
{
invocationId = Tracing.NextInvocationId.ToString();
Dictionary <string, object> tracingParameters = new Dictionary <string, object>();
tracingParameters.Add("serverName", serverName);
Tracing.Enter(invocationId, this, "ListByServerAsync", tracingParameters);
}
// Construct URL
string url = (this.Client.Credentials.SubscriptionId != null ? this.Client.Credentials.SubscriptionId.Trim() : "") + "/services/sqlservers/servers/" + serverName.Trim() + "/databaseoperations?contentview=generic";
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.Get;
httpRequest.RequestUri = new Uri(url);
// Set Headers
httpRequest.Headers.Add("x-ms-version", "2012-03-01");
// Set Credentials
cancellationToken.ThrowIfCancellationRequested();
await this.Client.Credentials.ProcessHttpRequestAsync(httpRequest, cancellationToken).ConfigureAwait(false);
// Send Request
HttpResponseMessage httpResponse = null;
try
{
if (shouldTrace)
{
Tracing.SendRequest(invocationId, httpRequest);
}
cancellationToken.ThrowIfCancellationRequested();
httpResponse = await this.Client.HttpClient.SendAsync(httpRequest, cancellationToken).ConfigureAwait(false);
if (shouldTrace)
{
Tracing.ReceiveResponse(invocationId, httpResponse);
}
HttpStatusCode statusCode = httpResponse.StatusCode;
if (statusCode != HttpStatusCode.OK)
{
cancellationToken.ThrowIfCancellationRequested();
CloudException ex = CloudException.Create(httpRequest, null, httpResponse, await httpResponse.Content.ReadAsStringAsync().ConfigureAwait(false));
if (shouldTrace)
{
Tracing.Error(invocationId, ex);
}
throw ex;
}
// Create Result
DatabaseOperationListResponse result = null;
// Deserialize Response
cancellationToken.ThrowIfCancellationRequested();
string responseContent = await httpResponse.Content.ReadAsStringAsync().ConfigureAwait(false);
result = new DatabaseOperationListResponse();
XDocument responseDoc = XDocument.Parse(responseContent);
XElement serviceResourcesSequenceElement = responseDoc.Element(XName.Get("ServiceResources", "http://schemas.microsoft.com/windowsazure"));
if (serviceResourcesSequenceElement != null)
{
result.DatabaseOperations = new List <DatabaseOperation>();
foreach (XElement serviceResourcesElement in serviceResourcesSequenceElement.Elements(XName.Get("ServiceResource", "http://schemas.microsoft.com/windowsazure")))
{
DatabaseOperation serviceResourceInstance = new DatabaseOperation();
result.DatabaseOperations.Add(serviceResourceInstance);
XElement idElement = serviceResourcesElement.Element(XName.Get("Id", "http://schemas.microsoft.com/windowsazure"));
if (idElement != null)
{
string idInstance = idElement.Value;
serviceResourceInstance.Id = idInstance;
}
XElement stateIdElement = serviceResourcesElement.Element(XName.Get("StateId", "http://schemas.microsoft.com/windowsazure"));
if (stateIdElement != null)
{
int stateIdInstance = int.Parse(stateIdElement.Value, CultureInfo.InvariantCulture);
serviceResourceInstance.StateId = stateIdInstance;
}
XElement sessionActivityIdElement = serviceResourcesElement.Element(XName.Get("SessionActivityId", "http://schemas.microsoft.com/windowsazure"));
if (sessionActivityIdElement != null)
{
string sessionActivityIdInstance = sessionActivityIdElement.Value;
serviceResourceInstance.SessionActivityId = sessionActivityIdInstance;
}
XElement databaseNameElement = serviceResourcesElement.Element(XName.Get("DatabaseName", "http://schemas.microsoft.com/windowsazure"));
if (databaseNameElement != null)
{
string databaseNameInstance = databaseNameElement.Value;
serviceResourceInstance.DatabaseName = databaseNameInstance;
}
XElement percentCompleteElement = serviceResourcesElement.Element(XName.Get("PercentComplete", "http://schemas.microsoft.com/windowsazure"));
if (percentCompleteElement != null)
{
int percentCompleteInstance = int.Parse(percentCompleteElement.Value, CultureInfo.InvariantCulture);
serviceResourceInstance.PercentComplete = percentCompleteInstance;
}
XElement errorCodeElement = serviceResourcesElement.Element(XName.Get("ErrorCode", "http://schemas.microsoft.com/windowsazure"));
if (errorCodeElement != null)
{
int errorCodeInstance = int.Parse(errorCodeElement.Value, CultureInfo.InvariantCulture);
serviceResourceInstance.ErrorCode = errorCodeInstance;
}
XElement errorElement = serviceResourcesElement.Element(XName.Get("Error", "http://schemas.microsoft.com/windowsazure"));
if (errorElement != null)
{
string errorInstance = errorElement.Value;
serviceResourceInstance.Error = errorInstance;
}
XElement errorSeverityElement = serviceResourcesElement.Element(XName.Get("ErrorSeverity", "http://schemas.microsoft.com/windowsazure"));
if (errorSeverityElement != null)
{
int errorSeverityInstance = int.Parse(errorSeverityElement.Value, CultureInfo.InvariantCulture);
serviceResourceInstance.ErrorSeverity = errorSeverityInstance;
}
XElement errorStateElement = serviceResourcesElement.Element(XName.Get("ErrorState", "http://schemas.microsoft.com/windowsazure"));
if (errorStateElement != null)
{
int errorStateInstance = int.Parse(errorStateElement.Value, CultureInfo.InvariantCulture);
serviceResourceInstance.ErrorState = errorStateInstance;
}
XElement startTimeElement = serviceResourcesElement.Element(XName.Get("StartTime", "http://schemas.microsoft.com/windowsazure"));
if (startTimeElement != null)
{
DateTime startTimeInstance = DateTime.Parse(startTimeElement.Value, CultureInfo.InvariantCulture);
serviceResourceInstance.StartTime = startTimeInstance;
}
XElement lastModifyTimeElement = serviceResourcesElement.Element(XName.Get("LastModifyTime", "http://schemas.microsoft.com/windowsazure"));
if (lastModifyTimeElement != null)
{
DateTime lastModifyTimeInstance = DateTime.Parse(lastModifyTimeElement.Value, CultureInfo.InvariantCulture);
serviceResourceInstance.LastModifyTime = lastModifyTimeInstance;
}
XElement nameElement = serviceResourcesElement.Element(XName.Get("Name", "http://schemas.microsoft.com/windowsazure"));
if (nameElement != null)
{
string nameInstance = nameElement.Value;
serviceResourceInstance.Name = nameInstance;
}
XElement typeElement = serviceResourcesElement.Element(XName.Get("Type", "http://schemas.microsoft.com/windowsazure"));
if (typeElement != null)
{
string typeInstance = typeElement.Value;
serviceResourceInstance.Type = typeInstance;
}
XElement stateElement = serviceResourcesElement.Element(XName.Get("State", "http://schemas.microsoft.com/windowsazure"));
if (stateElement != null)
{
string stateInstance = stateElement.Value;
serviceResourceInstance.State = stateInstance;
}
}
}
result.StatusCode = statusCode;
if (httpResponse.Headers.Contains("x-ms-request-id"))
{
result.RequestId = httpResponse.Headers.GetValues("x-ms-request-id").FirstOrDefault();
}
if (shouldTrace)
{
Tracing.Exit(invocationId, result);
}
return(result);
}
finally
{
if (httpResponse != null)
{
httpResponse.Dispose();
}
}
}
finally
{
if (httpRequest != null)
{
httpRequest.Dispose();
}
}
}
private DatabaseOperation[] CreateDatabaseOperationsFromResponse(DatabaseOperationListResponse response)
{
return response.DatabaseOperations.Select(dbOperation => CreateDatabaseOperation(
dbOperation.Name,
dbOperation.State,
dbOperation.Id,
dbOperation.StateId,
dbOperation.SessionActivityId,
dbOperation.DatabaseName,
dbOperation.PercentComplete,
dbOperation.ErrorCode,
dbOperation.Error,
dbOperation.ErrorSeverity,
dbOperation.ErrorState,
dbOperation.StartTime,
dbOperation.LastModifyTime)).ToArray();
}
private DatabaseOperation CreateDatabaseOperationsFromResponse(DatabaseOperationListResponse.DatabaseOperation response)
{
return CreateDatabaseOperation(
response.Name,
response.State,
response.Id,
response.StateId,
response.SessionActivityId,
response.DatabaseName,
response.PercentComplete,
response.ErrorCode,
response.Error,
response.ErrorSeverity,
response.ErrorState,
response.StartTime,
response.LastModifyTime
);
}
