#!/bin/bash

elementIn () {
    local i match="$1";
    shift;
    for i; do [[ "$i" == "$match" ]] && return 0; done;
    return 1;
}

confirm () {
    while read -p "$1 [y/n]: "; do
        case $REPLY in
            [Yy]) return 0 ;;
            [Nn]) return 1 ;;
        esac;
    done;
}

list () {
    local i title="$1";
    shift
    echo "$title:"
    for i; do echo "$i"; done;
    return 1;
}

read -e -p "Enter hostname (i.e., box3094.bluehost.com) : " HOSTNAME; echo;

OLD_IFS="$IFS";
IFS=$'\n';
KNOWN_BRANDS=($(mysql backups -B -N -e 'select distinct(brand) from server where brand is not null;'));
KNOWN_DATACENTERS=($(mysql backups -B -N -e 'select distinct(dc) from server where dc is not null;'));
IFS="$OLD_IFS";

HOST=$(echo $HOSTNAME | cut -d. -f1);
IP=$(dig A $HOSTNAME +short);

if [ -z "$IP" ];
    then
        echo "IP for $HOSTNAME not found using dig!"; echo;
        read -e -p "What is the public IP for $HOSTNAME? (i.e., 50.116.71.161) " IP; echo;
fi;

list "Known Brands" "${KNOWN_BRANDS[@]}";
read -e -p "What is the brand for $HOSTNAME? " BRAND; echo;
elementIn "$BRAND" "${KNOWN_BRANDS[@]}" || { echo -e "$BRAND is not a known brand.\n" && confirm "Would you like to forcefully assign '$HOSTNAME' to the database with '$BRAND' as a new brand?"; } || { echo -e "\nDoing nothing...\n" && exit 1; }; echo

list "Known Datacenters" "${KNOWN_DATACENTERS[@]}";
read -e -p "What is the datacenter for $HOSTNAME? " DATACENTER; echo;
elementIn "$DATACENTER" "${KNOWN_DATACENTERS[@]}" || { echo -e "$DATACENTER is not a known datacenter.\n" && confirm "Would you like to forcefully assign '$HOSTNAME' to the database with '$DATACENTER' as a new datacenter?"; } || { echo -e "\nDoing nothing...\n" && exit 1; }; echo

echo "Hostname = '$HOSTNAME'";
echo "IP = '$IP'";
echo "Brand = '$BRAND'";
echo "Datacenter = '$DATACENTER'";
echo;
read -e -p "Is this information correct? [y/n] " ANS; echo;

if [ "$ANS" = "y" ];
    then
        mysql -D backups -e "insert into server(hostname,host,brand,dc) values('$HOSTNAME','$HOST','$BRAND','$DATACENTER');";
        SERVERID=$(mysql -D backups -e "select serverid from server where hostname='$HOSTNAME';" | grep ^[0-9]);
        mysql -D backups -e "insert into newbacknetip(serverid,backnetip) values('$SERVERID',INET_ATON('$IP'));";
        echo "Allowing $HOSTNAME in ipset";
        /var/www/bin/update_backup_client_allow
        echo "Successfully added $HOSTNAME with the IP of $IP to the backups database;"; echo;
        echo "Run \`/var/www/bin/addbackup.mass\` to update the backup server for $HOSTNAME"; echo;
    else
        echo "Doing nothing.."; echo;
fi;

