project_environment_types

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

Overview

Name	project_environment_types
Type	Resource
Id	azure.dev_center.project_environment_types

Fields

vw_project_environment_types

Name	Datatype	Description
id	text	Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
name	text	The name of the resource
creator_role_assignment	text	field from the properties object
deployment_target_id	text	field from the properties object
display_name	text	field from the properties object
environmentTypeName	text	field from the properties object
environment_count	text	field from the properties object
identity	text	Managed service identity (system assigned and/or user assigned identities)
location	text	The geo-location for the environment type
projectName	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
status	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
tags	text	Resource tags.
type	text	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
user_role_assignments	text	field from the properties object

project_environment_types

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
name	string	The name of the resource
identity	object	Managed service identity (system assigned and/or user assigned identities)
location	string	The geo-location for the environment type
properties	object	Properties of a project environment type.
systemData	object	Metadata pertaining to creation and last modification of the resource.
tags	object	Resource tags.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

Name	Accessible by	Required Params	Description
get	SELECT	environmentTypeName, projectName, resourceGroupName, subscriptionId	Gets a project environment type.
list	SELECT	projectName, resourceGroupName, subscriptionId	Lists environment types for a project.
create_or_update	INSERT	environmentTypeName, projectName, resourceGroupName, subscriptionId	Creates or updates a project environment type.
delete	DELETE	environmentTypeName, projectName, resourceGroupName, subscriptionId	Deletes a project environment type.
update	UPDATE	environmentTypeName, projectName, resourceGroupName, subscriptionId	Partially updates a project environment type.

SELECT examples

Lists environment types for a project.

vw_project_environment_types

SELECT
id,
name,
creator_role_assignment,
deployment_target_id,
display_name,
environmentTypeName,
environment_count,
identity,
location,
projectName,
provisioning_state,
resourceGroupName,
status,
subscriptionId,
system_data,
tags,
type,
user_role_assignments
FROM azure.dev_center.vw_project_environment_types
WHERE projectName = '{{ projectName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

project_environment_types

SELECT
id,
name,
identity,
location,
properties,
systemData,
tags,
type
FROM azure.dev_center.project_environment_types
WHERE projectName = '{{ projectName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.dev_center.project_environment_types (
environmentTypeName,
projectName,
resourceGroupName,
subscriptionId,
properties,
tags,
identity,
location
)
SELECT 
'{{ environmentTypeName }}',
'{{ projectName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ tags }}',
'{{ identity }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: properties
      value:
        - name: deploymentTargetId
          value: string
        - name: displayName
          value: string
        - name: status
          value: []
        - name: creatorRoleAssignment
          value:
            - name: roles
              value: object
        - name: userRoleAssignments
          value: object
        - name: provisioningState
          value: []
        - name: environmentCount
          value: integer
    - name: tags
      value: []
    - name: identity
      value:
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: type
          value: []
        - name: userAssignedIdentities
          value: []
    - name: location
      value: string

UPDATE example

Updates a project_environment_types resource.

/*+ update */
UPDATE azure.dev_center.project_environment_types
SET 
properties = '{{ properties }}',
tags = '{{ tags }}',
identity = '{{ identity }}'
WHERE 
environmentTypeName = '{{ environmentTypeName }}'
AND projectName = '{{ projectName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified project_environment_types resource.

/*+ delete */
DELETE FROM azure.dev_center.project_environment_types
WHERE environmentTypeName = '{{ environmentTypeName }}'
AND projectName = '{{ projectName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';