#!/usr/bin/perl
use strict;
use DBI;
use CGI;
use YAML 'LoadFile';
use JSON 'encode_json';
use Data::Dumper;

my $cgi = new CGI;
print $cgi->header();
my %var = $cgi->Vars;

validate(qw(hostname));
my $config_settings = LoadFile("/var/www/conf/backup_master_config.yaml") || die "Failed to load config: $!\n";
my $dbh = DBI->connect("DBI:mysql:database=".$config_settings->{backup_db}.";host=localhost",$config_settings->{backup_user}, $config_settings->{backup_pass}) or die("couldnt connect to db $!");
my $backup_server = get_server($var{'hostname'});
my @trustedips = qw(74.220.198.194 127.0.0.1 74.220.198.27 74.220.198.28 74.220.198.29 162.144.11.10 50.6.6.12);
push (@trustedips, $backup_server->{'ip'});
exit unless  grep(/^$ENV{REMOTE_ADDR}$/, @trustedips);
get_all();

sub get_all {
    my $query = q(
            SELECT cbox.hostname,cbox.dc,INET_NTOA(newbacknetip.backnetip) AS "compute_ip",compute.hostname AS "compute_hostname",
            dr.nproc,dr.ram,dr.vlan,dr.distro,
            driscsi.initiator_name
            FROM server as cbox
            JOIN iscsimounts ON iscsimounts.cboxid = cbox.serverid
            JOIN drserver as dr ON dr.serverid = cbox.serverid
            JOIN server AS compute ON dr.computeid = compute.serverid
            JOIN newbacknetip ON compute.serverid = newbacknetip.serverid
            LEFT JOIN driscsi ON dr.computeid = driscsi.computeid
            WHERE iscsimounts.bboxid = ?
            );
    my $sth = $dbh->prepare($query);
    $sth->execute($backup_server->{'serverid'}) or die $sth->errstr;
    my $dr_clients = $sth->fetchall_hashref('hostname');
    print encode_json($dr_clients);
    exit;
}

sub get_server {
    my $server_hostname = shift;
    my $query = q(
            SELECT *,INET_NTOA(newbacknetip.backnetip) AS "ip" FROM server
            JOIN newbacknetip ON server.serverid = newbacknetip.serverid
            WHERE hostname = ?
            LIMIT 1
            );
    my $sth = $dbh->prepare($query);
    $sth->execute($server_hostname) or die $sth->errstr;
    my $res = $sth->fetchrow_hashref();
    exit unless defined $res->{'serverid'};
    return $res;
}
sub validate{
    my @required = @_;
    foreach my $required (@required){
        exit unless(defined($var{$required}));
        exit unless($var{$required} =~ m/^[a-z0-9-\.]+$/);
    }
}
