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

my $instance_uuid = $var{'instance_uuid'};
my $reason = $var{'reason'};
my $status = $var{'status'};
my $vps = $var{'vps'};
my $disk = $var{'disk'};
my $data = {};

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

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 $query = "";

if ($status =~ /STARTED/){
    $query = "INSERT INTO liberty (`instance_uuid`, `backup_start_time`, `backup_end_time`, `status`, `vps_id`, `disk_size`) VALUES ( ?, NOW(), NULL, 'STARTED', (SELECT id FROM vps WHERE hostname = ?), NULL) ON DUPLICATE KEY UPDATE backup_start_time = NOW(), backup_end_time = NULL, status = 'STARTED', vps_id = (SELECT id FROM vps WHERE hostname = ?)";
} elsif ($status =~ /RUNNING/) {
    $query = "UPDATE liberty SET status = 'RUNNING', disk_size = ? WHERE instance_uuid = ?";
} elsif ($status =~ /COMPLETED/){
    $query = "UPDATE liberty SET status = 'COMPLETED', backup_end_time = NOW(), failure_count = 0 WHERE instance_uuid = ?";
} elsif ($status =~ /SHUTOFF/) {
    my $p_query = "SELECT IF(last_failure_reason = 'vm_shutoff', failure_count + 1, 1) FROM liberty WHERE instance_uuid = ?";
    my $p_sth = $dbh->prepare($p_query) or die("Error:".$dbh->errstr."\n");
    $p_sth->execute($instance_uuid);
    my $failure_count = 1;
    if($p_sth->rows() > 0){
      my @p_res = $p_sth->fetchrow_array();
      $failure_count = $p_res[0];
    }
    $query = "UPDATE liberty SET failure_count = $failure_count,  status = 'SHUTOFF', last_failure_time = NOW(), backup_end_time = NOW(), last_failure_reason = 'vm_shutoff' WHERE instance_uuid = ?";
    $p_sth->finish;
} elsif ($status =~ /FAILED/){
    my $p_query = "SELECT IF(last_failure_reason <> 'vm_shutoff', failure_count + 1, 1) FROM liberty WHERE instance_uuid = ?";
    my $p_sth = $dbh->prepare($p_query) or die("Error:".$dbh->errstr."\n");
    $p_sth->execute($instance_uuid);
    my $failure_count = 1;
    if($p_sth->rows() > 0){
      my @p_res = $p_sth->fetchrow_array();
      $failure_count = $p_res[0];
    }
    $query = "UPDATE liberty SET failure_count = $failure_count, status = 'FAILED', last_failure_time = NOW(), backup_end_time = NOW(), last_failure_reason = ? WHERE instance_uuid = ?";
    $p_sth->finish;
#} elsif ($status =~ /FAILED/){
#    $query = "UPDATE liberty SET failure_count = failure_count + 1, status = 'FAILED', last_failure_time = NOW(), backup_end_time = NOW(), last_failure_reason = ? WHERE instance_uuid = ?";
}

my $sth = $dbh->prepare($query) or die("Error:".$dbh->errstr."\n");
switch($status) {
    case 'STARTED' { $sth->execute($instance_uuid, $vps, $vps) }
    case 'RUNNING' { $sth->execute($disk, $instance_uuid) }
    case 'COMPLETED' { $sth->execute($instance_uuid) }
    case 'SHUTOFF' { $sth->execute($instance_uuid) }
    case 'FAILED' { $sth->execute($reason, $instance_uuid) }
}
$sth->finish;
