accounts

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

Overview

Name	accounts
Type	Resource
Id	azure.playwrighttesting.accounts

Fields

vw_accounts

Name	Datatype	Description
accountName	text	field from the properties object
dashboard_uri	text	field from the properties object
local_auth	text	field from the properties object
location	text	The geo-location where the resource lives
provisioning_state	text	field from the properties object
regional_affinity	text	field from the properties object
reporting	text	field from the properties object
resourceGroupName	text	field from the properties object
scalable_execution	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	Account resource properties.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, resourceGroupName, subscriptionId	Get a Account
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List Account resources by resource group
list_by_subscription	SELECT	subscriptionId	List Account resources by subscription ID
create_or_update	INSERT	accountName, resourceGroupName, subscriptionId	Create a Account
delete	DELETE	accountName, resourceGroupName, subscriptionId	Delete a Account
update	UPDATE	accountName, resourceGroupName, subscriptionId	Update a Account
check_name_availability	EXEC	subscriptionId	Adds check global name availability operation, normally used if a resource name must be globally unique.

SELECT examples

List Account resources by subscription ID

vw_accounts

SELECT
accountName,
dashboard_uri,
local_auth,
location,
provisioning_state,
regional_affinity,
reporting,
resourceGroupName,
scalable_execution,
subscriptionId,
tags
FROM azure.playwrighttesting.vw_accounts
WHERE subscriptionId = '{{ subscriptionId }}';

accounts

SELECT
location,
properties,
tags
FROM azure.playwrighttesting.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.playwrighttesting.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: dashboardUri
          value: string
        - name: regionalAffinity
          value: string
        - name: scalableExecution
          value: string
        - name: reporting
          value: string
        - name: localAuth
          value: string
        - name: provisioningState
          value: []
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a accounts resource.

/*+ update */
UPDATE azure.playwrighttesting.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.playwrighttesting.accounts
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';