#!/usr/bin/env perl

use DBI;
use YAML qw( LoadFile );
my $ipset = 'backup_client_allow';

system("/usr/sbin/ipset", "-exist", "create", $ipset, "hash:ip", "hashsize", "4096") == 0 or die "Failed to setup ipset $ipset: $!\n";

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 $!");

foreach my $query ( 'select INET_NTOA(backnetip) as ip from newbacknetip', 'select ip from serverip', 'select ip from newserverip'){
  my $sth = $dbh->prepare($query);
  $sth->execute or warn $sth->errstr;
  while(my $ref = $sth->fetchrow_hashref()){
    next if $ref->{'ip'} !~ m/^\d+\.\d+\.\d+\.\d+$/;
    next if $ref->{'ip'} =~ m/^0\.0\.0\.0$/;
    system("/usr/sbin/ipset", "-exist", "add", "$ipset", $ref->{'ip'}) == 0 or print "Failed: $!\n";
  }
  $sth->finish;
}

my $config = LoadFile("/var/www/conf/vpsbackup_master_config.yaml") || die "Failed to load config: $!\n";
my $vbh = 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 $!");

foreach my $query ( 'SELECT INET_NTOA(publicip) AS ip FROM backup', 'SELECT INET_NTOA(publicip) AS ip FROM gateway'){
  my $sth = $vbh->prepare($query);
  $sth->execute or warn $sth->errstr;
  while(my $ref = $sth->fetchrow_hashref()){
    next if $ref->{'ip'} !~ m/^\d+\.\d+\.\d+\.\d+$/;
    next if $ref->{'ip'} =~ m/^0\.0\.0\.0$/;
    system("/usr/sbin/ipset", "-exist", "add", "$ipset", $ref->{'ip'}) == 0 or print "Failed: $!\n";
  }
  $sth->finish;
}
