#!/usr/bin/perl
use strict;
use DBI;
use CGI;
use JSON;
use Data::Dumper;
use YAML qw( LoadFile );
my $cgi = new CGI;
print $cgi->header('text/plain');
my %var = $cgi->Vars;
$Data::Dumper::Sortkeys = 1;

my $config = LoadFile("/var/www/conf/vpsbackup_master_config.yaml") || die "Failed to load config: $!\n";

my $remote_ip = $ENV{REMOTE_ADDR};
my $validated = 0;
if($ENV{REMOTE_ADDR} eq '127.0.0.1' || $ENV{REMOTE_ADDR} eq '74.220.198.194' || -t STDOUT ){
  $validated = 1;
}else{
  foreach my $regex ( @{ $config->{"hal_ips"} } ) {
          $validated = 1 if ( $ENV{REMOTE_ADDR} =~ m/^$regex/ );
  }
}
if ( !$validated ){
  print "go away\n";
  exit;
}

if(! defined($var{data})){
  print "you must pass me json data\n";
  exit;
}

my $hd = decode_json($var{data});
#print Dumper($hd->{vps});

my $dbh = DBI->connect("DBI:mysql:database=".$config->{vps_backup_db}.";host=localhost",$config->{vps_backup_user}, $config->{vps_backup_pass}) or die("couldnt connect to db $!");
my $sanqueryhandle = $dbh->prepare('SELECT id,hostname,inet_ntoa(ip) as ip,hal_id FROM san WHERE hostname = ?');
my $saninserthandle = $dbh->prepare('INSERT INTO san (hostname,ip,hal_id) VALUES (?,inet_aton(?),?)');
my $vpsqueryhandle = $dbh->prepare('SELECT id,hostname,inet_ntoa(privateip) as ip,hal_id FROM vps WHERE hostname = ?');
my $vpsinserthandle = $dbh->prepare('INSERT INTO vps (hostname,privateip,hal_id,type) VALUES (?,inet_aton(?),?,"block")');
my $instancequeryhandle = $dbh->prepare('SELECT id,vps_id,uuid,brand,inet_ntoa(primary_ip) as primary_ip,hal_id,hal_status,last_hal_push FROM instance WHERE uuid = ?');
my $instanceupdatehandle = $dbh->prepare('UPDATE instance SET last_hal_push = NOW() WHERE uuid = ?');
my $instanceinserthandle = $dbh->prepare('INSERT INTO instance (vps_id,uuid,brand,hal_id,hal_status,primary_ip,last_hal_push) VALUES (?,?,?,?,?,inet_aton(?),NOW())');

my $volumequeryhandle = $dbh->prepare('SELECT id,instance_id,san_id,disk_size,last_hal_push,hal_id,hal_san_id,hal_instance_id FROM volume WHERE hal_id = ?');
my $volumeupdatehandle = $dbh->prepare('UPDATE volume SET last_hal_push = NOW() WHERE hal_id = ?');
my $volumeinserthandle = $dbh->prepare('INSERT INTO volume (instance_id,san_id,disk_size,hal_id,hal_san_id,hal_instance_id,last_hal_push) VALUES (?,?,?,?,?,?,NOW())');

my $localdata = {};
my $lookup = {};
#handle san objects first
foreach my $san (@{$hd->{san}}){
  my $r = sansync($san);
  $localdata->{san}->{$r->{id}} = $r->{obj};
  
  $lookup->{san}->{bylid}->{$r->{id}} = $san->{id};
  $lookup->{san}->{byhal}->{$san->{id}} = $r->{id};
}
#VPS objects
foreach my $vps (@{$hd->{vps}}){
  my $r = vpssync($vps);
  $localdata->{vps}->{$r->{id}} = $r->{obj};
  
  $lookup->{vps}->{bylid}->{$r->{id}} = $vps->{id};
  $lookup->{vps}->{byhostname}->{$vps->{hostname}} = $r->{id};
  $lookup->{vps}->{byhal}->{$vps->{id}} = $r->{id};
}
#INSTANCE objects
foreach my $instance (@{$hd->{instance}}){
  my $r = instancesync($instance, $lookup->{vps}->{byhostname}->{$instance->{box_hostname}});

  $localdata->{instance}->{$r->{id}} = $r->{obj};
  
  $lookup->{instance}->{bylid}->{$r->{id}} = $instance->{id};
  $lookup->{instance}->{byhal}->{$instance->{id}} = $r->{id};
}
#volumes
foreach my $volume (@{$hd->{volume}}){
  my $r = volumesync($volume, $lookup->{instance}->{byhal}->{$volume->{server_id}}, $lookup->{san}->{byhal}->{$volume->{san_id}});

  $localdata->{volume}->{$r->{id}} = $r->{obj};
  
  $lookup->{volume}->{bylid}->{$r->{id}} = $volume->{id};
  $lookup->{volume}->{byhal}->{$volume->{id}} = $r->{id};
  $localdata->{instance}->{$r->{obj}->{instance_id}}->{disk_size} += $volume->{disk_size};
}

#delete old cruft that hasn't been updated in a while

exit;


sub volumesync {
  my $halvolumeobj = shift;
  my $instanceid = shift;
  my $sanid = shift;
  $volumequeryhandle->execute($halvolumeobj->{id}) || die("Error:".$volumequeryhandle->errstr."\n");

  #we found nothing
  if($volumequeryhandle->rows() == 0){
    print "do volume insert really quick ".$halvolumeobj->{id}."\n";
    warn "do volume insert really quick ".$halvolumeobj->{id}."\n";
    #do a quick insert of the data we got
    $volumequeryhandle->finish();
    $volumeinserthandle->execute(   $instanceid,
                                    $sanid,
                                    $halvolumeobj->{disk_size},
                                    $halvolumeobj->{id},
                                    $halvolumeobj->{san_id},
                                    $halvolumeobj->{server_id},
                                   )|| die("Error:".$volumeinserthandle->errstr."\n");
    $volumeinserthandle->finish();
    #do another query really quick
    $volumequeryhandle->execute($halvolumeobj->{id}) || die("Error:".$volumequeryhandle->errstr."\n");
    if($volumequeryhandle->rows() == 0){
      print "our insert on volume failed and we don't know why\n";
      warn "our insert on volume failed and we don't know why\n";
      exit;
    }
  }else{
    #we didn't do an insert so we should update that we have seen this volume recently
    $volumeupdatehandle->execute($halvolumeobj->{id}) || die("Error:".$volumeupdatehandle->errstr."\n");
    $volumeupdatehandle->finish();
  }

  my $ref = $volumequeryhandle->fetchrow_hashref();
  $volumequeryhandle->finish();

  return( { id => $ref->{id}, obj => $ref });
}



sub instancesync {
  my $halinstanceobj = shift;
  my $vpsid = shift;
  $instancequeryhandle->execute($halinstanceobj->{instance_id}) || die("Error:".$instancequeryhandle->errstr."\n");

  #we found nothing
  if($instancequeryhandle->rows() == 0){
    print "do instance insert really quick ".$halinstanceobj->{instance_id}."\n";
    warn "do instance insert really quick ".$halinstanceobj->{instance_id}."\n";
    #do a quick insert of the data we got
    $instancequeryhandle->finish();
    $instanceinserthandle->execute( $vpsid,
                                    $halinstanceobj->{instance_id},
                                    $halinstanceobj->{brand},
                                    $halinstanceobj->{id},
                                    $halinstanceobj->{status},
                                    $halinstanceobj->{primary_ip}
                                   )|| die("Error:".$instanceinserthandle->errstr."\n");
    $instanceinserthandle->finish();
    #do another query really quick
    $instancequeryhandle->execute($halinstanceobj->{instance_id}) || die("Error:".$instancequeryhandle->errstr."\n");
    if($instancequeryhandle->rows() == 0){
      print "our insert on instance failed and we don't know why\n";
      warn "our insert on instance failed and we don't know why\n";
      exit;
    }
  }else{
    #we didn't do an insert so we should update that we have seen this instance recently
#print "updating instance ".$halinstanceobj->{instance_id}."\n";
    $instanceupdatehandle->execute($halinstanceobj->{instance_id}) || die("Error:".$instanceupdatehandle->errstr."\n");
    $instanceupdatehandle->finish();
  }

  my $ref = $instancequeryhandle->fetchrow_hashref();
  $instancequeryhandle->finish();

  return( { id => $ref->{id}, obj => $ref });
}



sub vpssync {
  my $halvpsobj = shift;
  $vpsqueryhandle->execute($halvpsobj->{hostname}) || die("Error:".$vpsqueryhandle->errstr."\n");

  #we found nothing
  if($vpsqueryhandle->rows() == 0){
    print "do vps insert really quick ".$halvpsobj->{hostname}."\n";
    warn "do vps insert really quick ".$halvpsobj->{hostname}."\n";
    #do a quick insert of the data we got
    $vpsqueryhandle->finish();
    $vpsinserthandle->execute($halvpsobj->{hostname},$halvpsobj->{ip},$halvpsobj->{id})|| die("Error:".$vpsinserthandle->errstr."\n");
    $vpsinserthandle->finish();
    #do another query really quick
    $vpsqueryhandle->execute($halvpsobj->{hostname}) || die("Error:".$vpsqueryhandle->errstr."\n");
    if($vpsqueryhandle->rows() == 0){
      print "our insert on vps failed and we don't know why\n";
      warn "our insert on vps failed and we don't know why\n";
      exit;
    }
  }

  my $ref = $vpsqueryhandle->fetchrow_hashref();
  $vpsqueryhandle->finish();
  return( { id => $ref->{id}, obj => $ref });
}



sub sansync {
  my $halsanobj = shift;
  $sanqueryhandle->execute($halsanobj->{hostname}) || die("Error:".$sanqueryhandle->errstr."\n");

  #we found nothing
  if($sanqueryhandle->rows() == 0){
    print "do san insert really quick".$halsanobj->{hostname}."\n";
    warn "do san insert really quick".$halsanobj->{hostname}."\n";
    #do a quick insert of the data we got
    $sanqueryhandle->finish();
    $saninserthandle->execute($halsanobj->{hostname},$halsanobj->{ip},$halsanobj->{id})|| die("Error:".$saninserthandle->errstr."\n");
    $saninserthandle->finish();
    #do another query really quick
    $sanqueryhandle->execute($halsanobj->{hostname}) || die("Error:".$sanqueryhandle->errstr."\n");
    if($sanqueryhandle->rows() == 0){
      print "our insert on san failed and we don't know why\n";
      warn "our insert on san failed and we don't know why\n";
      exit;
    }
  }

  my $ref = $sanqueryhandle->fetchrow_hashref();
  $sanqueryhandle->finish();
  return( { id => $ref->{id}, obj => $ref });
}


