incidents.sh

#!/usr/bin/env bash

# Define input CSV files
INCIDENTS_FILE="incidents.csv"
PAST_INCIDENTS_FILE="past_incidents.csv"
LAST_UPDATED=$(date +"%Y-%m-%dT%H:%M:%S%z")

command_exists(){
    if ! command -v "${1}" >/dev/null 2>&1; then
        echo >&2 "Error: ${1} missing. Please install it"
        exit 1
    fi
}

trim_spaces() {
  echo "$1" | sed 's/^[ \t]*//;s/[ \t]*$//'
}

# Initialize JSON structure
json_output=$(cat <<EOF
{
  "last_updated": "$LAST_UPDATED",
  "current_incidents": [],
  "past_incidents": []
}
EOF
)

convert_csv_to_json() {
  local csv_file=$1
  local json_array_name=$2
  local json_objects=""

  while IFS=',' read -r name impact reported restored; do
    # Skip the line if any field is empty
    if [ -z "$name" ] || [ -z "$impact" ] || [ -z "$reported" ] || [ -z "$restored" ]; then
      continue
    fi

    # Trim spaces
    name=$(trim_spaces "$name")
    impact=$(trim_spaces "$impact")
    reported=$(trim_spaces "$reported")
    restored=$(trim_spaces "$restored" | tr -d '\r')

    # Create JSON object for each row
    json_object=$(cat <<EOF
    {
      "name": "$name",
      "impact": "$impact",
      "reported": "$reported",
      "restored": "$restored",
    }
EOF
)
    if [ -z "$json_objects" ]; then
      json_objects="$json_object"
    else
      json_objects="$json_objects, $json_object"
    fi
  done < <(tail -n +1 "$csv_file")

  # Add JSON objects to the main JSON structure
  if [ -n "$json_objects" ]; then
    json_output=$(echo "$json_output" | jq ".${json_array_name} = [$json_objects]")
  fi
}

load_current_incidents() {
  local json_objects=""

  while IFS=',' read -r name impact reported; do
    # Skip the line if any field is empty
    if [ -z "$name" ] || [ -z "$impact" ] || [ -z "$reported" ]; then
      continue
    fi

    # Trim spaces
    name=$(trim_spaces "$name")
    impact=$(trim_spaces "$impact")
    reported=$(trim_spaces "$reported" | tr -d '\r')

    # Create JSON object for each row
    json_object=$(cat <<EOF
    {
      "name": "$name",
      "impact": "$impact",
      "reported": "$reported",
      "status": "FAILURE",
    }
EOF
)
    if [ -z "$json_objects" ]; then
      json_objects="$json_object"
    else
      json_objects="$json_objects, $json_object"
    fi
  done < <(tail -n +1 "$INCIDENTS_FILE")

  # Add JSON objects to the main JSON structure
  if [ -n "$json_objects" ]; then
    json_output=$(echo "$json_output" | jq ".current_incidents = [$json_objects]")
  fi
}

command_exists 'jq'

# Process the CSV files
load_current_incidents
convert_csv_to_json "$PAST_INCIDENTS_FILE" "past_incidents"

# Output the final JSON structure
echo "$json_output"