packages

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

Overview

Name	packages
Type	Resource
Id	azure_extras.test_base.packages

Fields

vw_packages

Name	Datatype	Description
application_name	text	field from the properties object
blob_path	text	field from the properties object
draft_package_id	text	field from the properties object
first_party_apps	text	field from the properties object
flighting_ring	text	field from the properties object
gallery_apps	text	field from the properties object
inplace_upgrade_os_pair	text	field from the properties object
intune_enrollment_metadata	text	field from the properties object
is_enabled	text	field from the properties object
last_modified_time	text	field from the properties object
location	text	The geo-location where the resource lives
packageName	text	field from the properties object
package_status	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
target_os_list	text	field from the properties object
testBaseAccountName	text	field from the properties object
test_types	text	field from the properties object
tests	text	field from the properties object
validation_results	text	field from the properties object
version	text	field from the properties object

packages

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	The properties of the Test Base Package.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	packageName, resourceGroupName, subscriptionId, testBaseAccountName	Gets a Test Base Package.
list_by_test_base_account	SELECT	resourceGroupName, subscriptionId, testBaseAccountName	Lists all the packages under a Test Base Account.
create	INSERT	packageName, resourceGroupName, subscriptionId, testBaseAccountName	Create or replace (overwrite/recreate, with potential downtime) a Test Base Package.
delete	DELETE	packageName, resourceGroupName, subscriptionId, testBaseAccountName	Deletes a Test Base Package.
update	UPDATE	packageName, resourceGroupName, subscriptionId, testBaseAccountName	Update an existing Test Base Package.
hard_delete	EXEC	packageName, resourceGroupName, subscriptionId, testBaseAccountName	Hard Delete a Test Base Package.
run_test	EXEC	packageName, resourceGroupName, subscriptionId, testBaseAccountName	Trigger a test run on the package.

SELECT examples

Lists all the packages under a Test Base Account.

vw_packages

SELECT
application_name,
blob_path,
draft_package_id,
first_party_apps,
flighting_ring,
gallery_apps,
inplace_upgrade_os_pair,
intune_enrollment_metadata,
is_enabled,
last_modified_time,
location,
packageName,
package_status,
provisioning_state,
resourceGroupName,
subscriptionId,
tags,
target_os_list,
testBaseAccountName,
test_types,
tests,
validation_results,
version
FROM azure_extras.test_base.vw_packages
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND testBaseAccountName = '{{ testBaseAccountName }}';

packages

SELECT
location,
properties,
tags
FROM azure_extras.test_base.packages
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND testBaseAccountName = '{{ testBaseAccountName }}';

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: applicationName
          value: string
        - name: version
          value: string
        - name: draftPackageId
          value: string
        - name: packageStatus
          value: string
        - name: isEnabled
          value: boolean
        - name: blobPath
          value: string
        - name: validationResults
          value:
            - - name: validationName
                value: string
              - name: isValid
                value: boolean
              - name: errors
                value:
                  - string
        - name: testTypes
          value:
            - []
        - name: targetOSList
          value:
            - - name: osUpdateType
                value: string
              - name: targetOSs
                value:
                  - string
              - name: insiderChannelIds
                value:
                  - string
              - name: baselineOSs
                value:
                  - string
              - name: targetOSImageIds
                value:
                  - string
        - name: inplaceUpgradeOSPair
          value:
            - name: baselineOS
              value:
                - name: osName
                  value: string
                - name: customImageId
                  value: string
                - name: customImageDisplayName
                  value: string
                - name: releaseProperties
                  value:
                    - name: releaseName
                      value: string
                    - name: buildNumber
                      value: string
                    - name: buildRevision
                      value: string
                    - name: releaseVersionDate
                      value: string
            - name: targetOS
              value: string
        - name: lastModifiedTime
          value: string
        - name: flightingRing
          value: string
        - name: firstPartyApps
          value:
            - - name: name
                value: string
              - name: architecture
                value: []
              - name: channel
                value: string
              - name: ring
                value: string
              - name: interopExecutionMode
                value: string
        - name: galleryApps
          value:
            - - name: skuId
                value: string
              - name: isConsented
                value: boolean
        - name: tests
          value:
            - - name: testType
                value: []
              - name: validationRunStatus
                value: string
              - name: validationResultId
                value: string
              - name: isActive
                value: boolean
              - name: commands
                value:
                  - - name: name
                      value: string
                    - name: action
                      value: string
                    - name: contentType
                      value: string
                    - name: content
                      value: string
                    - name: runElevated
                      value: boolean
                    - name: restartAfter
                      value: boolean
                    - name: maxRunTime
                      value: integer
                    - name: runAsInteractive
                      value: boolean
                    - name: alwaysRun
                      value: boolean
                    - name: applyUpdateBefore
                      value: boolean
                    - name: install1PAppBefore
                      value: boolean
                    - name: preUpgrade
                      value: boolean
                    - name: postUpgrade
                      value: boolean
                    - name: enrollIntuneBefore
                      value: boolean
        - name: intuneEnrollmentMetadata
          value:
            - name: appList
              value:
                - - name: appName
                    value: string
                  - name: appId
                    value: string
                  - name: expectedInstallationPath
                    value: string
            - name: credentialId
              value: string
            - name: expectedDeploymentDurationInMinute
              value: integer
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a packages resource.

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

DELETE example

Deletes the specified packages resource.

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