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