patch_schedules

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

Overview

Name	patch_schedules
Type	Resource
Id	azure_isv.redis.patch_schedules

Fields

vw_patch_schedules

Name	Datatype	Description
name	text	field from the properties object
	text	field from the properties object
cacheName	text	field from the properties object
location	text	The geo-location where the resource lives
resourceGroupName	text	field from the properties object
schedule_entries	text	field from the properties object
subscriptionId	text	field from the properties object

patch_schedules

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	List of patch schedules for a Redis cache.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	default, name, resourceGroupName, subscriptionId	Gets the patching schedule of a redis cache.
list_by_redis_resource	SELECT	cacheName, resourceGroupName, subscriptionId	Gets all patch schedules in the specified redis cache (there is only one).
create_or_update	INSERT	default, name, resourceGroupName, subscriptionId, data__properties	Create or replace the patching schedule for Redis cache.
delete	DELETE	default, name, resourceGroupName, subscriptionId	Deletes the patching schedule of a redis cache.

SELECT examples

Gets all patch schedules in the specified redis cache (there is only one).

vw_patch_schedules

SELECT
name,
,
cacheName,
location,
resourceGroupName,
schedule_entries,
subscriptionId
FROM azure_isv.redis.vw_patch_schedules
WHERE cacheName = '{{ cacheName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

patch_schedules

SELECT
location,
properties
FROM azure_isv.redis.patch_schedules
WHERE cacheName = '{{ cacheName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_isv.redis.patch_schedules (
default,
name,
resourceGroupName,
subscriptionId,
data__properties,
properties
)
SELECT 
'{{ default }}',
'{{ name }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: scheduleEntries
          value:
            - - name: dayOfWeek
                value: string
              - name: startHourUtc
                value: integer
              - name: maintenanceWindow
                value: string
    - name: location
      value: string

DELETE example

Deletes the specified patch_schedules resource.

/*+ delete */
DELETE FROM azure_isv.redis.patch_schedules
WHERE default = '{{ default }}'
AND name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';