google/resource-snippets/sqladmin-v1beta4/cloudsql_with_user.jinja

# Copyright 2018 Google Inc. All rights reserved.
#
# 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.

{% set instanceName = env['deployment'] + '-instance' %}
# DB cannot have things like dashes, so must be simple. It is unique to the
# instance so is fine in this form.
{% set dbName = 'mydb' %}
{% set userName = 'testuser' %}

resources:
- name: {{ instanceName }}
#  type: sqladmin.v1beta4.instance
  type: gcp-types/sqladmin-v1beta4:instances
  properties:
    settings:
      tier: {{ properties['tier'] }}
- name: {{ dbName }}
#  type: sqladmin.v1beta4.database
  type: gcp-types/sqladmin-v1beta4:databases
  properties:
    name: {{ dbName }}
    instance: $(ref.{{ instanceName }}.name)
    charset: {{ properties['charset'] }}
- name: {{ userName }}
#  type: sqladmin.v1beta4.user
  type: gcp-types/sqladmin-v1beta4:users
  metadata:
    dependsOn:
      - {{ dbName }}
  properties:
    name: {{ userName }}
    instance: $(ref.{{ instanceName }}.name)
    host: {{ properties['hostName'] }}
    password: {{ properties['password'] }}