Oracle Cloud Infrastructure

v0.5.0 published on Monday, Sep 12, 2022 by Pulumi

getDatabaseUpgradeHistoryEntries

This data source provides the list of Database Upgrade History Entries in Oracle Cloud Infrastructure Database service.

Gets the upgrade history for a specified database in a bare metal or virtual machine DB system.

Example Usage

using System.Collections.Generic;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testDatabaseUpgradeHistoryEntries = Oci.Database.GetDatabaseUpgradeHistoryEntries.Invoke(new()
    {
        DatabaseId = oci_database_database.Test_database.Id,
        State = @var.Database_upgrade_history_entry_state,
        UpgradeAction = @var.Database_upgrade_history_entry_upgrade_action,
    });

});

package main

import (
	"github.com/pulumi/pulumi-oci/sdk/go/oci/Database"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := Database.GetDatabaseUpgradeHistoryEntries(ctx, &database.GetDatabaseUpgradeHistoryEntriesArgs{
			DatabaseId:    oci_database_database.Test_database.Id,
			State:         pulumi.StringRef(_var.Database_upgrade_history_entry_state),
			UpgradeAction: pulumi.StringRef(_var.Database_upgrade_history_entry_upgrade_action),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.Database.DatabaseFunctions;
import com.pulumi.oci.Database.inputs.GetDatabaseUpgradeHistoryEntriesArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var testDatabaseUpgradeHistoryEntries = DatabaseFunctions.getDatabaseUpgradeHistoryEntries(GetDatabaseUpgradeHistoryEntriesArgs.builder()
            .databaseId(oci_database_database.test_database().id())
            .state(var_.database_upgrade_history_entry_state())
            .upgradeAction(var_.database_upgrade_history_entry_upgrade_action())
            .build());

    }
}

import pulumi
import pulumi_oci as oci

test_database_upgrade_history_entries = oci.Database.get_database_upgrade_history_entries(database_id=oci_database_database["test_database"]["id"],
    state=var["database_upgrade_history_entry_state"],
    upgrade_action=var["database_upgrade_history_entry_upgrade_action"])

import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testDatabaseUpgradeHistoryEntries = oci.Database.getDatabaseUpgradeHistoryEntries({
    databaseId: oci_database_database.test_database.id,
    state: _var.database_upgrade_history_entry_state,
    upgradeAction: _var.database_upgrade_history_entry_upgrade_action,
});

variables:
  testDatabaseUpgradeHistoryEntries:
    Fn::Invoke:
      Function: oci:Database:getDatabaseUpgradeHistoryEntries
      Arguments:
        databaseId: ${oci_database_database.test_database.id}
        state: ${var.database_upgrade_history_entry_state}
        upgradeAction: ${var.database_upgrade_history_entry_upgrade_action}

Using getDatabaseUpgradeHistoryEntries

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

function getDatabaseUpgradeHistoryEntries(args: GetDatabaseUpgradeHistoryEntriesArgs, opts?: InvokeOptions): Promise<GetDatabaseUpgradeHistoryEntriesResult>
function getDatabaseUpgradeHistoryEntriesOutput(args: GetDatabaseUpgradeHistoryEntriesOutputArgs, opts?: InvokeOptions): Output<GetDatabaseUpgradeHistoryEntriesResult>

def get_database_upgrade_history_entries(database_id: Optional[str] = None,
                                         filters: Optional[Sequence[_database.GetDatabaseUpgradeHistoryEntriesFilter]] = None,
                                         state: Optional[str] = None,
                                         upgrade_action: Optional[str] = None,
                                         opts: Optional[InvokeOptions] = None) -> GetDatabaseUpgradeHistoryEntriesResult
def get_database_upgrade_history_entries_output(database_id: Optional[pulumi.Input[str]] = None,
                                         filters: Optional[pulumi.Input[Sequence[pulumi.Input[_database.GetDatabaseUpgradeHistoryEntriesFilterArgs]]]] = None,
                                         state: Optional[pulumi.Input[str]] = None,
                                         upgrade_action: Optional[pulumi.Input[str]] = None,
                                         opts: Optional[InvokeOptions] = None) -> Output[GetDatabaseUpgradeHistoryEntriesResult]

func GetDatabaseUpgradeHistoryEntries(ctx *Context, args *GetDatabaseUpgradeHistoryEntriesArgs, opts ...InvokeOption) (*GetDatabaseUpgradeHistoryEntriesResult, error)
func GetDatabaseUpgradeHistoryEntriesOutput(ctx *Context, args *GetDatabaseUpgradeHistoryEntriesOutputArgs, opts ...InvokeOption) GetDatabaseUpgradeHistoryEntriesResultOutput

> Note: This function is named GetDatabaseUpgradeHistoryEntries in the Go SDK.

public static class GetDatabaseUpgradeHistoryEntries 
{
    public static Task<GetDatabaseUpgradeHistoryEntriesResult> InvokeAsync(GetDatabaseUpgradeHistoryEntriesArgs args, InvokeOptions? opts = null)
    public static Output<GetDatabaseUpgradeHistoryEntriesResult> Invoke(GetDatabaseUpgradeHistoryEntriesInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetDatabaseUpgradeHistoryEntriesResult> getDatabaseUpgradeHistoryEntries(GetDatabaseUpgradeHistoryEntriesArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

fn::invoke:
  function: oci:Database/getDatabaseUpgradeHistoryEntries:getDatabaseUpgradeHistoryEntries
  arguments:
    # arguments dictionary

The following arguments are supported:

DatabaseId string: The database OCID.
Filters List<GetDatabaseUpgradeHistoryEntriesFilter>
State string: A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.
UpgradeAction string: A filter to return only upgradeHistoryEntries that match the specified Upgrade Action.

DatabaseId string: The database OCID.
Filters []GetDatabaseUpgradeHistoryEntriesFilter
State string: A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.
UpgradeAction string: A filter to return only upgradeHistoryEntries that match the specified Upgrade Action.

databaseId String: The database OCID.
filters List<GetUpgradeHistoryEntriesFilter>
state String: A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.
upgradeAction String: A filter to return only upgradeHistoryEntries that match the specified Upgrade Action.

databaseId string: The database OCID.
filters GetDatabaseUpgradeHistoryEntriesFilter[]
state string: A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.
upgradeAction string: A filter to return only upgradeHistoryEntries that match the specified Upgrade Action.

database_id str: The database OCID.
filters GetDatabaseUpgradeHistoryEntriesFilter]
state str: A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.
upgrade_action str: A filter to return only upgradeHistoryEntries that match the specified Upgrade Action.

databaseId String: The database OCID.
filters List<Property Map>
state String: A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.
upgradeAction String: A filter to return only upgradeHistoryEntries that match the specified Upgrade Action.

getDatabaseUpgradeHistoryEntries Result

The following output properties are available:

DatabaseId string
DatabaseUpgradeHistoryEntries List<GetDatabaseUpgradeHistoryEntriesDatabaseUpgradeHistoryEntry>: The list of database_upgrade_history_entries.
Id string: The provider-assigned unique ID for this managed resource.
Filters List<GetDatabaseUpgradeHistoryEntriesFilter>
State string: Status of database upgrade history SUCCEEDED|IN_PROGRESS|FAILED.
UpgradeAction string

DatabaseId string
DatabaseUpgradeHistoryEntries []GetDatabaseUpgradeHistoryEntriesDatabaseUpgradeHistoryEntry: The list of database_upgrade_history_entries.
Id string: The provider-assigned unique ID for this managed resource.
Filters []GetDatabaseUpgradeHistoryEntriesFilter
State string: Status of database upgrade history SUCCEEDED|IN_PROGRESS|FAILED.
UpgradeAction string

databaseId String
databaseUpgradeHistoryEntries List<GetUpgradeHistoryEntriesUpgradeHistoryEntry>: The list of database_upgrade_history_entries.
id String: The provider-assigned unique ID for this managed resource.
filters List<GetUpgradeHistoryEntriesFilter>
state String: Status of database upgrade history SUCCEEDED|IN_PROGRESS|FAILED.
upgradeAction String

databaseId string
databaseUpgradeHistoryEntries GetDatabaseUpgradeHistoryEntriesDatabaseUpgradeHistoryEntry[]: The list of database_upgrade_history_entries.
id string: The provider-assigned unique ID for this managed resource.
filters GetDatabaseUpgradeHistoryEntriesFilter[]
state string: Status of database upgrade history SUCCEEDED|IN_PROGRESS|FAILED.
upgradeAction string

database_id str
database_upgrade_history_entries GetDatabaseUpgradeHistoryEntriesDatabaseUpgradeHistoryEntry]: The list of database_upgrade_history_entries.
id str: The provider-assigned unique ID for this managed resource.
filters GetDatabaseUpgradeHistoryEntriesFilter]
state str: Status of database upgrade history SUCCEEDED|IN_PROGRESS|FAILED.
upgrade_action str

databaseId String
databaseUpgradeHistoryEntries List<Property Map>: The list of database_upgrade_history_entries.
id String: The provider-assigned unique ID for this managed resource.
filters List<Property Map>
state String: Status of database upgrade history SUCCEEDED|IN_PROGRESS|FAILED.
upgradeAction String

Supporting Types

GetDatabaseUpgradeHistoryEntriesDatabaseUpgradeHistoryEntry

Action string

The database upgrade action.

Id string

The OCID of the database upgrade history.

LifecycleDetails string

Additional information about the current lifecycle state.

Options string

Additional upgrade options supported by DBUA(Database Upgrade Assistant). Example: "-upgradeTimezone false -keepEvents"

Source string

The source of the Oracle Database software to be used for the upgrade.

Use DB_VERSION to specify a generally-available Oracle Database software version to upgrade the database.
Use DB_SOFTWARE_IMAGE to specify a database software image to upgrade the database.

SourceDbHomeId string

The OCID of the Database Home.

State string

A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.

TargetDatabaseSoftwareImageId string

the database software image used for upgrading database.

TargetDbHomeId string

The OCID of the Database Home.

TargetDbVersion string

A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.

TimeEnded string

The date and time when the database upgrade ended.

TimeStarted string

The date and time when the database upgrade started.

Action string

The database upgrade action.

Id string

The OCID of the database upgrade history.

LifecycleDetails string

Additional information about the current lifecycle state.

Options string

Additional upgrade options supported by DBUA(Database Upgrade Assistant). Example: "-upgradeTimezone false -keepEvents"

Source string

The source of the Oracle Database software to be used for the upgrade.

Use DB_VERSION to specify a generally-available Oracle Database software version to upgrade the database.
Use DB_SOFTWARE_IMAGE to specify a database software image to upgrade the database.

SourceDbHomeId string

The OCID of the Database Home.

State string

A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.

TargetDatabaseSoftwareImageId string

the database software image used for upgrading database.

TargetDbHomeId string

The OCID of the Database Home.

TargetDbVersion string

A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.

TimeEnded string

The date and time when the database upgrade ended.

TimeStarted string

The date and time when the database upgrade started.

action String

The database upgrade action.

id String

The OCID of the database upgrade history.

lifecycleDetails String

Additional information about the current lifecycle state.

options String

Additional upgrade options supported by DBUA(Database Upgrade Assistant). Example: "-upgradeTimezone false -keepEvents"

source String

The source of the Oracle Database software to be used for the upgrade.

Use DB_VERSION to specify a generally-available Oracle Database software version to upgrade the database.
Use DB_SOFTWARE_IMAGE to specify a database software image to upgrade the database.

sourceDbHomeId String

The OCID of the Database Home.

state String

A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.

targetDatabaseSoftwareImageId String

the database software image used for upgrading database.

targetDbHomeId String

The OCID of the Database Home.

targetDbVersion String

A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.

timeEnded String

The date and time when the database upgrade ended.

timeStarted String

The date and time when the database upgrade started.

action string

The database upgrade action.

id string

The OCID of the database upgrade history.

lifecycleDetails string

Additional information about the current lifecycle state.

options string

Additional upgrade options supported by DBUA(Database Upgrade Assistant). Example: "-upgradeTimezone false -keepEvents"

source string

The source of the Oracle Database software to be used for the upgrade.

Use DB_VERSION to specify a generally-available Oracle Database software version to upgrade the database.
Use DB_SOFTWARE_IMAGE to specify a database software image to upgrade the database.

sourceDbHomeId string

The OCID of the Database Home.

state string

A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.

targetDatabaseSoftwareImageId string

the database software image used for upgrading database.

targetDbHomeId string

The OCID of the Database Home.

targetDbVersion string

A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.

timeEnded string

The date and time when the database upgrade ended.

timeStarted string

The date and time when the database upgrade started.

action str

The database upgrade action.

id str

The OCID of the database upgrade history.

lifecycle_details str

Additional information about the current lifecycle state.

options str

Additional upgrade options supported by DBUA(Database Upgrade Assistant). Example: "-upgradeTimezone false -keepEvents"

source str

The source of the Oracle Database software to be used for the upgrade.

Use DB_VERSION to specify a generally-available Oracle Database software version to upgrade the database.
Use DB_SOFTWARE_IMAGE to specify a database software image to upgrade the database.

source_db_home_id str

The OCID of the Database Home.

state str

A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.

target_database_software_image_id str

the database software image used for upgrading database.

target_db_home_id str

The OCID of the Database Home.

target_db_version str

A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.

time_ended str

The date and time when the database upgrade ended.

time_started str

The date and time when the database upgrade started.

action String

The database upgrade action.

id String

The OCID of the database upgrade history.

lifecycleDetails String

Additional information about the current lifecycle state.

options String

Additional upgrade options supported by DBUA(Database Upgrade Assistant). Example: "-upgradeTimezone false -keepEvents"

source String

The source of the Oracle Database software to be used for the upgrade.

Use DB_VERSION to specify a generally-available Oracle Database software version to upgrade the database.
Use DB_SOFTWARE_IMAGE to specify a database software image to upgrade the database.

sourceDbHomeId String