protected override void ProcessRecord() { base.ProcessRecord(); ListDbVersionsRequest request; try { request = new ListDbVersionsRequest { CompartmentId = CompartmentId, Limit = Limit, Page = Page, DbSystemShape = DbSystemShape, DbSystemId = DbSystemId, StorageManagement = StorageManagement, IsUpgradeSupported = IsUpgradeSupported, IsDatabaseSoftwareImageSupported = IsDatabaseSoftwareImageSupported }; IEnumerable <ListDbVersionsResponse> responses = GetRequestDelegate().Invoke(request); foreach (var item in responses) { response = item; WriteOutput(response, response.Items, true); } if (!ParameterSetName.Equals(AllPageSet) && !ParameterSetName.Equals(LimitSet) && response.OpcNextPage != null) { WriteWarning("This operation supports pagination and not all resources were returned. Re-run using the -All option to auto paginate and list all resources."); } FinishProcessing(response); } catch (Exception ex) { TerminatingErrorDuringExecution(ex); } }
protected override void ProcessRecord() { base.ProcessRecord(); ListDbVersionsRequest request; try { request = new ListDbVersionsRequest { CompartmentId = CompartmentId, Limit = Limit, Page = Page, DbSystemShape = DbSystemShape, DbSystemId = DbSystemId, StorageManagement = StorageManagement }; IEnumerable <ListDbVersionsResponse> responses = GetRequestDelegate().Invoke(request); foreach (var item in responses) { response = item; WriteOutput(response, response.Items, true); } FinishProcessing(response); } catch (Exception ex) { TerminatingErrorDuringExecution(ex); } }
/// <summary> /// Gets a list of supported Oracle Database versions. /// </summary> /// <param name="request"></param> /// <returns></returns> public async Task <ListDbVersionsResponse> ListDbVersions(ListDbVersionsRequest request) { var uri = new Uri($"{GetEndPoint(DatabaseServices.DbVersions, this.Region)}?{request.GetOptionQuery()}"); using (var webResponse = await this.RestClientAsync.Get(uri)) using (var stream = webResponse.GetResponseStream()) using (var reader = new StreamReader(stream)) { var response = await reader.ReadToEndAsync(); return(new ListDbVersionsResponse() { Items = this.JsonSerializer.Deserialize <List <DbVersionSummary> >(response), OpcRequestId = webResponse.Headers.Get("opc-request-id"), OpcNextPage = webResponse.Headers.Get("opc-next-page") }); } }
public static void DatabaseConsoleDisplay(ClientConfig config) { var identityClient = new IdentityClient(config) { Region = Regions.US_ASHBURN_1 }; var databaseClient = new DatabaseClient(config); var listCompartmentRequest = new ListCompartmentRequest() { CompartmentId = config.TenancyId, CompartmentIdInSubtree = true, AccessLevel = ListCompartmentRequest.AccessLevels.ACCESSIBLE }; var compartments = identityClient.ListCompartment(listCompartmentRequest).Items; Console.WriteLine("* Database------------------------"); foreach (var com in compartments) { if (com.LifecycleState != "ACTIVE") { continue; } var listDbHomesRequest = new ListDbHomesRequest() { CompartmentId = com.Id, }; var dbHomes = databaseClient.ListDbHomes(listDbHomesRequest).Items; foreach (var home in dbHomes) { Console.WriteLine($" DatabaseHome: {home.DisplayName}"); var listDatabasesRequest = new ListDatabasesRequest() { CompartmentId = com.Id, DbHomeId = home.Id }; var databases = databaseClient.ListDatabases(listDatabasesRequest).Items; foreach (var database in databases) { Console.WriteLine($"\t|- name: {database.DbName}"); Console.WriteLine($"\t| state: {database.LifecycleState}"); Console.WriteLine($"\t| lifecycle: {database.LifecycleDetails}"); Console.WriteLine($"\t| time: {database.TimeCreated}"); } } } Console.WriteLine("* DatabaseShapes------------------------"); foreach (var com in compartments) { if (com.LifecycleState != "ACTIVE") { continue; } var listDbSystemShapesRequest = new ListDbSystemShapesRequest() { CompartmentId = com.Id }; var dbShapes = databaseClient.ListDbSystemShapes(listDbSystemShapesRequest).Items; foreach (var shape in dbShapes) { Console.WriteLine($"\t|- name: {shape.Name}"); Console.WriteLine($"\t| shape: {shape.Shape}"); Console.WriteLine($"\t| shapeFamily: {shape.ShapeFamily}"); Console.WriteLine($"\t| availableCoreCount: {shape.AvailableCoreCount}"); Console.WriteLine($"\t| coreCountIncrement: {shape.CoreCountIncrement}"); Console.WriteLine($"\t| maximumNodeCount: {shape.MaximumNodeCount}"); Console.WriteLine($"\t| minimumCoreCount: {shape.MinimumCoreCount}"); Console.WriteLine($"\t| minimumNodeCount: {shape.MinimumNodeCount}"); } } Console.WriteLine("* DatabaseVersions------------------------"); foreach (var com in compartments) { if (com.LifecycleState != "ACTIVE") { continue; } var listDbVersionsRequest = new ListDbVersionsRequest() { CompartmentId = com.Id }; var dbVersions = databaseClient.ListDbVersions(listDbVersionsRequest).Items; foreach (var version in dbVersions) { Console.WriteLine($"\t|- version: {version.Version}"); Console.WriteLine($"\t| supportsPdb: {version.SupportsPdb}"); Console.WriteLine($"\t| isLatestForMajorVersion: {version.IsLatestForMajorVersion}"); } } }