1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Database
  5. getDbSystemPatches
Oracle Cloud Infrastructure v1.16.1 published on Wednesday, Nov 22, 2023 by Pulumi

oci.Database.getDbSystemPatches

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.16.1 published on Wednesday, Nov 22, 2023 by Pulumi

    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 System.Linq;
    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:

    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
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes

    This Pulumi package is based on the oci Terraform Provider.

    oci logo
    Oracle Cloud Infrastructure v1.16.1 published on Wednesday, Nov 22, 2023 by Pulumi