project_catalogs

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

Overview

Name	project_catalogs
Type	Resource
Id	azure.dev_center.project_catalogs

Fields

vw_project_catalogs

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
ado_git	text	field from the properties object
catalogName	text	field from the properties object
connection_state	text	field from the properties object
git_hub	text	field from the properties object
last_connection_time	text	field from the properties object
last_sync_stats	text	field from the properties object
last_sync_time	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
sync_state	text	field from the properties object
sync_type	text	field from the properties object
system_data	text	field from the properties object
tags	text	field from the properties object
type	text	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

project_catalogs

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
properties	object	Properties of a catalog.
systemData	object	Metadata pertaining to creation and last modification of the resource.
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	catalogName, projectName, resourceGroupName, subscriptionId	Gets an associated project catalog.
list	SELECT	projectName, resourceGroupName, subscriptionId	Lists the catalogs associated with a project.
create_or_update	INSERT	catalogName, projectName, resourceGroupName, subscriptionId	Creates or updates a project catalog.
delete	DELETE	catalogName, projectName, resourceGroupName, subscriptionId	Deletes a project catalog resource.
patch	UPDATE	catalogName, projectName, resourceGroupName, subscriptionId	Partially updates a project catalog.
connect	EXEC	catalogName, projectName, resourceGroupName, subscriptionId	Connects a project catalog to enable syncing.
sync	EXEC	catalogName, projectName, resourceGroupName, subscriptionId	Syncs templates for a template source.

SELECT examples

Lists the catalogs associated with a project.

vw_project_catalogs

SELECT
id,
name,
ado_git,
catalogName,
connection_state,
git_hub,
last_connection_time,
last_sync_stats,
last_sync_time,
projectName,
provisioning_state,
resourceGroupName,
subscriptionId,
sync_state,
sync_type,
system_data,
tags,
type
FROM azure.dev_center.vw_project_catalogs
WHERE projectName = '{{ projectName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

project_catalogs

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.dev_center.project_catalogs (
catalogName,
projectName,
resourceGroupName,
subscriptionId,
properties
)
SELECT 
'{{ catalogName }}',
'{{ projectName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

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: gitHub
          value:
            - name: uri
              value: string
            - name: branch
              value: string
            - name: secretIdentifier
              value: string
            - name: path
              value: string
        - name: syncType
          value: string
        - name: tags
          value: object
        - name: provisioningState
          value: []
        - name: syncState
          value: string
        - name: lastSyncStats
          value:
            - name: added
              value: integer
            - name: updated
              value: integer
            - name: unchanged
              value: integer
            - name: removed
              value: integer
            - name: validationErrors
              value: integer
            - name: synchronizationErrors
              value: integer
            - name: syncedCatalogItemTypes
              value:
                - []
        - name: connectionState
          value: string
        - name: lastConnectionTime
          value: string
        - name: lastSyncTime
          value: string

UPDATE example

Updates a project_catalogs resource.

/*+ update */
UPDATE azure.dev_center.project_catalogs
SET 
properties = '{{ properties }}'
WHERE 
catalogName = '{{ catalogName }}'
AND projectName = '{{ projectName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified project_catalogs resource.

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