-
Notifications
You must be signed in to change notification settings - Fork 10
/
azure-mssql-server.yml
163 lines (163 loc) · 5.66 KB
/
azure-mssql-server.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
# Copyright 2020 Pivotal Software, Inc.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
# http:#www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
---
version: 1
name: csb-azure-mssql-server
id: a0ab0f36-f8e1-4045-8ddb-1918d2ceafe4
description: Azure SQL Server (no database attached)
display_name: Azure SQL Server
image_url: file://service-images/csb.png
documentation_url: https://docs.microsoft.com/en-us/azure/sql-database/
support_url: https://docs.microsoft.com/en-us/azure/sql-database/
tags: [azure, preview]
plans:
- name: standard
id: 1aab10e2-ca79-4755-855a-6073a739d2e0
description: 'Stand alone SQL Server'
display_name: "Standard"
provision:
plan_inputs: []
user_inputs:
- field_name: instance_name
type: string
details: Name for your Azure SQL Server instance
default: csb-azsql-svr-${request.instance_id}
constraints:
maxLength: 63
minLength: 6
pattern: ^[a-z][a-z0-9-]+$
prohibit_update: true
- field_name: resource_group
type: string
details: Name for the resource group for this instance
default: ''
constraints:
maxLength: 64
minLength: 0
pattern: ^[a-z][a-z0-9-]+$|^$
prohibit_update: true
- field_name: admin_username
type: string
details: Name for the resource group for this instance
default: ''
constraints:
maxLength: 32
minLength: 0
pattern: ^[A-Za-z]+$|^$
- field_name: admin_password
type: string
details: Name for the resource group for this instance
default: ''
constraints:
maxLength: 64
minLength: 0
pattern: ^[A-Za-z0-9~_.-]+$|^$
- field_name: authorized_network
type: string
details: The subnet ID of the Azure VNET to which the instance is locked down to. If left unspecified,
default: default
- field_name: location
type: string
details: The location of the Azure SQL Database
default: westus
constraints:
examples:
- westus2
- uksouth
pattern: ^[a-z][a-z0-9]+$
prohibit_update: true
- field_name: azure_tenant_id
type: string
details: Azure Tenant to create resource in
default: ${config("azure.tenant_id")}
- field_name: azure_subscription_id
type: string
details: Azure Subscription to create resource in
default: ${config("azure.subscription_id")}
- field_name: azure_client_id
type: string
details: Client ID of Azure principal
default: ${config("azure.client_id")}
- field_name: azure_client_secret
type: string
details: Client secret for Azure principal
default: ${config("azure.client_secret")}
- field_name: skip_provider_registration
type: boolean
details: Skip automatic Azure provider registration, set to true if service principal being used does not have rights to register providers
default: false
template_refs:
data: terraform/azure-mssql-server/provision/data.tf
main: terraform/azure-mssql-server/provision/main.tf
moved: terraform/azure-mssql-server/provision/moved-azure-mssql-server.tf
outputs: terraform/azure-mssql-server/provision/outputs.tf
provider: terraform/azure-mssql-server/provision/provider.tf
variables: terraform/azure-mssql-server/provision/variables.tf
versions: terraform/azure-mssql-server/provision/versions.tf
computed_inputs:
- name: labels
default: ${json.marshal(request.default_labels)}
overwrite: true
type: object
outputs:
- field_name: sqldbResourceGroup
type: string
details: Azure resource group for the database server and database.
- field_name: sqlServerName
type: string
details: Hostname of the Azure SQL Server
- field_name: sqlServerFullyQualifiedDomainName
type: string
details: The fully qualified domain name (FQDN) of the Azure SQL Server
- field_name: databaseLogin
type: string
details: The username to authenticate to the database server.
- field_name: databaseLoginPassword
type: string
details: The password to authenticate to the database server.
- field_name: hostname
type: string
details: Hostname of the Azure SQL Server
- field_name: port
type: integer
details: The port number to connect to the database on
- field_name: username
type: string
details: The username to authenticate to the database server.
- field_name: password
type: string
details: The password to authenticate to the database server.
bind:
plan_inputs: []
user_inputs: []
computed_inputs: []
template_refs:
noop: terraform/azure-mssql-server/bind/noop.tf
outputs: []
examples:
- name: azuresql-db-server-standard
description: Create a standard Azure SQL Database Server
plan_id: 1aab10e2-ca79-4755-855a-6073a739d2e0
provision_params: {}
bind_params: {}
- name: azuresql-db-server-standard-rg
description: Create a standard Azure SQL Database Server with location centralus
plan_id: 1aab10e2-ca79-4755-855a-6073a739d2e0
provision_params: {"location": "centralus"}
bind_params: {}
- name: azuresql-db-server-standard-admin-username-password
description: Create a standard Azure SQL Database Server with instance name, admin username and admin password
plan_id: 1aab10e2-ca79-4755-855a-6073a739d2e0
provision_params: {"admin_username": "anadmin", "admin_password": "SomeComp-l1cat3d_Passw0rd"}
bind_params: {}