accounts

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

Overview

Name	accounts
Type	Resource
Id	azure_extras.code_signing.accounts

Fields

vw_accounts

Name	Datatype	Description
accountName	text	field from the properties object
account_uri	text	field from the properties object
location	text	The geo-location where the resource lives
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
sku	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.

accounts

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	Properties of the trusted signing account.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, resourceGroupName, subscriptionId	Get a trusted Signing Account.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Lists trusted signing accounts within a resource group.
list_by_subscription	SELECT	subscriptionId	Lists trusted signing accounts within a subscription.
create	INSERT	accountName, resourceGroupName, subscriptionId	Create a trusted Signing Account.
delete	DELETE	accountName, resourceGroupName, subscriptionId	Delete a trusted signing account.
update	UPDATE	accountName, resourceGroupName, subscriptionId	Update a trusted signing account.
check_name_availability	EXEC	subscriptionId, data__name	Checks that the trusted signing account name is valid and is not already in use.

SELECT examples

Lists trusted signing accounts within a subscription.

vw_accounts

SELECT
accountName,
account_uri,
location,
provisioning_state,
resourceGroupName,
sku,
subscriptionId,
tags
FROM azure_extras.code_signing.vw_accounts
WHERE subscriptionId = '{{ subscriptionId }}';

accounts

SELECT
location,
properties,
tags
FROM azure_extras.code_signing.accounts
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.code_signing.accounts (
accountName,
resourceGroupName,
subscriptionId,
properties,
tags,
location
)
SELECT 
'{{ accountName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: accountUri
          value: string
        - name: sku
          value:
            - name: name
              value: []
        - name: provisioningState
          value: []
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a accounts resource.

/*+ update */
UPDATE azure_extras.code_signing.accounts
SET 
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified accounts resource.

/*+ delete */
DELETE FROM azure_extras.code_signing.accounts
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';