credentials

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

Overview

Name	credentials
Type	Resource
Id	azure_extras.test_base.credentials

Fields

vw_credentials

Name	Datatype	Description
credentialName	text	field from the properties object
credential_type	text	field from the properties object
display_name	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
testBaseAccountName	text	field from the properties object

credentials

Name	Datatype	Description
properties	object	The properties of test base credential

Methods

Name	Accessible by	Required Params	Description
get	SELECT	credentialName, resourceGroupName, subscriptionId, testBaseAccountName	Gets a test base credential Resource
list_by_test_base_account	SELECT	resourceGroupName, subscriptionId, testBaseAccountName	Lists all the Credentials under a Test Base Account.
create	INSERT	credentialName, resourceGroupName, subscriptionId, testBaseAccountName	Creates or replaces a Test Base Credential.
delete	DELETE	credentialName, resourceGroupName, subscriptionId, testBaseAccountName	Deletes an existing test base credential.
update	UPDATE	credentialName, resourceGroupName, subscriptionId, testBaseAccountName	Updates an existing test base credential.

SELECT examples

Lists all the Credentials under a Test Base Account.

vw_credentials

SELECT
credentialName,
credential_type,
display_name,
resourceGroupName,
subscriptionId,
testBaseAccountName
FROM azure_extras.test_base.vw_credentials
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND testBaseAccountName = '{{ testBaseAccountName }}';

credentials

SELECT
properties
FROM azure_extras.test_base.credentials
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND testBaseAccountName = '{{ testBaseAccountName }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.test_base.credentials (
credentialName,
resourceGroupName,
subscriptionId,
testBaseAccountName,
properties
)
SELECT 
'{{ credentialName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ testBaseAccountName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: credentialType
          value: string
        - name: displayName
          value: string

UPDATE example

Updates a credentials resource.

/*+ update */
UPDATE azure_extras.test_base.credentials
SET 
properties = '{{ properties }}'
WHERE 
credentialName = '{{ credentialName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND testBaseAccountName = '{{ testBaseAccountName }}';

DELETE example

Deletes the specified credentials resource.

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