subscriptions

Creates, updates, deletes, gets or lists a subscriptions resource.

Overview

Name	subscriptions
Type	Resource
Id	azure_isv.oracle.subscriptions

Fields

Name	Datatype	Description
plan	object	Plan for the resource.
properties	object	Oracle Subscription resource model

Methods

Name	Accessible by	Required Params	Description
get	SELECT	subscriptionId	Get a OracleSubscription
list_by_subscription	SELECT	subscriptionId	List OracleSubscription resources by subscription ID
create_or_update	INSERT	subscriptionId	Create a OracleSubscription
delete	DELETE	subscriptionId	Delete a OracleSubscription
update	UPDATE	subscriptionId	Update a OracleSubscription
add_azure_subscriptions	EXEC	subscriptionId, data__azureSubscriptionIds	Add Azure Subscriptions

SELECT examples

Get a OracleSubscription

SELECT
plan,
properties
FROM azure_isv.oracle.subscriptions
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new subscriptions resource.

All Properties

/*+ create */
INSERT INTO azure_isv.oracle.subscriptions (
subscriptionId,
properties,
plan
)
SELECT 
'{{ subscriptionId }}',
'{{ properties }}',
'{{ plan }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: saasSubscriptionId
          value: string
        - name: cloudAccountId
          value: []
        - name: cloudAccountState
          value: []
        - name: termUnit
          value: string
        - name: productCode
          value: string
        - name: intent
          value: []
        - name: azureSubscriptionIds
          value:
            - string
        - name: addSubscriptionOperationState
          value: []
        - name: lastOperationStatusDetail
          value: string
    - name: plan
      value:
        - name: name
          value: string
        - name: publisher
          value: string
        - name: product
          value: string
        - name: promotionCode
          value: string
        - name: version
          value: string

UPDATE example

Updates a subscriptions resource.

/*+ update */
UPDATE azure_isv.oracle.subscriptions
SET 
plan = '{{ plan }}',
properties = '{{ properties }}'
WHERE 
subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified subscriptions resource.

/*+ delete */
DELETE FROM azure_isv.oracle.subscriptions
WHERE subscriptionId = '{{ subscriptionId }}';