subscriptions

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

Overview

Name	subscriptions
Type	Resource
Id	azure_isv.oracle.subscriptions

Fields

The following fields are returned by SELECT queries:

list_by_subscription

Azure operation completed successfully.

Name	Datatype	Description
plan	object	Details of the resource plan.
properties	object	The resource-specific properties for this resource.

get

Azure operation completed successfully.

Name	Datatype	Description
plan	object	Details of the resource plan.
properties	object	The resource-specific properties for this resource.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_by_subscription	select	subscriptionId		List OracleSubscription resources by subscription ID
get	select	subscriptionId		Get a OracleSubscription
create_or_update	insert	subscriptionId		Create a OracleSubscription
update	update	subscriptionId		Update a OracleSubscription
delete	delete	subscriptionId		Delete a OracleSubscription
add_azure_subscriptions	exec	subscriptionId, 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
subscriptionId	string (uuid)	The ID of the target subscription. The value must be an UUID.

SELECT examples

list_by_subscription

List OracleSubscription resources by subscription ID

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

get

Get a OracleSubscription

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

INSERT examples

create_or_update

Create a OracleSubscription

INSERT INTO azure_isv.oracle.subscriptions (
data__properties,
data__plan,
subscriptionId
)
SELECT 
'{{ properties }}',
'{{ plan }}',
'{{ subscriptionId }}'
RETURNING
plan,
properties
;

Manifest

# Description fields are for documentation purposes
- name: subscriptions
  props:
    - name: subscriptionId
      value: string (uuid)
      description: Required parameter for the subscriptions resource.
    - name: properties
      value: object
      description: |
        The resource-specific properties for this resource.
    - name: plan
      value: object
      description: |
        Details of the resource plan.

UPDATE examples

update

Update a OracleSubscription

UPDATE azure_isv.oracle.subscriptions
SET 
data__plan = '{{ plan }}',
data__properties = '{{ properties }}'
WHERE 
subscriptionId = '{{ subscriptionId }}' --required
RETURNING
plan,
properties;

DELETE examples

delete

Delete a OracleSubscription

DELETE FROM azure_isv.oracle.subscriptions
WHERE subscriptionId = '{{ subscriptionId }}' --required
;

Lifecycle Methods

add_azure_subscriptions

Add Azure Subscriptions

EXEC azure_isv.oracle.subscriptions.add_azure_subscriptions 
@subscriptionId='{{ subscriptionId }}' --required 
@@json=
'{
"azureSubscriptionIds": "{{ azureSubscriptionIds }}"
}'
;