accounts

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

Overview

Name	accounts
Type	Resource
Id	azure_extras.test_base.accounts

Fields

vw_accounts

Name	Datatype	Description
access_level	text	field from the properties object
identity	text	Managed service identity (either system assigned, or none)
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.
testBaseAccountName	text	field from the properties object

accounts

Name	Datatype	Description
identity	object	Managed service identity (either system assigned, or none)
location	string	The geo-location where the resource lives
properties	object	The properties of a Test Base Account resource.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, subscriptionId, testBaseAccountName	Gets a Test Base Account.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Lists all the Test Base Accounts in a resource group.
list_by_subscription	SELECT	subscriptionId	Lists all the Test Base Accounts in a subscription.
create	INSERT	resourceGroupName, subscriptionId, testBaseAccountName	Create or replace (overwrite/recreate, with potential downtime) a Test Base Account in the specified subscription.
delete	DELETE	resourceGroupName, subscriptionId, testBaseAccountName	Deletes a Test Base Account.
update	UPDATE	resourceGroupName, subscriptionId, testBaseAccountName	Update an existing Test Base Account.
check_package_name_availability	EXEC	resourceGroupName, subscriptionId, testBaseAccountName, data__applicationName, data__name, data__version	Checks that the Test Base Package name and version is valid and is not already in use.
offboard	EXEC	resourceGroupName, subscriptionId, testBaseAccountName	Offboard a Test Base Account.

SELECT examples

Lists all the Test Base Accounts in a subscription.

vw_accounts

SELECT
access_level,
identity,
location,
provisioning_state,
resourceGroupName,
sku,
subscriptionId,
tags,
testBaseAccountName
FROM azure_extras.test_base.vw_accounts
WHERE subscriptionId = '{{ subscriptionId }}';

accounts

SELECT
identity,
location,
properties,
tags
FROM azure_extras.test_base.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.test_base.accounts (
resourceGroupName,
subscriptionId,
testBaseAccountName,
properties,
identity,
tags,
location
)
SELECT 
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ testBaseAccountName }}',
'{{ properties }}',
'{{ identity }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: sku
          value:
            - name: resourceType
              value: string
            - name: name
              value: string
            - name: tier
              value: string
            - name: capabilities
              value:
                - - name: name
                    value: string
                  - name: value
                    value: string
            - name: locations
              value:
                - string
        - name: accessLevel
          value: string
    - name: identity
      value:
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: type
          value: []
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a accounts resource.

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

DELETE example

Deletes the specified accounts resource.

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