draft_packages

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

Overview

Name	draft_packages
Type	Resource
Id	azure_extras.test_base.draft_packages

Fields

vw_draft_packages

Name	Datatype	Description
app_file_name	text	field from the properties object
application_name	text	field from the properties object
comments	text	field from the properties object
draftPackageName	text	field from the properties object
draft_package_path	text	field from the properties object
edit_package	text	field from the properties object
executable_launch_command	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
highlighted_files	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
intune_metadata	text	field from the properties object
last_modified_time	text	field from the properties object
package_id	text	field from the properties object
package_tags	text	field from the properties object
process_name	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
source_type	text	field from the properties object
subscriptionId	text	field from the properties object
tab_state	text	field from the properties object
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
use_autofill	text	field from the properties object
use_sample	text	field from the properties object
version	text	field from the properties object
working_path	text	field from the properties object

draft_packages

Name	Datatype	Description
properties	object	The properties of the Test Base Draft Package.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	draftPackageName, resourceGroupName, subscriptionId, testBaseAccountName	Gets a Test Base Draft Package.
list_by_test_base_account	SELECT	resourceGroupName, subscriptionId, testBaseAccountName	Lists all the draft packages under a test base account.
create	INSERT	draftPackageName, resourceGroupName, subscriptionId, testBaseAccountName	Creates or replaces a Test Base Draft Package.
delete	DELETE	draftPackageName, resourceGroupName, subscriptionId, testBaseAccountName	Deletes a Test Base Draft Package.
update	UPDATE	draftPackageName, resourceGroupName, subscriptionId, testBaseAccountName	Updates an existing Test Base Draft Package.
copy_from_package	EXEC	draftPackageName, resourceGroupName, subscriptionId, testBaseAccountName, data__packageId	Copy package file and metadata from a package to this draft package
extract_file	EXEC	draftPackageName, resourceGroupName, subscriptionId, testBaseAccountName, data__sourceFile	Performs extracting file operation for a Test Base Draft Package
generate_folders_and_scripts	EXEC	draftPackageName, resourceGroupName, subscriptionId, testBaseAccountName	Generates folders and scripts

SELECT examples

Lists all the draft packages under a test base account.

vw_draft_packages

SELECT
app_file_name,
application_name,
comments,
draftPackageName,
draft_package_path,
edit_package,
executable_launch_command,
first_party_apps,
flighting_ring,
gallery_apps,
highlighted_files,
inplace_upgrade_os_pair,
intune_enrollment_metadata,
intune_metadata,
last_modified_time,
package_id,
package_tags,
process_name,
provisioning_state,
resourceGroupName,
source_type,
subscriptionId,
tab_state,
target_os_list,
testBaseAccountName,
test_types,
tests,
use_autofill,
use_sample,
version,
working_path
FROM azure_extras.test_base.vw_draft_packages
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND testBaseAccountName = '{{ testBaseAccountName }}';

draft_packages

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

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: applicationName
          value: string
        - name: version
          value: string
        - name: draftPackagePath
          value: string
        - name: workingPath
          value: string
        - name: appFileName
          value: string
        - name: sourceType
          value: []
        - name: useSample
          value: boolean
        - name: comments
          value: string
        - name: intuneMetadata
          value:
            - name: intuneApp
              value:
                - name: appName
                  value: string
                - name: version
                  value: string
                - name: appId
                  value: string
                - name: publisher
                  value: string
                - name: description
                  value: string
                - name: owner
                  value: string
                - name: createDate
                  value: string
                - name: dependentAppCount
                  value: integer
                - name: installCommand
                  value: string
                - name: uninstallCommand
                  value: string
                - name: lastProcessed
                  value: integer
                - name: dependencyIds
                  value:
                    - string
                - name: setupFile
                  value: string
                - name: minimumSupportedOS
                  value: string
                - name: status
                  value: string
                - name: expectedExitCodes
                  value:
                    - string
            - name: intuneAppDependencies
              value:
                - - name: appName
                    value: string
                  - name: version
                    value: string
                  - name: appId
                    value: string
                  - name: publisher
                    value: string
                  - name: description
                    value: string
                  - name: owner
                    value: string
                  - name: createDate
                    value: string
                  - name: dependentAppCount
                    value: integer
                  - name: installCommand
                    value: string
                  - name: uninstallCommand
                    value: string
                  - name: lastProcessed
                    value: integer
                  - name: dependencyIds
                    value:
                      - string
                  - name: setupFile
                    value: string
                  - name: minimumSupportedOS
                    value: string
                  - name: status
                    value: string
                  - name: expectedExitCodes
                    value:
                      - string
        - name: highlightedFiles
          value:
            - - name: path
                value: string
              - name: visited
                value: boolean
              - name: sections
                value:
                  - string
        - name: packageTags
          value: []
        - name: editPackage
          value: boolean
        - name: packageId
          value: string
        - name: useAutofill
          value: boolean
        - name: executableLaunchCommand
          value: string
        - name: processName
          value: string
        - name: tabState
          value:
            - name: currentTab
              value: []
            - name: visitedTabs
              value:
                - []
        - name: testTypes
          value:
            - []
        - name: provisioningState
          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

UPDATE example

Updates a draft_packages resource.

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

DELETE example

Deletes the specified draft_packages resource.

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