Oracle Cloud Infrastructure

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

getDbSystemPatches

This data source provides the list of Db System Patches in Oracle Cloud Infrastructure Database service.

Lists the patches applicable to the specified DB system.

Example Usage

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

return await Deployment.RunAsync(() => 
{
    var testDbSystemPatches = Oci.Database.GetDbSystemPatches.Invoke(new()
    {
        DbSystemId = oci_database_db_system.Test_db_system.Id,
    });

});

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.GetDbSystemPatches(ctx, &database.GetDbSystemPatchesArgs{
			DbSystemId: oci_database_db_system.Test_db_system.Id,
		}, 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.GetDbSystemPatchesArgs;
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 testDbSystemPatches = DatabaseFunctions.getDbSystemPatches(GetDbSystemPatchesArgs.builder()
            .dbSystemId(oci_database_db_system.test_db_system().id())
            .build());

    }
}

import pulumi
import pulumi_oci as oci

test_db_system_patches = oci.Database.get_db_system_patches(db_system_id=oci_database_db_system["test_db_system"]["id"])

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

const testDbSystemPatches = oci.Database.getDbSystemPatches({
    dbSystemId: oci_database_db_system.test_db_system.id,
});

variables:
  testDbSystemPatches:
    Fn::Invoke:
      Function: oci:Database:getDbSystemPatches
      Arguments:
        dbSystemId: ${oci_database_db_system.test_db_system.id}

Using getDbSystemPatches

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 getDbSystemPatches(args: GetDbSystemPatchesArgs, opts?: InvokeOptions): Promise<GetDbSystemPatchesResult>
function getDbSystemPatchesOutput(args: GetDbSystemPatchesOutputArgs, opts?: InvokeOptions): Output<GetDbSystemPatchesResult>

def get_db_system_patches(db_system_id: Optional[str] = None,
                          filters: Optional[Sequence[_database.GetDbSystemPatchesFilter]] = None,
                          opts: Optional[InvokeOptions] = None) -> GetDbSystemPatchesResult
def get_db_system_patches_output(db_system_id: Optional[pulumi.Input[str]] = None,
                          filters: Optional[pulumi.Input[Sequence[pulumi.Input[_database.GetDbSystemPatchesFilterArgs]]]] = None,
                          opts: Optional[InvokeOptions] = None) -> Output[GetDbSystemPatchesResult]

func GetDbSystemPatches(ctx *Context, args *GetDbSystemPatchesArgs, opts ...InvokeOption) (*GetDbSystemPatchesResult, error)
func GetDbSystemPatchesOutput(ctx *Context, args *GetDbSystemPatchesOutputArgs, opts ...InvokeOption) GetDbSystemPatchesResultOutput

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

public static class GetDbSystemPatches 
{
    public static Task<GetDbSystemPatchesResult> InvokeAsync(GetDbSystemPatchesArgs args, InvokeOptions? opts = null)
    public static Output<GetDbSystemPatchesResult> Invoke(GetDbSystemPatchesInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetDbSystemPatchesResult> getDbSystemPatches(GetDbSystemPatchesArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

Fn::Invoke:
  Function: oci:Database/getDbSystemPatches:getDbSystemPatches
  Arguments:
    # Arguments dictionary

The following arguments are supported:

DbSystemId string: The DB system OCID.
Filters List<GetDbSystemPatchesFilter>

DbSystemId string: The DB system OCID.
Filters []GetDbSystemPatchesFilter

dbSystemId String: The DB system OCID.
filters List<GetDbSystemPatchesFilter>

dbSystemId string: The DB system OCID.
filters GetDbSystemPatchesFilter[]

db_system_id str: The DB system OCID.
filters GetDbSystemPatchesFilter]

dbSystemId String: The DB system OCID.
filters List<Property Map>

getDbSystemPatches Result

The following output properties are available:

DbSystemId string
Id string: The provider-assigned unique ID for this managed resource.
Patches List<GetDbSystemPatchesPatch>: The list of patches.
Filters List<GetDbSystemPatchesFilter>

DbSystemId string
Id string: The provider-assigned unique ID for this managed resource.
Patches []GetDbSystemPatchesPatch: The list of patches.
Filters []GetDbSystemPatchesFilter

dbSystemId String
id String: The provider-assigned unique ID for this managed resource.
patches List<GetDbSystemPatchesPatch>: The list of patches.
filters List<GetDbSystemPatchesFilter>

dbSystemId string
id string: The provider-assigned unique ID for this managed resource.
patches GetDbSystemPatchesPatch[]: The list of patches.
filters GetDbSystemPatchesFilter[]

db_system_id str
id str: The provider-assigned unique ID for this managed resource.
patches GetDbSystemPatchesPatch]: The list of patches.
filters GetDbSystemPatchesFilter]

dbSystemId String
id String: The provider-assigned unique ID for this managed resource.
patches List<Property Map>: The list of patches.
filters List<Property Map>

Supporting Types

GetDbSystemPatchesFilter

Name string
Values List<string>
Regex bool

Name string
Values []string
Regex bool

name String
values List<String>
regex Boolean

name string
values string[]
regex boolean

name str
values Sequence[str]
regex bool

name String
values List<String>
regex Boolean

GetDbSystemPatchesPatch

AvailableActions List<string>: Actions that can possibly be performed using this patch.
Description string: The text describing this patch package.
Id string: The OCID of the patch.
LastAction string: Action that is currently being performed or was completed last.
LifecycleDetails string: A descriptive text associated with the lifecycleState. Typically can contain additional displayable text.
State string: The current state of the patch as a result of lastAction.
TimeReleased string: The date and time that the patch was released.
Version string: The version of this patch package.

AvailableActions []string: Actions that can possibly be performed using this patch.
Description string: The text describing this patch package.
Id string: The OCID of the patch.
LastAction string: Action that is currently being performed or was completed last.
LifecycleDetails string: A descriptive text associated with the lifecycleState. Typically can contain additional displayable text.
State string: The current state of the patch as a result of lastAction.
TimeReleased string: The date and time that the patch was released.
Version string: The version of this patch package.

availableActions List<String>: Actions that can possibly be performed using this patch.
description String: The text describing this patch package.
id String: The OCID of the patch.
lastAction String: Action that is currently being performed or was completed last.
lifecycleDetails String: A descriptive text associated with the lifecycleState. Typically can contain additional displayable text.
state String: The current state of the patch as a result of lastAction.
timeReleased String: The date and time that the patch was released.
version String: The version of this patch package.

availableActions string[]: Actions that can possibly be performed using this patch.
description string: The text describing this patch package.
id string: The OCID of the patch.
lastAction string: Action that is currently being performed or was completed last.
lifecycleDetails string: A descriptive text associated with the lifecycleState. Typically can contain additional displayable text.
state string: The current state of the patch as a result of lastAction.
timeReleased string: The date and time that the patch was released.
version string: The version of this patch package.

available_actions Sequence[str]: Actions that can possibly be performed using this patch.
description str: The text describing this patch package.
id str: The OCID of the patch.
last_action str: Action that is currently being performed or was completed last.
lifecycle_details str: A descriptive text associated with the lifecycleState. Typically can contain additional displayable text.
state str: The current state of the patch as a result of lastAction.
time_released str: The date and time that the patch was released.
version str: The version of this patch package.

availableActions List<String>: Actions that can possibly be performed using this patch.
description String: The text describing this patch package.
id String: The OCID of the patch.
lastAction String: Action that is currently being performed or was completed last.
lifecycleDetails String: A descriptive text associated with the lifecycleState. Typically can contain additional displayable text.
state String: The current state of the patch as a result of lastAction.
timeReleased String: The date and time that the patch was released.
version String: The version of this patch package.

Package Details

Repository: https://github.com/pulumi/pulumi-oci
License: Apache-2.0
Notes: This Pulumi package is based on the oci Terraform Provider.