database_connections

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

Overview

Name	database_connections
Type	Resource
Id	azure.app_service.database_connections

Fields

Name	Datatype	Description
id	string	Resource Id.
name	string	Resource Name.
kind	string	Kind of resource.
properties	object	DatabaseConnection resource specific properties
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	databaseConnectionName, name, resourceGroupName, subscriptionId
create_or_update	INSERT	databaseConnectionName, name, resourceGroupName, subscriptionId	Description for Create or update a database connection for a static site
delete	DELETE	databaseConnectionName, name, resourceGroupName, subscriptionId
update	UPDATE	databaseConnectionName, name, resourceGroupName, subscriptionId	Description for Create or update a database connection for a static site

SELECT examples

SELECT
id,
name,
kind,
properties,
type
FROM azure.app_service.database_connections
WHERE databaseConnectionName = '{{ databaseConnectionName }}'
AND name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.app_service.database_connections (
databaseConnectionName,
name,
resourceGroupName,
subscriptionId,
kind,
properties
)
SELECT 
'{{ databaseConnectionName }}',
'{{ name }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ kind }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: kind
      value: string
    - name: type
      value: string
    - name: properties
      value:
        - name: resourceId
          value: string
        - name: connectionIdentity
          value: string
        - name: connectionString
          value: string
        - name: region
          value: string
        - name: configurationFiles
          value:
            - - name: fileName
                value: string
              - name: contents
                value: string
              - name: type
                value: string

UPDATE example

Updates a database_connections resource.

/*+ update */
UPDATE azure.app_service.database_connections
SET 
properties = '{{ properties }}'
WHERE 
databaseConnectionName = '{{ databaseConnectionName }}'
AND name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified database_connections resource.

/*+ delete */
DELETE FROM azure.app_service.database_connections
WHERE databaseConnectionName = '{{ databaseConnectionName }}'
AND name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';