plans

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

Overview

Name	plans
Type	Resource
Id	azure.dev_center.plans

Fields

vw_plans

Name	Datatype	Description
location	text	The geo-location where the resource lives
planName	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
sku	text	The resource model definition representing SKU
subscriptionId	text	field from the properties object
tags	text	Resource tags.

plans

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	Properties of the devcenter plan.
sku	object	The resource model definition representing SKU
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	planName, resourceGroupName, subscriptionId	Gets a devcenter plan.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Lists all devcenter plans in a resource group.
list_by_subscription	SELECT	subscriptionId	Lists all devcenter plans in a subscription.
create_or_update	INSERT	planName, resourceGroupName, subscriptionId	Creates or updates a devcenter plan resource
delete	DELETE	planName, resourceGroupName, subscriptionId	Deletes a devcenter plan
update	UPDATE	planName, resourceGroupName, subscriptionId	Partially updates a devcenter plan.

SELECT examples

Lists all devcenter plans in a subscription.

vw_plans

SELECT
location,
planName,
provisioning_state,
resourceGroupName,
sku,
subscriptionId,
tags
FROM azure.dev_center.vw_plans
WHERE subscriptionId = '{{ subscriptionId }}';

plans

SELECT
location,
properties,
sku,
tags
FROM azure.dev_center.plans
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.dev_center.plans (
planName,
resourceGroupName,
subscriptionId,
tags,
location,
properties,
sku
)
SELECT 
'{{ planName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}',
'{{ sku }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: location
      value: string
    - name: properties
      value:
        - name: provisioningState
          value: []
    - name: sku
      value:
        - name: name
          value: string
        - name: tier
          value: []
        - name: size
          value: string
        - name: family
          value: string
        - name: capacity
          value: integer

UPDATE example

Updates a plans resource.

/*+ update */
UPDATE azure.dev_center.plans
SET 
tags = '{{ tags }}',
location = '{{ location }}',
sku = '{{ sku }}'
WHERE 
planName = '{{ planName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified plans resource.

/*+ delete */
DELETE FROM azure.dev_center.plans
WHERE planName = '{{ planName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';