internal IEnumerable <AzureSqlDatabaseActivityModel> ListDatabaseActivity(string resourceGroupName, string serverName, string elasticPoolName, string databaseName, Guid?operationId) { if (!string.IsNullOrEmpty(elasticPoolName)) { var response = ElasticPoolCommunicator.ListDatabaseActivity(resourceGroupName, serverName, elasticPoolName, Util.GenerateTracingId()); IEnumerable <AzureSqlDatabaseActivityModel> list = response.Select((r) => { return(new AzureSqlDatabaseActivityModel() { DatabaseName = r.Properties.DatabaseName, EndTime = r.Properties.EndTime, ErrorCode = r.Properties.ErrorCode, ErrorMessage = r.Properties.ErrorMessage, ErrorSeverity = r.Properties.ErrorSeverity, Operation = r.Properties.Operation, OperationId = r.Properties.OperationId, PercentComplete = r.Properties.PercentComplete, ServerName = r.Properties.ServerName, StartTime = r.Properties.StartTime, State = r.Properties.State, Properties = new AzureSqlDatabaseActivityModel.DatabaseState() { Current = new Dictionary <string, string>() { { "CurrentElasticPoolName", r.Properties.CurrentElasticPoolName }, { "CurrentServiceObjectiveName", r.Properties.CurrentServiceObjectiveName }, }, Requested = new Dictionary <string, string>() { { "RequestedElasticPoolName", r.Properties.RequestedElasticPoolName }, { "RequestedServiceObjectiveName", r.Properties.RequestedServiceObjectiveName }, } } }); }); // Check if we have a database name constraint if (!string.IsNullOrEmpty(databaseName)) { list = list.Where(pl => string.Equals(pl.DatabaseName, databaseName, StringComparison.OrdinalIgnoreCase)); } return(list.ToList()); } else { throw new NotSupportedException(string.Format(CultureInfo.InvariantCulture, Microsoft.Azure.Commands.Sql.Properties.Resources.StandaloneDatabaseActivityNotSupported)); } }
internal IEnumerable <AzureSqlDatabaseActivityModel> ListDatabaseActivity(string resourceGroupName, string serverName, string elasticPoolName, string databaseName, Guid?operationId) { List <AzureSqlDatabaseActivityModel> list = new List <AzureSqlDatabaseActivityModel>(); if (!string.IsNullOrEmpty(elasticPoolName)) { var response = ElasticPoolCommunicator.ListDatabaseActivity(resourceGroupName, serverName, elasticPoolName, Util.GenerateTracingId()); list = response.Select((r) => { return(new AzureSqlDatabaseActivityModel() { DatabaseName = r.Properties.DatabaseName, EndTime = r.Properties.EndTime, ErrorCode = r.Properties.ErrorCode, ErrorMessage = r.Properties.ErrorMessage, ErrorSeverity = r.Properties.ErrorSeverity, Operation = r.Properties.Operation, OperationId = r.Properties.OperationId, PercentComplete = r.Properties.PercentComplete, ServerName = r.Properties.ServerName, StartTime = r.Properties.StartTime, State = r.Properties.State, Properties = new AzureSqlDatabaseActivityModel.DatabaseState() { Current = new Dictionary <string, string>() { { "CurrentElasticPoolName", r.Properties.CurrentElasticPoolName }, { "CurrentServiceObjectiveName", r.Properties.CurrentServiceObjectiveName }, }, Requested = new Dictionary <string, string>() { { "RequestedElasticPoolName", r.Properties.RequestedElasticPoolName }, { "RequestedServiceObjectiveName", r.Properties.RequestedServiceObjectiveName }, } } }); }).ToList(); } else { } return(list); }
internal IEnumerable <AzureSqlDatabaseActivityModel> ListDatabaseActivity(string resourceGroupName, string serverName, string elasticPoolName, string databaseName, Guid?operationId) { if (!string.IsNullOrEmpty(elasticPoolName)) { var response = ElasticPoolCommunicator.ListDatabaseActivity(resourceGroupName, serverName, elasticPoolName); IEnumerable <AzureSqlDatabaseActivityModel> list = response.Select((r) => { return(new AzureSqlDatabaseActivityModel() { DatabaseName = r.DatabaseName, EndTime = r.EndTime, ErrorCode = r.ErrorCode, ErrorMessage = r.ErrorMessage, ErrorSeverity = r.ErrorSeverity, Operation = r.Operation, OperationId = r.OperationId, PercentComplete = r.PercentComplete, ServerName = r.ServerName, StartTime = r.StartTime, State = r.State, Properties = new AzureSqlDatabaseActivityModel.DatabaseState() { Current = new Dictionary <string, string>() { { "CurrentElasticPoolName", r.CurrentElasticPoolName }, { "CurrentServiceObjectiveName", r.CurrentServiceObjective }, }, Requested = new Dictionary <string, string>() { { "RequestedElasticPoolName", r.RequestedElasticPoolName }, { "RequestedServiceObjectiveName", r.RequestedServiceObjective }, } } }); }); // Check if we have a database name constraint if (!string.IsNullOrEmpty(databaseName)) { list = list.Where(pl => string.Equals(pl.DatabaseName, databaseName, StringComparison.OrdinalIgnoreCase)); } return(list.ToList()); } else { var response = Communicator.ListOperations(resourceGroupName, serverName, databaseName); IEnumerable <AzureSqlDatabaseActivityModel> list = response.Select((r) => { return(new AzureSqlDatabaseActivityModel() { DatabaseName = r.DatabaseName, ErrorCode = r.ErrorCode, ErrorMessage = r.ErrorDescription, ErrorSeverity = r.ErrorSeverity, Operation = r.Operation, OperationId = Guid.Parse(r.Name), PercentComplete = r.PercentComplete, ServerName = r.ServerName, StartTime = r.StartTime, State = r.State, Properties = new AzureSqlDatabaseActivityModel.DatabaseState() { Current = new Dictionary <string, string>(), Requested = new Dictionary <string, string>() }, EstimatedCompletionTime = r.EstimatedCompletionTime, Description = r.Description, IsCancellable = r.IsCancellable }); }); // Check if we have a operation id constraint if (operationId.HasValue) { list = list.Where(pl => Guid.Equals(pl.OperationId, operationId)); } return(list.ToList()); } }