117 |
backupNum INTEGER NOT NULL, |
backupNum INTEGER NOT NULL, |
118 |
name VARCHAR(255) NOT NULL, |
name VARCHAR(255) NOT NULL, |
119 |
path VARCHAR(255) NOT NULL, |
path VARCHAR(255) NOT NULL, |
|
fullpath VARCHAR(255) NOT NULL, |
|
120 |
date integer NOT NULL, |
date integer NOT NULL, |
121 |
type INTEGER NOT NULL, |
type INTEGER NOT NULL, |
122 |
size INTEGER NOT NULL, |
size INTEGER NOT NULL, |
193 |
|
|
194 |
$sth->{insert_files} = $dbh->prepare(qq{ |
$sth->{insert_files} = $dbh->prepare(qq{ |
195 |
INSERT INTO files |
INSERT INTO files |
196 |
(shareID, backupNum, name, path, fullpath, date, type, size) |
(shareID, backupNum, name, path, date, type, size) |
197 |
VALUES (?,?,?,?,?,?,?,?) |
VALUES (?,?,?,?,?,?,?) |
198 |
}); |
}); |
199 |
|
|
200 |
sub fmt_time { |
sub fmt_time { |
240 |
print $hosts->{$host_key}->{'host'}, |
print $hosts->{$host_key}->{'host'}, |
241 |
"\t#$backupNum\t", $backup->{type} || '?', " ", |
"\t#$backupNum\t", $backup->{type} || '?', " ", |
242 |
$backup->{nFilesNew} || '?', "/", $backup->{nFiles} || '?', |
$backup->{nFilesNew} || '?', "/", $backup->{nFiles} || '?', |
243 |
" files\n"; |
" files (date: ", |
244 |
|
strftime($t_fmt,localtime($backup->{startTime})), |
245 |
|
" dur: ", |
246 |
|
fmt_time($backup->{endTime} - $backup->{startTime}), |
247 |
|
")\n"; |
248 |
|
|
249 |
$sth->{backups_broj}->execute($hostID, $backupNum); |
$sth->{backups_broj}->execute($hostID, $backupNum); |
250 |
my ($broj) = $sth->{backups_broj}->fetchrow_array(); |
my ($broj) = $sth->{backups_broj}->fetchrow_array(); |
367 |
$backupNum, |
$backupNum, |
368 |
$path_key, |
$path_key, |
369 |
$filesInBackup->{$path_key}->{'relPath'}, |
$filesInBackup->{$path_key}->{'relPath'}, |
|
$filesInBackup->{$path_key}->{'fullPath'}, |
|
|
# $filesInBackup->{$path_key}->{'sharePathM'}, |
|
370 |
$filesInBackup->{$path_key}->{'mtime'}, |
$filesInBackup->{$path_key}->{'mtime'}, |
371 |
$filesInBackup->{$path_key}->{'type'}, |
$filesInBackup->{$path_key}->{'type'}, |
372 |
$filesInBackup->{$path_key}->{'size'} |
$filesInBackup->{$path_key}->{'size'} |