oracle_subscriptions

Creates, updates, deletes, gets or lists an oracle_subscriptions resource.

Overview

Name	oracle_subscriptions
Type	Resource
Id	azure_isv.oracledatabase.oracle_subscriptions

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
addSubscriptionOperationState	string	State of the add Azure subscription operation on Oracle subscription. Known values are: "Succeeded", "Updating", and "Failed". (Succeeded, Updating, Failed)
azureSubscriptionIds	array	Azure subscriptions to be added.
cloudAccountId	string	Cloud Account Id.
cloudAccountState	string	Cloud Account provisioning state. Known values are: "Pending", "Provisioning", and "Available". (Pending, Provisioning, Available)
intent	string	Intent for the update operation. Known values are: "Retain" and "Reset". (Retain, Reset)
lastOperationStatusDetail	string	Status details of the last operation on Oracle subscription.
plan	object	Details of the resource plan.
productCode	string	Product code for the term unit.
provisioningState	string	OracleSubscriptionProvisioningState provisioning state. Known values are: "Succeeded", "Failed", and "Canceled". (Succeeded, Failed, Canceled)
saasSubscriptionId	string	SAAS subscription ID generated by Marketplace.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
termUnit	string	Term Unit. P1Y, P3Y, etc, see Durations https://en.wikipedia.org/wiki/ISO_8601 _.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	subscription_id		Get a OracleSubscription.
create_or_update	insert	subscription_id		Create a OracleSubscription.
update	update	subscription_id		Update a OracleSubscription.
create_or_update	replace	subscription_id		Create a OracleSubscription.
delete	delete	subscription_id		Delete a OracleSubscription.
list_by_subscription	exec	subscription_id		List OracleSubscription resources by subscription ID.
list_cloud_account_details	exec	subscription_id		List Cloud Account Details.
list_saas_subscription_details	exec	subscription_id		List Saas Subscription Details.
list_activation_links	exec	subscription_id		List Activation Links.
add_azure_subscriptions	exec	subscription_id, azureSubscriptionIds		Add Azure Subscriptions.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
subscription_id	string

SELECT examples

get

Get a OracleSubscription.

SELECT
id,
name,
addSubscriptionOperationState,
azureSubscriptionIds,
cloudAccountId,
cloudAccountState,
intent,
lastOperationStatusDetail,
plan,
productCode,
provisioningState,
saasSubscriptionId,
systemData,
termUnit,
type
FROM azure_isv.oracledatabase.oracle_subscriptions
WHERE subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

create_or_update

Create a OracleSubscription.

INSERT INTO azure_isv.oracledatabase.oracle_subscriptions (
properties,
plan,
subscription_id
)
SELECT 
'{{ properties }}',
'{{ plan }}',
'{{ subscription_id }}'
RETURNING
id,
name,
plan,
properties,
systemData,
type
;

Manifest

# Description fields are for documentation purposes
- name: oracle_subscriptions
props:
  - name: subscription_id
    value: "{{ subscription_id }}"
    description: Required parameter for the oracle_subscriptions resource.
  - name: properties
    description: |
      The resource-specific properties for this resource.
    value:
      provisioningState: "{{ provisioningState }}"
      saasSubscriptionId: "{{ saasSubscriptionId }}"
      cloudAccountId: "{{ cloudAccountId }}"
      cloudAccountState: "{{ cloudAccountState }}"
      termUnit: "{{ termUnit }}"
      productCode: "{{ productCode }}"
      intent: "{{ intent }}"
      azureSubscriptionIds:
        - "{{ azureSubscriptionIds }}"
      addSubscriptionOperationState: "{{ addSubscriptionOperationState }}"
      lastOperationStatusDetail: "{{ lastOperationStatusDetail }}"
  - name: plan
    description: |
      Details of the resource plan.
    value:
      name: "{{ name }}"
      publisher: "{{ publisher }}"
      product: "{{ product }}"
      promotionCode: "{{ promotionCode }}"
      version: "{{ version }}"

UPDATE examples

update

Update a OracleSubscription.

UPDATE azure_isv.oracledatabase.oracle_subscriptions
SET 
plan = '{{ plan }}',
properties = '{{ properties }}'
WHERE 
subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
plan,
properties,
systemData,
type;

REPLACE examples

create_or_update

Create a OracleSubscription.

REPLACE azure_isv.oracledatabase.oracle_subscriptions
SET 
properties = '{{ properties }}',
plan = '{{ plan }}'
WHERE 
subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
plan,
properties,
systemData,
type;

DELETE examples

delete

Delete a OracleSubscription.

DELETE FROM azure_isv.oracledatabase.oracle_subscriptions
WHERE subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

list_by_subscription

List OracleSubscription resources by subscription ID.

EXEC azure_isv.oracledatabase.oracle_subscriptions.list_by_subscription 
@subscription_id='{{ subscription_id }}' --required
;

list_cloud_account_details

List Cloud Account Details.

EXEC azure_isv.oracledatabase.oracle_subscriptions.list_cloud_account_details 
@subscription_id='{{ subscription_id }}' --required
;

list_saas_subscription_details

List Saas Subscription Details.

EXEC azure_isv.oracledatabase.oracle_subscriptions.list_saas_subscription_details 
@subscription_id='{{ subscription_id }}' --required
;

list_activation_links

List Activation Links.

EXEC azure_isv.oracledatabase.oracle_subscriptions.list_activation_links 
@subscription_id='{{ subscription_id }}' --required
;

add_azure_subscriptions

Add Azure Subscriptions.

EXEC azure_isv.oracledatabase.oracle_subscriptions.add_azure_subscriptions 
@subscription_id='{{ subscription_id }}' --required 
@@json=
'{
"azureSubscriptionIds": "{{ azureSubscriptionIds }}"
}'
;