/[BackupPC]/trunk/bin/BackupPC_incPartsUpdate
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk/bin/BackupPC_incPartsUpdate

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 157 by dpavlin, Mon Oct 10 13:04:51 2005 UTC revision 182 by dpavlin, Wed Oct 12 11:15:18 2005 UTC
# Line 8  use BackupPC::Lib; Line 8  use BackupPC::Lib;
8  use BackupPC::View;  use BackupPC::View;
9  use Data::Dumper;  use Data::Dumper;
10  use Time::HiRes qw/time/;  use Time::HiRes qw/time/;
 use File::Pid;  
11  use POSIX qw/strftime/;  use POSIX qw/strftime/;
12  use BackupPC::SearchLib;  use BackupPC::SearchLib;
13  use Cwd qw/abs_path/;  use Cwd qw/abs_path/;
# Line 19  my $tarIncCreate = $path .= 'BackupPC_ta Line 18  my $tarIncCreate = $path .= 'BackupPC_ta
18    
19  die "can't find $tarIncCreate: $!\n" unless (-x $tarIncCreate);  die "can't find $tarIncCreate: $!\n" unless (-x $tarIncCreate);
20    
21  my $debug = 1;  my $debug = 0;
22  $|=1;  $|=1;
23    
24  my $start_t = time();  my $start_t = time();
# Line 61  sub curr_time { Line 60  sub curr_time {
60  my $sth = $dbh->prepare( qq{  my $sth = $dbh->prepare( qq{
61                    
62  select  select
63            backups.id as backup_id,
64          hosts.name as host,          hosts.name as host,
65          shares.name as share,          shares.name as share,
66          num as num          backups.num as num
67  from backups  from backups
68          join shares on backups.hostid = shares.hostid          join shares on backups.hostid = shares.hostid
69                  and shares.id = backups.shareid                  and shares.id = backups.shareid
# Line 75  order by backups.date Line 75  order by backups.date
75    
76  $sth->execute();  $sth->execute();
77    
78    my $sth_inc_size = $dbh->prepare(qq{ update backups set inc_size = ? where id = ? });
79    my $sth_inc_deleted = $dbh->prepare(qq{ update backups set inc_deleted = ? where id = ? });
80    
81  %BackupPC::SearchLib::Conf = %Conf;  %BackupPC::SearchLib::Conf = %Conf;
82    
83  while (my $row = $sth->fetchrow_hashref) {  while (my $row = $sth->fetchrow_hashref) {
84          my $tar_file = BackupPC::SearchLib::getGzipName($row->{'host'}, $row->{'share'}, $row->{'num'});          my $tar_file = BackupPC::SearchLib::getGzipName($row->{'host'}, $row->{'share'}, $row->{'num'});
85          print curr_time, sprintf(" %s:%s %-3d ", $row->{'host'}, $row->{'share'}, $row->{'num'}), " -> $tar_file ";          print curr_time, " ", $row->{'host'}, ":", $row->{'share'}, " #", $row->{'num'}, " -> $tar_file";
86    
87          my $t = time();          my $t = time();
88    
# Line 88  while (my $row = $sth->fetchrow_hashref) Line 91  while (my $row = $sth->fetchrow_hashref)
91    
92          system($cmd) == 0 or die "failed: $?";          system($cmd) == 0 or die "failed: $?";
93    
94          print fmt_time(time() - $t),"\n";          my $size = (stat( "$tar_dir/$tar_file" ))[7];
95    
96            printf(" %1.2f MB, dur: %s", ($size / 1024 / 1024), fmt_time(time() - $t));
97    
98            if ($size > 45) {
99                    $sth_inc_size->execute($size, $row->{'backup_id'});
100                    $sth_inc_deleted->execute(0, $row->{'backup_id'});
101            } else {
102                    $sth_inc_deleted->execute(1, $row->{'backup_id'});
103                    unlink "$tar_dir/$tar_file" || die "can't delete $tar_dir/$tar_file: $!\n";
104                    print " EMPTY";
105            }
106            print "\n";
107    
108            $dbh->commit;
109    
110  }  }
111    
Legend:
Removed from v.157  
changed lines
  Added in v.182
  ViewVC Help
Powered by ViewVC 1.1.26