workflows

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

Overview

Name	workflows
Type	Resource
Id	azure_extras.developer_hub.workflows

Fields

vw_workflows

Name	Datatype	Description
artifact_generation_properties	text	field from the properties object
azure_pipeline_profile	text	field from the properties object
github_workflow_profile	text	field from the properties object
location	text	The geo-location where the resource lives
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
workflowName	text	field from the properties object

workflows

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	Workflow properties
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, subscriptionId, workflowName
list	SELECT	subscriptionId
list_by_resource_group	SELECT	resourceGroupName, subscriptionId
create_or_update	INSERT	resourceGroupName, subscriptionId, workflowName
delete	DELETE	resourceGroupName, subscriptionId, workflowName
update_tags	EXEC	resourceGroupName, subscriptionId, workflowName

SELECT examples

vw_workflows

SELECT
artifact_generation_properties,
azure_pipeline_profile,
github_workflow_profile,
location,
resourceGroupName,
subscriptionId,
tags,
workflowName
FROM azure_extras.developer_hub.vw_workflows
WHERE subscriptionId = '{{ subscriptionId }}';

workflows

SELECT
location,
properties,
tags
FROM azure_extras.developer_hub.workflows
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.developer_hub.workflows (
resourceGroupName,
subscriptionId,
workflowName,
tags,
location,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ workflowName }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: location
      value: string
    - name: properties
      value:
        - name: githubWorkflowProfile
          value:
            - name: repositoryOwner
              value: string
            - name: repositoryName
              value: string
            - name: branchName
              value: string
            - name: dockerfile
              value: string
            - name: dockerBuildContext
              value: string
            - name: deploymentProperties
              value:
                - name: manifestType
                  value: []
                - name: kubeManifestLocations
                  value:
                    - string
                - name: helmChartPath
                  value: string
                - name: helmValues
                  value: string
                - name: overrides
                  value: object
            - name: namespace
              value: string
            - name: acr
              value:
                - name: acrSubscriptionId
                  value: string
                - name: acrResourceGroup
                  value: string
                - name: acrRegistryName
                  value: string
                - name: acrRepositoryName
                  value: string
            - name: oidcCredentials
              value:
                - name: azureClientId
                  value: string
                - name: azureTenantId
                  value: string
            - name: aksResourceId
              value: string
            - name: prURL
              value: string
            - name: pullNumber
              value: integer
            - name: prStatus
              value: []
            - name: lastWorkflowRun
              value:
                - name: succeeded
                  value: boolean
                - name: workflowRunURL
                  value: string
                - name: lastRunAt
                  value: string
                - name: workflowRunStatus
                  value: []
            - name: authStatus
              value: []
        - name: artifactGenerationProperties
          value:
            - name: generationLanguage
              value: []
            - name: languageVersion
              value: string
            - name: builderVersion
              value: string
            - name: port
              value: string
            - name: appName
              value: string
            - name: dockerfileOutputDirectory
              value: string
            - name: manifestOutputDirectory
              value: string
            - name: dockerfileGenerationMode
              value: []
            - name: manifestGenerationMode
              value: []
            - name: manifestType
              value: []
            - name: imageName
              value: string
            - name: namespace
              value: string
            - name: imageTag
              value: string
        - name: azurePipelineProfile
          value:
            - name: repository
              value:
                - name: repositoryOwner
                  value: string
                - name: repositoryName
                  value: string
                - name: branchName
                  value: string
                - name: adoOrganization
                  value: string
                - name: projectName
                  value: string
            - name: armServiceConnection
              value: string
            - name: build
              value:
                - name: dockerfile
                  value: string
                - name: dockerBuildContext
                  value: string
            - name: namespace
              value: string
            - name: acr
              value: string
            - name: clusterId
              value: string
            - name: pullRequest
              value:
                - name: prURL
                  value: string
                - name: pullNumber
                  value: integer

DELETE example

Deletes the specified workflows resource.

/*+ delete */
DELETE FROM azure_extras.developer_hub.workflows
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workflowName = '{{ workflowName }}';