videos

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

Overview

Name	videos
Type	Resource
Id	azure.video_analyzer.videos

Fields

vw_videos

Name	Datatype	Description
description	text	field from the properties object
accountName	text	field from the properties object
archival	text	field from the properties object
content_urls	text	field from the properties object
flags	text	field from the properties object
media_info	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
title	text	field from the properties object
type	text	field from the properties object
videoName	text	field from the properties object

videos

Name	Datatype	Description
properties	object	Application level properties for the video resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, resourceGroupName, subscriptionId, videoName	Retrieves an existing video resource with the given name.
list	SELECT	accountName, resourceGroupName, subscriptionId	Retrieves a list of video resources that have been created, along with their JSON representations.
create_or_update	INSERT	accountName, resourceGroupName, subscriptionId, videoName	Creates a new video resource or updates an existing video resource with the given name.
delete	DELETE	accountName, resourceGroupName, subscriptionId, videoName	Deletes an existing video resource and its underlying data. This operation is irreversible.
update	UPDATE	accountName, resourceGroupName, subscriptionId, videoName	Updates individual properties of an existing video resource with the given name.

SELECT examples

Retrieves a list of video resources that have been created, along with their JSON representations.

vw_videos

SELECT
description,
accountName,
archival,
content_urls,
flags,
media_info,
resourceGroupName,
subscriptionId,
title,
type,
videoName
FROM azure.video_analyzer.vw_videos
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

videos

SELECT
properties
FROM azure.video_analyzer.videos
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.video_analyzer.videos (
accountName,
resourceGroupName,
subscriptionId,
videoName,
properties
)
SELECT 
'{{ accountName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ videoName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: title
          value: string
        - name: description
          value: string
        - name: type
          value: string
        - name: flags
          value:
            - name: canStream
              value: boolean
            - name: hasData
              value: boolean
            - name: isInUse
              value: boolean
        - name: contentUrls
          value:
            - name: downloadUrl
              value: string
            - name: archiveBaseUrl
              value: string
            - name: rtspTunnelUrl
              value: string
            - name: previewImageUrls
              value:
                - name: small
                  value: string
                - name: medium
                  value: string
                - name: large
                  value: string
        - name: mediaInfo
          value:
            - name: segmentLength
              value: string
        - name: archival
          value:
            - name: retentionPeriod
              value: string

UPDATE example

Updates a videos resource.

/*+ update */
UPDATE azure.video_analyzer.videos
SET 
properties = '{{ properties }}'
WHERE 
accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND videoName = '{{ videoName }}';

DELETE example

Deletes the specified videos resource.

/*+ delete */
DELETE FROM azure.video_analyzer.videos
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND videoName = '{{ videoName }}';