1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Database
  5. getOneoffPatches
Oracle Cloud Infrastructure v1.34.0 published on Friday, May 3, 2024 by Pulumi

oci.Database.getOneoffPatches

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.34.0 published on Friday, May 3, 2024 by Pulumi

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

    Lists one-off patches in the specified compartment.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testOneoffPatches = oci.Database.getOneoffPatches({
        compartmentId: compartmentId,
        displayName: oneoffPatchDisplayName,
        state: oneoffPatchState,
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_oneoff_patches = oci.Database.get_oneoff_patches(compartment_id=compartment_id,
        display_name=oneoff_patch_display_name,
        state=oneoff_patch_state)
    
    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.GetOneoffPatches(ctx, &database.GetOneoffPatchesArgs{
    			CompartmentId: compartmentId,
    			DisplayName:   pulumi.StringRef(oneoffPatchDisplayName),
    			State:         pulumi.StringRef(oneoffPatchState),
    		}, nil)
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Oci = Pulumi.Oci;
    
    return await Deployment.RunAsync(() => 
    {
        var testOneoffPatches = Oci.Database.GetOneoffPatches.Invoke(new()
        {
            CompartmentId = compartmentId,
            DisplayName = oneoffPatchDisplayName,
            State = oneoffPatchState,
        });
    
    });
    
    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.GetOneoffPatchesArgs;
    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 testOneoffPatches = DatabaseFunctions.getOneoffPatches(GetOneoffPatchesArgs.builder()
                .compartmentId(compartmentId)
                .displayName(oneoffPatchDisplayName)
                .state(oneoffPatchState)
                .build());
    
        }
    }
    
    variables:
      testOneoffPatches:
        fn::invoke:
          Function: oci:Database:getOneoffPatches
          Arguments:
            compartmentId: ${compartmentId}
            displayName: ${oneoffPatchDisplayName}
            state: ${oneoffPatchState}
    

    Using getOneoffPatches

    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 getOneoffPatches(args: GetOneoffPatchesArgs, opts?: InvokeOptions): Promise<GetOneoffPatchesResult>
    function getOneoffPatchesOutput(args: GetOneoffPatchesOutputArgs, opts?: InvokeOptions): Output<GetOneoffPatchesResult>
    def get_oneoff_patches(compartment_id: Optional[str] = None,
                           display_name: Optional[str] = None,
                           filters: Optional[Sequence[_database.GetOneoffPatchesFilter]] = None,
                           state: Optional[str] = None,
                           opts: Optional[InvokeOptions] = None) -> GetOneoffPatchesResult
    def get_oneoff_patches_output(compartment_id: Optional[pulumi.Input[str]] = None,
                           display_name: Optional[pulumi.Input[str]] = None,
                           filters: Optional[pulumi.Input[Sequence[pulumi.Input[_database.GetOneoffPatchesFilterArgs]]]] = None,
                           state: Optional[pulumi.Input[str]] = None,
                           opts: Optional[InvokeOptions] = None) -> Output[GetOneoffPatchesResult]
    func GetOneoffPatches(ctx *Context, args *GetOneoffPatchesArgs, opts ...InvokeOption) (*GetOneoffPatchesResult, error)
    func GetOneoffPatchesOutput(ctx *Context, args *GetOneoffPatchesOutputArgs, opts ...InvokeOption) GetOneoffPatchesResultOutput

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

    public static class GetOneoffPatches 
    {
        public static Task<GetOneoffPatchesResult> InvokeAsync(GetOneoffPatchesArgs args, InvokeOptions? opts = null)
        public static Output<GetOneoffPatchesResult> Invoke(GetOneoffPatchesInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetOneoffPatchesResult> getOneoffPatches(GetOneoffPatchesArgs args, InvokeOptions options)
    // Output-based functions aren't available in Java yet
    
    fn::invoke:
      function: oci:Database/getOneoffPatches:getOneoffPatches
      arguments:
        # arguments dictionary

    The following arguments are supported:

    CompartmentId string
    (Updatable) The compartment OCID.
    DisplayName string
    A filter to return only resources that match the entire display name given. The match is not case sensitive.
    Filters List<GetOneoffPatchesFilter>
    State string
    A filter to return only resources that match the given lifecycle state exactly
    CompartmentId string
    (Updatable) The compartment OCID.
    DisplayName string
    A filter to return only resources that match the entire display name given. The match is not case sensitive.
    Filters []GetOneoffPatchesFilter
    State string
    A filter to return only resources that match the given lifecycle state exactly
    compartmentId String
    (Updatable) The compartment OCID.
    displayName String
    A filter to return only resources that match the entire display name given. The match is not case sensitive.
    filters List<GetOneoffPatchesFilter>
    state String
    A filter to return only resources that match the given lifecycle state exactly
    compartmentId string
    (Updatable) The compartment OCID.
    displayName string
    A filter to return only resources that match the entire display name given. The match is not case sensitive.
    filters GetOneoffPatchesFilter[]
    state string
    A filter to return only resources that match the given lifecycle state exactly
    compartment_id str
    (Updatable) The compartment OCID.
    display_name str
    A filter to return only resources that match the entire display name given. The match is not case sensitive.
    filters Sequence[database.GetOneoffPatchesFilter]
    state str
    A filter to return only resources that match the given lifecycle state exactly
    compartmentId String
    (Updatable) The compartment OCID.
    displayName String
    A filter to return only resources that match the entire display name given. The match is not case sensitive.
    filters List<Property Map>
    state String
    A filter to return only resources that match the given lifecycle state exactly

    getOneoffPatches Result

    The following output properties are available:

    CompartmentId string
    The OCID of the compartment.
    Id string
    The provider-assigned unique ID for this managed resource.
    OneoffPatches List<GetOneoffPatchesOneoffPatch>
    The list of oneoff_patches.
    DisplayName string
    One-off patch name.
    Filters List<GetOneoffPatchesFilter>
    State string
    The current state of the one-off patch.
    CompartmentId string
    The OCID of the compartment.
    Id string
    The provider-assigned unique ID for this managed resource.
    OneoffPatches []GetOneoffPatchesOneoffPatch
    The list of oneoff_patches.
    DisplayName string
    One-off patch name.
    Filters []GetOneoffPatchesFilter
    State string
    The current state of the one-off patch.
    compartmentId String
    The OCID of the compartment.
    id String
    The provider-assigned unique ID for this managed resource.
    oneoffPatches List<GetOneoffPatchesOneoffPatch>
    The list of oneoff_patches.
    displayName String
    One-off patch name.
    filters List<GetOneoffPatchesFilter>
    state String
    The current state of the one-off patch.
    compartmentId string
    The OCID of the compartment.
    id string
    The provider-assigned unique ID for this managed resource.
    oneoffPatches GetOneoffPatchesOneoffPatch[]
    The list of oneoff_patches.
    displayName string
    One-off patch name.
    filters GetOneoffPatchesFilter[]
    state string
    The current state of the one-off patch.
    compartment_id str
    The OCID of the compartment.
    id str
    The provider-assigned unique ID for this managed resource.
    oneoff_patches Sequence[database.GetOneoffPatchesOneoffPatch]
    The list of oneoff_patches.
    display_name str
    One-off patch name.
    filters Sequence[database.GetOneoffPatchesFilter]
    state str
    The current state of the one-off patch.
    compartmentId String
    The OCID of the compartment.
    id String
    The provider-assigned unique ID for this managed resource.
    oneoffPatches List<Property Map>
    The list of oneoff_patches.
    displayName String
    One-off patch name.
    filters List<Property Map>
    state String
    The current state of the one-off patch.

    Supporting Types

    GetOneoffPatchesFilter

    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

    GetOneoffPatchesOneoffPatch

    CompartmentId string
    (Updatable) The compartment OCID.
    DbVersion string
    A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.
    DefinedTags Dictionary<string, object>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
    DisplayName string
    A filter to return only resources that match the entire display name given. The match is not case sensitive.
    DownloadOneoffPatchTrigger int
    FreeformTags Dictionary<string, object>
    Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
    Id string
    The OCID of the one-off patch.
    LifecycleDetails string
    Detailed message for the lifecycle state.
    OneOffPatches List<string>
    List of one-off patches for Database Homes.
    ReleaseUpdate string
    The PSU or PBP or Release Updates. To get a list of supported versions, use the ListDbVersions operation.
    Sha256sum string
    SHA-256 checksum of the one-off patch.
    SizeInKbs double
    The size of one-off patch in kilobytes.
    State string
    A filter to return only resources that match the given lifecycle state exactly
    TimeCreated string
    The date and time one-off patch was created.
    TimeOfExpiration string
    The date and time until which the one-off patch will be available for download.
    TimeUpdated string
    The date and time one-off patch was updated.
    CompartmentId string
    (Updatable) The compartment OCID.
    DbVersion string
    A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.
    DefinedTags map[string]interface{}
    Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
    DisplayName string
    A filter to return only resources that match the entire display name given. The match is not case sensitive.
    DownloadOneoffPatchTrigger int
    FreeformTags map[string]interface{}
    Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
    Id string
    The OCID of the one-off patch.
    LifecycleDetails string
    Detailed message for the lifecycle state.
    OneOffPatches []string
    List of one-off patches for Database Homes.
    ReleaseUpdate string
    The PSU or PBP or Release Updates. To get a list of supported versions, use the ListDbVersions operation.
    Sha256sum string
    SHA-256 checksum of the one-off patch.
    SizeInKbs float64
    The size of one-off patch in kilobytes.
    State string
    A filter to return only resources that match the given lifecycle state exactly
    TimeCreated string
    The date and time one-off patch was created.
    TimeOfExpiration string
    The date and time until which the one-off patch will be available for download.
    TimeUpdated string
    The date and time one-off patch was updated.
    compartmentId String
    (Updatable) The compartment OCID.
    dbVersion String
    A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.
    definedTags Map<String,Object>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
    displayName String
    A filter to return only resources that match the entire display name given. The match is not case sensitive.
    downloadOneoffPatchTrigger Integer
    freeformTags Map<String,Object>
    Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
    id String
    The OCID of the one-off patch.
    lifecycleDetails String
    Detailed message for the lifecycle state.
    oneOffPatches List<String>
    List of one-off patches for Database Homes.
    releaseUpdate String
    The PSU or PBP or Release Updates. To get a list of supported versions, use the ListDbVersions operation.
    sha256sum String
    SHA-256 checksum of the one-off patch.
    sizeInKbs Double
    The size of one-off patch in kilobytes.
    state String
    A filter to return only resources that match the given lifecycle state exactly
    timeCreated String
    The date and time one-off patch was created.
    timeOfExpiration String
    The date and time until which the one-off patch will be available for download.
    timeUpdated String
    The date and time one-off patch was updated.
    compartmentId string
    (Updatable) The compartment OCID.
    dbVersion string
    A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.
    definedTags {[key: string]: any}
    Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
    displayName string
    A filter to return only resources that match the entire display name given. The match is not case sensitive.
    downloadOneoffPatchTrigger number
    freeformTags {[key: string]: any}
    Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
    id string
    The OCID of the one-off patch.
    lifecycleDetails string
    Detailed message for the lifecycle state.
    oneOffPatches string[]
    List of one-off patches for Database Homes.
    releaseUpdate string
    The PSU or PBP or Release Updates. To get a list of supported versions, use the ListDbVersions operation.
    sha256sum string
    SHA-256 checksum of the one-off patch.
    sizeInKbs number
    The size of one-off patch in kilobytes.
    state string
    A filter to return only resources that match the given lifecycle state exactly
    timeCreated string
    The date and time one-off patch was created.
    timeOfExpiration string
    The date and time until which the one-off patch will be available for download.
    timeUpdated string
    The date and time one-off patch was updated.
    compartment_id str
    (Updatable) The compartment OCID.
    db_version str
    A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.
    defined_tags Mapping[str, Any]
    Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
    display_name str
    A filter to return only resources that match the entire display name given. The match is not case sensitive.
    download_oneoff_patch_trigger int
    freeform_tags Mapping[str, Any]
    Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
    id str
    The OCID of the one-off patch.
    lifecycle_details str
    Detailed message for the lifecycle state.
    one_off_patches Sequence[str]
    List of one-off patches for Database Homes.
    release_update str
    The PSU or PBP or Release Updates. To get a list of supported versions, use the ListDbVersions operation.
    sha256sum str
    SHA-256 checksum of the one-off patch.
    size_in_kbs float
    The size of one-off patch in kilobytes.
    state str
    A filter to return only resources that match the given lifecycle state exactly
    time_created str
    The date and time one-off patch was created.
    time_of_expiration str
    The date and time until which the one-off patch will be available for download.
    time_updated str
    The date and time one-off patch was updated.
    compartmentId String
    (Updatable) The compartment OCID.
    dbVersion String
    A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.
    definedTags Map<Any>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
    displayName String
    A filter to return only resources that match the entire display name given. The match is not case sensitive.
    downloadOneoffPatchTrigger Number
    freeformTags Map<Any>
    Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
    id String
    The OCID of the one-off patch.
    lifecycleDetails String
    Detailed message for the lifecycle state.
    oneOffPatches List<String>
    List of one-off patches for Database Homes.
    releaseUpdate String
    The PSU or PBP or Release Updates. To get a list of supported versions, use the ListDbVersions operation.
    sha256sum String
    SHA-256 checksum of the one-off patch.
    sizeInKbs Number
    The size of one-off patch in kilobytes.
    state String
    A filter to return only resources that match the given lifecycle state exactly
    timeCreated String
    The date and time one-off patch was created.
    timeOfExpiration String
    The date and time until which the one-off patch will be available for download.
    timeUpdated String
    The date and time one-off patch was updated.

    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.34.0 published on Friday, May 3, 2024 by Pulumi