Bull 2864

https://jira.il2.dso.mil/browse/BULL-2864

Description

Given the data available from prometheus, which is currently:

https://launchboard.staging.dso.mil/api/status/http/mission-app/[mission-app-name] https://launchboard.staging.dso.mil/api/status/http/dsop design and implement the necessary database schema changes to support supplying the necessary data to the FE via API.

This should also include updating https://repo1.dso.mil/platform-one/party-bus/launchboard/launchboard-be/-/blob/master/src/commands/fetch-status.js to populate the LB database.

Acceptance Criteria

• Launchboard DB is populated with status data.

Helpful Stuff For Testers

Prerequisites:

• You must be in these Keycloak groups
  • /Party Bus Limited Access/Dev (CAC Required)/MDO-roles/admin-routes
  • /Party Bus Limited Access/IL4/DSOP-roles/admin-routes
• Ask @jaredshue or @graham.smith for the HTTPS certificates required to perform the TLS handshake w/ the prometheus instances
• You must be connected to Appgate in order to communicate w/ the prometheus instances

Create a config file for testing:

cat <<EOF > ~/Downloads/prometheus.json
{
  "instances": [
    {
      "baseUrl": "https://prometheus-preprod.admin.dso.mil",
      "apps": [
        {
          "id": "gitlab",
          "namespace": "gitlab",
          "name": "Gitlab",
          "url": "https://localhost"
        },
        {
          "id": "mattermost",
          "namespace": "mattermost",
          "name": "Mattermost",
          "url": "https://localhost"
        },
        {
          "id": "jira",
          "namespace": "jira",
          "name": "Jira",
          "url": "https://localhost"
        },
        {
          "id": "confluence",
          "namespace": "confluence",
          "name": "Confluence",
          "url": "https://localhost"
        }
      ],
      "https": {
        "rejectUnauthorized": false,
        "caPath":"$HOME/Downloads/launchboard-prometheus-certs/prometheus-preprod.admin.dso.mil/ca-chain.crt",
        "certPath":"$HOME/Downloads/launchboard-prometheus-certs/prometheus-preprod.admin.dso.mil/lb.crt",
        "keyPath":"$HOME/Downloads/launchboard-prometheus-certs/prometheus-preprod.admin.dso.mil/lb.key"
      }
    },
    {
      "baseUrl": "https://prometheus-mdo-test-il2.admin.dso.mil",
      "apps": [
        {
          "id": "kubecost",
          "namespace": "kubecost",
          "name": "Kubecost",
          "url": "https://localhost"
        },
        {
          "id": "minio",
          "namespace": "minio",
          "name": "Minio",
          "url": "https://localhost"
        }
      ],
      "https": {
        "rejectUnauthorized": false,
        "caPath":"$HOME/Downloads/launchboard-prometheus-certs/prometheus-mdo-test-il2.admin.dso.mil/ca-chain.crt",
        "certPath":"$HOME/Downloads/launchboard-prometheus-certs/prometheus-mdo-test-il2.admin.dso.mil/lb.crt",
        "keyPath":"$HOME/Downloads/launchboard-prometheus-certs/prometheus-mdo-test-il2.admin.dso.mil/lb.key"
      }
    }
  ]
}
EOF

Set required environment variables:

export MYSQL_DB_NAME=launchboard
export MYSQL_DB_ADMIN_USER=lb
export MYSQL_DB_ADMIN_PASSWORD=lb
export MYSQL_HOST=localhost
export MYSQL_PORT=4306

Run the command:

npx babel-node ./src/infrastructure/commands/create-dsop-app-status-updates.js $HOME/Downloads/prometheus.json