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

my $cgi = new CGI;
print $cgi->header();
my %var = $cgi->Vars;
exit unless(defined($var{hostname}));
exit unless($var{hostname} =~ m/^(\w+)$|^(\w+\.|)([\w\-]+)\.(\w+)\.(\w+)$/);
exit unless($var{type} =~ m/^(backupserver|mounts)$/);

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 $hostname = $var{hostname};

if($var{type} eq "backupserver"){
  my $query = "select distinct bhostname from iscsiview where chostname like ?";
  my $sth = $dbh->prepare($query);
  $sth->execute("$hostname\%") or warn $sth->errstr;
  my @hosts;
  while(my $ref = $sth->fetchrow_hashref()){
    push(@hosts, $ref->{bhostname});
  }
  print join(",",@hosts)."\n";
}

if($var{type} eq "mounts"){
  my $query = "select plabel,cmount from iscsiview where chostname like ?";
  my $sth = $dbh->prepare($query);
  $sth->execute("$hostname\%") or warn $sth->errstr;
  my $ref = $sth->fetchall_hashref('cmount');
  print encode_json($ref);
}

