favorite_processes

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

Overview

Name	favorite_processes
Type	Resource
Id	azure_extras.test_base.favorite_processes

Fields

vw_favorite_processes

Name	Datatype	Description
actual_process_name	text	field from the properties object
favoriteProcessResourceName	text	field from the properties object
packageName	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

favorite_processes

Name	Datatype	Description
properties	object	Properties of a favorite process identifier.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	favoriteProcessResourceName, packageName, resourceGroupName, subscriptionId, testBaseAccountName	Gets a favorite process for a Test Base Package.
list	SELECT	packageName, resourceGroupName, subscriptionId, testBaseAccountName	Lists the favorite processes for a specific package.
create	INSERT	favoriteProcessResourceName, packageName, resourceGroupName, subscriptionId, testBaseAccountName	Create or replace a favorite process for a Test Base Package.
delete	DELETE	favoriteProcessResourceName, packageName, resourceGroupName, subscriptionId, testBaseAccountName	Deletes a favorite process for a specific package.

SELECT examples

Lists the favorite processes for a specific package.

vw_favorite_processes

SELECT
actual_process_name,
favoriteProcessResourceName,
packageName,
resourceGroupName,
subscriptionId,
testBaseAccountName
FROM azure_extras.test_base.vw_favorite_processes
WHERE packageName = '{{ packageName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND testBaseAccountName = '{{ testBaseAccountName }}';

favorite_processes

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

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: actualProcessName
          value: string

DELETE example

Deletes the specified favorite_processes resource.

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