use lib "/usr/local/BackupPC/lib";
use Getopt::Std;
use BackupPC::Lib;
+use BackupPC::Search;
-use DBI;
use Data::Dump qw(dump);
my $debug = $ENV{DEBUG} || 0;
my %Conf = $bpc->Conf();
-my $dbh = DBI->connect($Conf{SearchDSN}, $Conf{SearchUser}, "", { RaiseError => 1, AutoCommit => 0 });
+my $dbh = BackupPC::Search::get_dbh;
my $sth = $dbh->prepare(qq{
select
}
$bpc->ConfigRead($ArchiveHost);
-if ( ! @HostFilter ) {
- @HostFilter = keys %$Hosts;
-}
-
-warn "archiving hosts ",dump(@HostFilter);
-
my(@HostList, @BackupList);
-foreach ( @HostFilter ) {
- my ($host,$num) = split(/:/,$_,2);
- if ( !defined($Hosts->{$host}) ) {
- print(STDERR "$0: host $host doesn't exist... quitting\n");
- exit(1);
- }
- my @backups = $bpc->BackupInfoRead($host);
- if ( !@backups ) {
- warn "$0: host $host doesn't have any backups... skipping\n";
- next;
- }
-
- my $all_backup_numbers;
- $all_backup_numbers->{ $_->{num} }++ foreach @backups;
-
- $sth->execute( $host );
- while ( my $row = $sth->fetchrow_hashref ) {
- warn "# row ",dump($row) if $debug;
- $all_backup_numbers->{ $row->{num} } =
- $row->{inc_deleted} ? 0 :
- $row->{size} == 0 ? 0 :
- $row->{inc_size} > 0 ? 0 :
- $row->{size} > 0 ? 1 :
- 0;
- }
- warn "# $host all_backup_numbers = ",dump($all_backup_numbers) if $debug;
- my @backup_nums =
- sort
- grep { $all_backup_numbers->{$_} }
- keys %$all_backup_numbers;
+my $host_nums;
+
+foreach my $host ( keys %$Hosts ) {
+ $host = lc $host;
+ my @backups = $bpc->BackupInfoRead($host);
+ if ( !@backups ) {
+ warn "$0: host $host doesn't have any backups... skipping\n";
+ next;
+ }
+ $host_nums->{$host} = [ BackupPC::Search::host_backup_nums( $host ) ];
+}
- foreach my $num ( @backup_nums ) {
+foreach ( @HostFilter ) {
+ my ($host,$num) = split(/:/,$_,2);
+ if ( !defined($Hosts->{$host}) ) {
+ print(STDERR "$0: host $host doesn't exist... quitting\n");
+ exit(1);
+ }
+ if ( defined $num ) {
warn "+ $host $num\n";
push(@HostList, $host);
push(@BackupList, $num);
+ } else {
+ foreach my $num ( @{ $host_nums->{$host} } ) {
+ warn "+ $host $num\n";
+ push(@HostList, $host);
+ push(@BackupList, $num);
+ }
+ }
+}
+
+if ( ! @HostFilter ) {
+ foreach my $host ( keys %$host_nums ) {
+ foreach my $num ( @{ $host_nums->{$host} } ) {
+ warn "+ $host $num\n";
+ push(@HostList, $host);
+ push(@BackupList, $num);
+ }
}
}
+warn "# HostList=",dump(@HostList),"\n";
+warn "# BackupList=",dump(@BackupList),"\n";
+
$dbh->disconnect;
my $ReqFileName;