projects

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

Overview

Name	projects
Type	Resource
Id	azure_extras.visual_studio.projects

Fields

Name	Datatype	Description
id	string	Unique identifier of the resource.
name	string	Resource name.
location	string	Resource location.
properties	object	Key/value pair of resource properties.
tags	object	Resource tags.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, resourceName, rootResourceName, subscriptionId	Gets the details of a Team Services project resource.
list_by_resource_group	SELECT	resourceGroupName, rootResourceName, subscriptionId	Gets all Visual Studio Team Services project resources created in the specified Team Services account.
create	INSERT	resourceGroupName, resourceName, rootResourceName, subscriptionId	Creates a Team Services project in the collection with the specified name. 'VersionControlOption' and 'ProcessTemplateId' must be specified in the resource properties. Valid values for VersionControlOption: Git, Tfvc. Valid values for ProcessTemplateId: 6B724908-EF14-45CF-84F8-768B5384DA45, ADCC42AB-9882-485E-A3ED-7678F01F66BC, 27450541-8E31-4150-9947-DC59F998FC01 (these IDs correspond to Scrum, Agile, and CMMI process templates).
update	UPDATE	resourceGroupName, resourceName, rootResourceName, subscriptionId	Updates the tags of the specified Team Services project.

SELECT examples

Gets all Visual Studio Team Services project resources created in the specified Team Services account.

SELECT
id,
name,
location,
properties,
tags,
type
FROM azure_extras.visual_studio.projects
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND rootResourceName = '{{ rootResourceName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.visual_studio.projects (
resourceGroupName,
resourceName,
rootResourceName,
subscriptionId,
location,
tags,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ resourceName }}',
'{{ rootResourceName }}',
'{{ subscriptionId }}',
'{{ location }}',
'{{ tags }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: location
      value: string
    - name: name
      value: string
    - name: tags
      value: object
    - name: type
      value: string
    - name: properties
      value: object

UPDATE example

Updates a projects resource.

/*+ update */
UPDATE azure_extras.visual_studio.projects
SET 
location = '{{ location }}',
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND rootResourceName = '{{ rootResourceName }}'
AND subscriptionId = '{{ subscriptionId }}';