databases#

Exec module for managing SQL databases.

async idem_azure.exec.azure.sql_database.databases.get(hub, ctx, resource_id: str, name: str = None, raw: bool = False) Dict[str, Any][source]#

Get SQL Database resource by resource_id.

Parameters:
  • resource_id (str) – The resource_id of database

  • name (str, Optional) – The name of the resource

  • raw (bool, Optional) – Returns raw response if True. Defaults to False

Returns:

Dict[str, Any]

Examples

Calling this exec module function from the cli with resource_id:

idem exec azure.sql_database.databases.get resource_id="value"

Using in a state:

  my_unmanaged_resource:
    exec.run:
      - path:  azure.sql_database.databases.get
      - kwargs:
          resource_id: "/subscriptions/11111111-2222-3333-4444-555555555555/resourceGroups/default-rg/providers/Microsoft.Sql/servers/my-server/databases/my-sqldb"

"
async idem_azure.exec.azure.sql_database.databases.list_(hub, ctx, resource_group_name: str = None, server_name: str = None) Dict[source]#

List of SQL databases

Returns:

Dict[str, Any]

Examples

Calling this exec module function from the cli with resource_id:

idem exec azure.sql_database.databases.list

Using in a state:

my_unmanaged_resource:
  exec.run:
    - path: azure.sql_database.databases.list
    - kwargs:
      resource_group_name: default-rg
      server_name: my-srv