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

The following fields are returned by SELECT queries:

get

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

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	resourceGroupName, name, environmentName, databaseConnectionName, subscriptionId
create_or_update	insert	resourceGroupName, name, environmentName, databaseConnectionName, subscriptionId		Description for Create or update a database connection for a static site build
update	update	resourceGroupName, name, environmentName, databaseConnectionName, subscriptionId		Description for Create or update a database connection for a static site build
delete	delete	resourceGroupName, name, environmentName, databaseConnectionName, subscriptionId

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
databaseConnectionName	string	Name of the database connection.
environmentName	string	The stage site identifier.
name	string	Name of the static site
resourceGroupName	string	Name of the resource group to which the resource belongs.
subscriptionId	string	Your Azure subscription ID. This is a GUID-formatted string (e.g. 00000000-0000-0000-0000-000000000000).

SELECT examples

get

OK

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

INSERT examples

create_or_update

Description for Create or update a database connection for a static site build

INSERT INTO azure.app_service.build_database_connections (
data__kind,
data__properties,
resourceGroupName,
name,
environmentName,
databaseConnectionName,
subscriptionId
)
SELECT 
'{{ kind }}',
'{{ properties }}',
'{{ resourceGroupName }}',
'{{ name }}',
'{{ environmentName }}',
'{{ databaseConnectionName }}',
'{{ subscriptionId }}'
RETURNING
id,
name,
kind,
properties,
type
;

Manifest

# Description fields are for documentation purposes
- name: build_database_connections
  props:
    - name: resourceGroupName
      value: string
      description: Required parameter for the build_database_connections resource.
    - name: name
      value: string
      description: Required parameter for the build_database_connections resource.
    - name: environmentName
      value: string
      description: Required parameter for the build_database_connections resource.
    - name: databaseConnectionName
      value: string
      description: Required parameter for the build_database_connections resource.
    - name: subscriptionId
      value: string
      description: Required parameter for the build_database_connections resource.
    - name: kind
      value: string
      description: |
        Kind of resource.
    - name: properties
      value: object
      description: |
        DatabaseConnection resource specific properties

UPDATE examples

update

Description for Create or update a database connection for a static site build

UPDATE azure.app_service.build_database_connections
SET 
data__properties = '{{ properties }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}' --required
AND name = '{{ name }}' --required
AND environmentName = '{{ environmentName }}' --required
AND databaseConnectionName = '{{ databaseConnectionName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
RETURNING
id,
name,
kind,
properties,
type;

DELETE examples

delete

No description available.

DELETE FROM azure.app_service.build_database_connections
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND name = '{{ name }}' --required
AND environmentName = '{{ environmentName }}' --required
AND databaseConnectionName = '{{ databaseConnectionName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;