Recipe for Google Deployment Manager

setup-sql.py

import uuid


def GenerateConfig(context):
    """Generate YAML resource configuration."""

    sql_zone = context.properties["SQL_ZONE"]
    sql_name = str(uuid.uuid4().hex)
    db_name = context.properties["DB_NAME"]
    user_name = context.properties["USER_NAME"]
    user_password = context.properties["USER_PASSWORD"]

    resources = []
    resources.append(
        {
            "name": sql_name,
            "type": "sqladmin.v1beta4.instance",
            "properties": {
                "databaseVersion": "POSTGRES_11",
                "settings": {
                    "tier": "db-f1-micro",
                    "locationPreference": {"zone": sql_zone},
                    "ipConfiguration": {
                        "privateNetwork": "https://www.googleapis.com/compute/v1/projects/my-project-dev/global/networks/default"
                    },
                },
            },
        }
    )
    resources.append(
        {
            "name": db_name,
            "type": "sqladmin.v1beta4.database",
            "properties": {"instance": "$(ref." + sql_name + ".name)", "charset": "UTF8"},
        }
    )

    resources.append(
        {
            "name": user_name,
            "type": "sqladmin.v1beta4.user",
            "properties": {"instance": "$(ref." + sql_name + ".name)", "password": user_password, "host":"$(ref." + db_name + ".name)" },
        }
    )
    

    outputs = []
    outputs.append({"name": "ipAddresses", "value": "$(ref." + sql_name + ".ipAddresses[0].ipAddress)"})
    outputs.append({"name": "name", "value": sql_name})
    return {"resources": resources, "outputs": outputs}