build_database_connections

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

Overview

Name	build_database_connections
Type	Resource
Id	azure.app_service.build_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, environmentName, name, resourceGroupName, subscriptionId
create_or_update	INSERT	databaseConnectionName, environmentName, name, resourceGroupName, subscriptionId	Description for Create or update a database connection for a static site build
delete	DELETE	databaseConnectionName, environmentName, name, resourceGroupName, subscriptionId
update	UPDATE	databaseConnectionName, environmentName, name, resourceGroupName, subscriptionId	Description for Create or update a database connection for a static site build

SELECT examples

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.app_service.build_database_connections (
databaseConnectionName,
environmentName,
name,
resourceGroupName,
subscriptionId,
kind,
properties
)
SELECT 
'{{ databaseConnectionName }}',
'{{ environmentName }}',
'{{ 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 build_database_connections resource.

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

DELETE example

Deletes the specified build_database_connections resource.

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