community_trainings

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

Overview

Name	community_trainings
Type	Resource
Id	azure_extras.community_training.community_trainings

Fields

vw_community_trainings

Name	Datatype	Description
communityTrainingName	text	field from the properties object
disaster_recovery_enabled	text	field from the properties object
identity_configuration	text	field from the properties object
location	text	The geo-location where the resource lives
portal_admin_email_address	text	field from the properties object
portal_name	text	field from the properties object
portal_owner_email_address	text	field from the properties object
portal_owner_organization_name	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
sku	text	The resource model definition representing SKU
subscriptionId	text	field from the properties object
tags	text	Resource tags.
zone_redundancy_enabled	text	field from the properties object

community_trainings

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	Details of the Community CommunityTraining.
sku	object	The resource model definition representing SKU
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	communityTrainingName, resourceGroupName, subscriptionId	Get a CommunityTraining
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List CommunityTraining resources by resource group
list_by_subscription	SELECT	subscriptionId	List CommunityTraining resources by subscription ID
create	INSERT	communityTrainingName, resourceGroupName, subscriptionId	Create a CommunityTraining
delete	DELETE	communityTrainingName, resourceGroupName, subscriptionId	Delete a CommunityTraining
update	UPDATE	communityTrainingName, resourceGroupName, subscriptionId	Update a CommunityTraining

SELECT examples

List CommunityTraining resources by subscription ID

vw_community_trainings

SELECT
communityTrainingName,
disaster_recovery_enabled,
identity_configuration,
location,
portal_admin_email_address,
portal_name,
portal_owner_email_address,
portal_owner_organization_name,
provisioning_state,
resourceGroupName,
sku,
subscriptionId,
tags,
zone_redundancy_enabled
FROM azure_extras.community_training.vw_community_trainings
WHERE subscriptionId = '{{ subscriptionId }}';

community_trainings

SELECT
location,
properties,
sku,
tags
FROM azure_extras.community_training.community_trainings
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.community_training.community_trainings (
communityTrainingName,
resourceGroupName,
subscriptionId,
properties,
sku,
tags,
location
)
SELECT 
'{{ communityTrainingName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ sku }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: portalName
          value: string
        - name: portalAdminEmailAddress
          value: string
        - name: portalOwnerOrganizationName
          value: string
        - name: portalOwnerEmailAddress
          value: string
        - name: identityConfiguration
          value:
            - name: identityType
              value: string
            - name: teamsEnabled
              value: boolean
            - name: tenantId
              value: string
            - name: domainName
              value: string
            - name: clientId
              value: string
            - name: clientSecret
              value: string
            - name: b2cAuthenticationPolicy
              value: string
            - name: b2cPasswordResetPolicy
              value: string
            - name: customLoginParameters
              value: string
        - name: zoneRedundancyEnabled
          value: boolean
        - name: disasterRecoveryEnabled
          value: boolean
        - name: provisioningState
          value: []
    - name: sku
      value:
        - name: name
          value: string
        - name: tier
          value: []
        - name: size
          value: string
        - name: family
          value: string
        - name: capacity
          value: integer
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a community_trainings resource.

/*+ update */
UPDATE azure_extras.community_training.community_trainings
SET 
sku = '{{ sku }}',
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
communityTrainingName = '{{ communityTrainingName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified community_trainings resource.

/*+ delete */
DELETE FROM azure_extras.community_training.community_trainings
WHERE communityTrainingName = '{{ communityTrainingName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';