#!/usr/bin/env perl

use FindBin;
use lib "$FindBin::RealBin/../lib";
use BackupMaster::BackupMaster;

my $ipset = 'backup_client_allow';

open(my $ipset_fh, '|-', '/usr/sbin/ipset - 2>/dev/null >/dev/null') or die "Couldn't open a pipe into ipset: $!";
print $ipset_fh "-exist -quiet create $ipset hash:ip hashsize 4096\n";

my $bm = BackupMaster::BackupMaster->new();

my $seen = {};
foreach my $query ( 'select INET_NTOA(backnetip) as ip from newbacknetip', 'select ip from serverip', 'select ip from newserverip'){
  #print "QUERY: $query\n";
  my $r = $bm->query_db({query => $query });
  next if ref($r->{rows}) ne 'ARRAY';
  foreach my $ref (@{$r->{rows}}) {
    next if defined($seen->{$ref->{ip}});
    next if $ref->{ip} eq '0.0.0.0';
    next if substr( $ref->{ip},0,3) eq '10.';
    next if substr( $ref->{ip},0,7) eq '172.16.';
    next if substr( $ref->{ip},0,8) eq '192.168.';
    next if $ref->{ip} !~ m/^\d+\.\d+\.\d+\.\d+$/;
    # print ip $ref->{'ip'};
    print $ipset_fh "-exist -quiet add $ipset $ref->{ip}\n";
    $seen->{$ref->{ip}}++;
  }
}
close($ipset_fh);

