/// <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 ); }