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

The following fields are returned by SELECT queries:

get

Azure operation completed successfully.

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	The resource-specific properties for this resource.
sku	object	The SKU (Stock Keeping Unit) assigned to this resource.
tags	object	Resource tags.

list_by_resource_group

Azure operation completed successfully.

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	The resource-specific properties for this resource.
sku	object	The SKU (Stock Keeping Unit) assigned to this resource.
tags	object	Resource tags.

list_by_subscription

Azure operation completed successfully.

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	The resource-specific properties for this resource.
sku	object	The SKU (Stock Keeping Unit) assigned to this resource.
tags	object	Resource tags.

Methods

The following methods are available for this resource:

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

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
communityTrainingName	string	The name of the Community Training Resource
resourceGroupName	string	The name of the resource group. The name is case insensitive.
subscriptionId	string	The ID of the target subscription.

SELECT examples

get

Get a CommunityTraining

SELECT
location,
properties,
sku,
tags
FROM azure_extras.community_training.community_trainings
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND communityTrainingName = '{{ communityTrainingName }}' -- required
;

list_by_resource_group

List CommunityTraining resources by resource group

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

list_by_subscription

List CommunityTraining resources by subscription ID

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

INSERT examples

create

Create a CommunityTraining

INSERT INTO azure_extras.community_training.community_trainings (
data__properties,
data__sku,
data__tags,
data__location,
subscriptionId,
resourceGroupName,
communityTrainingName
)
SELECT 
'{{ properties }}',
'{{ sku }}',
'{{ tags }}',
'{{ location }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ communityTrainingName }}'
RETURNING
location,
properties,
sku,
tags
;

Manifest

# Description fields are for documentation purposes
- name: community_trainings
  props:
    - name: subscriptionId
      value: string
      description: Required parameter for the community_trainings resource.
    - name: resourceGroupName
      value: string
      description: Required parameter for the community_trainings resource.
    - name: communityTrainingName
      value: string
      description: Required parameter for the community_trainings resource.
    - name: properties
      value: object
      description: |
        The resource-specific properties for this resource.
    - name: sku
      value: object
      description: |
        The SKU (Stock Keeping Unit) assigned to this resource.
    - name: tags
      value: object
      description: |
        Resource tags.
    - name: location
      value: string
      description: |
        The geo-location where the resource lives

UPDATE examples

update

Update a CommunityTraining

UPDATE azure_extras.community_training.community_trainings
SET 
data__sku = '{{ sku }}',
data__tags = '{{ tags }}',
data__properties = '{{ properties }}'
WHERE 
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND communityTrainingName = '{{ communityTrainingName }}' --required
RETURNING
location,
properties,
sku,
tags;

DELETE examples

delete

Delete a CommunityTraining

DELETE FROM azure_extras.community_training.community_trainings
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND communityTrainingName = '{{ communityTrainingName }}' --required
;