#!/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 gcp_server_bucket.id as id,gcp_server_bucket.is_prod as is_prod,
            ro_service_account_email as service_account, bucket_name,
            cbox.hostname as hostname, cbox.dc,
            project.gcp_project_name as project_name
            from server as cbox
            JOIN gcp_server_bucket ON cbox.serverid = gcp_server_bucket.serverid
            JOIN iscsimounts ON iscsimounts.cboxid = cbox.serverid
            LEFT JOIN gcp_obj_project AS project ON gcp_server_bucket.gcp_obj_project_id = project.id
            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-\.]+$/);
    }
}
