az-do-rp_update-db.json

{
  "source": "undefined",
  "revision": 1,
  "description": null,
  "isDeleted": false,
  "variables": {
    "DB_HOST": {
      "value": "your-database.mysql.database.azure.com"
    },
    "DB_NAME": {
      "value": "wp_SITEID"
    },
    "DB_USER": {
      "value": "wp_SITEID@your-database"
    }
  },
  "variableGroups": [],
  "environments": [
    {
      "name": "Stage 1",
      "variables": {},
      "variableGroups": [],
      "preDeployApprovals": {
        "approvals": [
          {
            "rank": 1,
            "isAutomated": true,
            "isNotificationOn": false,
            "id": 40
          }
        ],
        "approvalOptions": {
          "requiredApproverCount": null,
          "releaseCreatorCanBeApprover": false,
          "autoTriggeredAndPreviousEnvironmentApprovedCanBeSkipped": false,
          "enforceIdentityRevalidation": false,
          "timeoutInMinutes": 0,
          "executionOrder": 1
        }
      },
      "postDeployApprovals": {
        "approvals": [
          {
            "rank": 1,
            "isAutomated": true,
            "isNotificationOn": false,
            "id": 42
          }
        ],
        "approvalOptions": {
          "requiredApproverCount": null,
          "releaseCreatorCanBeApprover": false,
          "autoTriggeredAndPreviousEnvironmentApprovedCanBeSkipped": false,
          "enforceIdentityRevalidation": false,
          "timeoutInMinutes": 0,
          "executionOrder": 2
        }
      },
      "deployPhases": [
        {
          "deploymentInput": {
            "parallelExecution": {
              "parallelExecutionType": "none"
            },
            "agentSpecification": {
              "identifier": "ubuntu-20.04"
            },
            "skipArtifactsDownload": false,
            "artifactsDownloadInput": {},
            "demands": [],
            "enableAccessToken": false,
            "timeoutInMinutes": 0,
            "jobCancelTimeoutInMinutes": 1,
            "condition": "succeeded()",
            "overrideInputs": {}
          },
          "rank": 1,
          "phaseType": "agentBasedDeployment",
          "name": "Agent job",
          "workflowTasks": [
            {
              "environment": {},
              "taskId": "1e244d32-2dd4-4165-96fb-b7441ca9331e",
              "version": "1.*",
              "name": "Azure Key Vault: wordpress-cloud-keyvault",
              "refName": "",
              "enabled": true,
              "alwaysRun": false,
              "continueOnError": false,
              "timeoutInMinutes": 0,
              "definitionType": "task",
              "overrideInputs": {},
              "condition": "succeeded()",
              "inputs": {
                "ConnectedServiceName": "REPLACEME_WITH_CORRECT_ID",
                "KeyVaultName": "wordpress-cloud-keyvault",
                "SecretsFilter": "*",
                "RunAsPreJob": "false"
              }
            },
            {
              "environment": {},
              "taskId": "6c731c3c-3c68-459a-a5c9-bde6e6595b5b",
              "version": "3.*",
              "name": "Validate Input",
              "refName": "",
              "enabled": true,
              "alwaysRun": false,
              "continueOnError": false,
              "timeoutInMinutes": 0,
              "definitionType": "task",
              "overrideInputs": {},
              "condition": "succeeded()",
              "inputs": {
                "targetType": "inline",
                "filePath": "",
                "arguments": "",
                "script": "echo \"fetching secrets from keyvault...\"\nenv | grep \"wp-SITEID-db-password\"\nDB_PASSWORD=$(wp-SITEID-db-password)\n\necho \"Validate input...\";\n\nif [[ -z \"$DB_HOST\" || -z \"$DB_NAME\" || -z \"$DB_USER\" || -z \"$DB_PASSWORD\" ]]; then\n   echo \"Missing Input-Variable! You need to specify all required values!\";\n   exit 1;\nfi\n",
                "workingDirectory": "",
                "failOnStderr": "false",
                "noProfile": "true",
                "noRc": "true"
              }
            },
            {
              "environment": {},
              "taskId": "e28912f1-0114-4464-802a-a3a35437fd16",
              "version": "1.*",
              "name": "Run an image",
              "refName": "",
              "enabled": true,
              "alwaysRun": false,
              "continueOnError": false,
              "timeoutInMinutes": 0,
              "definitionType": "task",
              "overrideInputs": {},
              "condition": "succeeded()",
              "inputs": {
                "containerregistrytype": "Azure Container Registry",
                "dockerRegistryEndpoint": "",
                "azureSubscriptionEndpoint": "REPLACEME_WITH_CORRECT_ID",
                "azureContainerRegistry": "REPLACEME_WITH_CORRECT_NAME.azurecr.io",
                "command": "Run an image",
                "dockerFile": "**/Dockerfile",
                "arguments": "",
                "pushMultipleImages": "false",
                "tagMultipleImages": "false",
                "imageName": "wp-SITEID-init:latest",
                "imageNamesPath": "",
                "qualifyImageName": "true",
                "qualifySourceImageName": "false",
                "includeSourceTags": "false",
                "includeLatestTag": "false",
                "addDefaultLabels": "true",
                "useDefaultContext": "true",
                "buildContext": "**",
                "imageDigestFile": "",
                "containerName": "",
                "ports": "",
                "volumes": "",
                "envVars": "DB_HOST=$(DB_HOST)\nDB_NAME=$(DB_NAME)\nDB_USER=$(DB_USER)\nDB_PASSWORD=$(wp-SITEID-db-password)",
                "workingDirectory": "",
                "entrypointOverride": "",
                "containerCommand": "",
                "runInBackground": "false",
                "restartPolicy": "no",
                "maxRestartRetries": "",
                "dockerHostEndpoint": "",
                "enforceDockerNamingConvention": "true",
                "memoryLimit": ""
              }
            }
          ]
        }
      ],
      "environmentOptions": {
        "emailNotificationType": "OnlyOnFailure",
        "emailRecipients": "release.environment.owner;release.creator",
        "skipArtifactsDownload": false,
        "timeoutInMinutes": 0,
        "enableAccessToken": false,
        "publishDeploymentStatus": false,
        "badgeEnabled": false,
        "autoLinkWorkItems": false,
        "pullRequestDeploymentEnabled": false
      },
      "demands": [],
      "conditions": [
        {
          "name": "ReleaseStarted",
          "conditionType": 1,
          "value": ""
        }
      ],
      "executionPolicy": {
        "concurrencyCount": 0,
        "queueDepthCount": 0
      },
      "schedules": [],
      "retentionPolicy": {
        "daysToKeep": 30,
        "releasesToKeep": 3,
        "retainBuild": true
      },
      "properties": {},
      "preDeploymentGates": {
        "id": 0,
        "gatesOptions": null,
        "gates": []
      },
      "postDeploymentGates": {
        "id": 0,
        "gatesOptions": null,
        "gates": []
      },
      "environmentTriggers": []
    }
  ],
  "artifacts": [],
  "triggers": [],
  "releaseNameFormat": "Release-$(rev:r)",
  "tags": [],
  "properties": {},
  "name": "Update Wordpress DB (SITENAME)",
  "path": "\\wordpress-cloud",
  "projectReference": null,
  "_links": {}
}