Skip to main content

accounts

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

Overview

Nameaccounts
TypeResource
Idazure.playwrighttesting.accounts

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
locationstringThe geo-location where the resource lives
propertiesobjectThe resource-specific properties for this resource.
tagsobjectResource tags.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, accountNameGet a Account
list_by_resource_groupselectsubscriptionId, resourceGroupNameList Account resources by resource group
list_by_subscriptionselectsubscriptionIdList Account resources by subscription ID
create_or_updateinsertsubscriptionId, resourceGroupName, accountNameCreate a Account
updateupdatesubscriptionId, resourceGroupName, accountNameUpdate a Account
deletedeletesubscriptionId, resourceGroupName, accountNameDelete a Account
check_name_availabilityexecsubscriptionIdAdds check global name availability operation, normally used if a resource name must be globally unique.

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.

NameDatatypeDescription
accountNamestringName of account.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Get a Account

SELECT
location,
properties,
tags
FROM azure.playwrighttesting.accounts
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND accountName = '{{ accountName }}' -- required
;

INSERT examples

Create a Account

INSERT INTO azure.playwrighttesting.accounts (
data__properties,
data__tags,
data__location,
subscriptionId,
resourceGroupName,
accountName
)
SELECT
'{{ properties }}',
'{{ tags }}',
'{{ location }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ accountName }}'
RETURNING
location,
properties,
tags
;

UPDATE examples

Update a Account

UPDATE azure.playwrighttesting.accounts
SET
data__tags = '{{ tags }}',
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
RETURNING
location,
properties,
tags;

DELETE examples

Delete a Account

DELETE FROM azure.playwrighttesting.accounts
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
;

Lifecycle Methods

Adds check global name availability operation, normally used if a resource name must be globally unique.

EXEC azure.playwrighttesting.accounts.check_name_availability 
@subscriptionId='{{ subscriptionId }}' --required
@@json=
'{
"name": "{{ name }}",
"type": "{{ type }}"
}'
;