certificates

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

Overview

Name	certificates
Type	Resource
Id	azure_isv.nginx.certificates

Fields

vw_certificates

Name	Datatype	Description
id	text	field from the properties object
name	text	field from the properties object
certificateName	text	field from the properties object
certificate_error	text	field from the properties object
certificate_virtual_path	text	field from the properties object
deploymentName	text	field from the properties object
key_vault_secret_created	text	field from the properties object
key_vault_secret_id	text	field from the properties object
key_vault_secret_version	text	field from the properties object
key_virtual_path	text	field from the properties object
location	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
sha1_thumbprint	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
type	text	field from the properties object

certificates

Name	Datatype	Description
id	string
name	string
location	string
properties	object
systemData	object	Metadata pertaining to creation and last modification of the resource.
type	string

Methods

Name	Accessible by	Required Params	Description
get	SELECT	certificateName, deploymentName, resourceGroupName, subscriptionId
list	SELECT	deploymentName, resourceGroupName, subscriptionId
create_or_update	INSERT	certificateName, deploymentName, resourceGroupName, subscriptionId
delete	DELETE	certificateName, deploymentName, resourceGroupName, subscriptionId

SELECT examples

vw_certificates

SELECT
id,
name,
certificateName,
certificate_error,
certificate_virtual_path,
deploymentName,
key_vault_secret_created,
key_vault_secret_id,
key_vault_secret_version,
key_virtual_path,
location,
provisioning_state,
resourceGroupName,
sha1_thumbprint,
subscriptionId,
system_data,
type
FROM azure_isv.nginx.vw_certificates
WHERE deploymentName = '{{ deploymentName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

certificates

SELECT
id,
name,
location,
properties,
systemData,
type
FROM azure_isv.nginx.certificates
WHERE deploymentName = '{{ deploymentName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_isv.nginx.certificates (
certificateName,
deploymentName,
resourceGroupName,
subscriptionId,
properties,
location
)
SELECT 
'{{ certificateName }}',
'{{ deploymentName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: keyVirtualPath
          value: string
        - name: certificateVirtualPath
          value: string
        - name: keyVaultSecretId
          value: string
        - name: sha1Thumbprint
          value: string
        - name: keyVaultSecretVersion
          value: string
        - name: keyVaultSecretCreated
          value: string
        - name: certificateError
          value:
            - name: code
              value: string
            - name: message
              value: string
    - name: location
      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

DELETE example

Deletes the specified certificates resource.

/*+ delete */
DELETE FROM azure_isv.nginx.certificates
WHERE certificateName = '{{ certificateName }}'
AND deploymentName = '{{ deploymentName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';