projects

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

Overview

Name	projects
Type	Resource
Id	azure.dev_center.projects

Fields

vw_projects

Name	Datatype	Description
description	text	field from the properties object
catalog_settings	text	field from the properties object
dev_center_id	text	field from the properties object
dev_center_uri	text	field from the properties object
display_name	text	field from the properties object
identity	text	Managed service identity (system assigned and/or user assigned identities)
location	text	The geo-location where the resource lives
max_dev_boxes_per_user	text	field from the properties object
projectName	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.

projects

Name	Datatype	Description
identity	object	Managed service identity (system assigned and/or user assigned identities)
location	string	The geo-location where the resource lives
properties	object	Properties of a project.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	projectName, resourceGroupName, subscriptionId	Gets a specific project.
get_inherited_settings	SELECT	projectName, resourceGroupName, subscriptionId	Gets applicable inherited settings for this project.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Lists all projects in the resource group.
list_by_subscription	SELECT	subscriptionId	Lists all projects in the subscription.
create_or_update	INSERT	projectName, resourceGroupName, subscriptionId	Creates or updates a project.
delete	DELETE	projectName, resourceGroupName, subscriptionId	Deletes a project resource.
update	UPDATE	projectName, resourceGroupName, subscriptionId	Partially updates a project.

SELECT examples

Lists all projects in the subscription.

vw_projects

SELECT
description,
catalog_settings,
dev_center_id,
dev_center_uri,
display_name,
identity,
location,
max_dev_boxes_per_user,
projectName,
provisioning_state,
resourceGroupName,
subscriptionId,
tags
FROM azure.dev_center.vw_projects
WHERE subscriptionId = '{{ subscriptionId }}';

projects

SELECT
identity,
location,
properties,
tags
FROM azure.dev_center.projects
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: location
      value: string
    - name: properties
      value:
        - name: devCenterId
          value: string
        - name: description
          value: string
        - name: maxDevBoxesPerUser
          value: integer
        - name: displayName
          value: string
        - name: catalogSettings
          value:
            - name: catalogItemSyncTypes
              value:
                - []
        - name: provisioningState
          value: []
        - name: devCenterUri
          value: []
    - name: identity
      value:
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: type
          value: []
        - name: userAssignedIdentities
          value: []

UPDATE example

Updates a projects resource.

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

DELETE example

Deletes the specified projects resource.

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