/[BackupPC]/trunk/lib/BackupPC/SearchLib.pm
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/lib/BackupPC/SearchLib.pm

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

revision 121 by iklaric, Thu Sep 15 13:54:29 2005 UTC revision 122 by dpavlin, Fri Sep 16 14:11:00 2005 UTC
# Line 301  sub getBackupsNotBurned() { Line 301  sub getBackupsNotBurned() {
301    
302          my $dbh = get_dbh();          my $dbh = get_dbh();
303    
304          my $sql = q{          my $sql = q{
305                  SELECT                  SELECT
306                          backups.hostID AS hostID,                          backups.hostID AS hostID,
307                          hosts.name AS host,                          hosts.name AS host,
# Line 311  sub getBackupsNotBurned() { Line 311  sub getBackupsNotBurned() {
311                          backups.date AS date,                          backups.date AS date,
312                          backups.size AS size                          backups.size AS size
313                  FROM backups                  FROM backups
314                  WHERE id not in( select id from backups,archive_backup where archive_backup.backup_id=backups.id)                  INNER JOIN shares       ON backups.shareID=shares.ID
315                    INNER JOIN hosts        ON backups.hostID = hosts.ID
316                    LEFT OUTER JOIN archive_backup ON archive_backup.backup_id = backups.id AND archive_backup.backup_id IS NULL
317                    WHERE backups.size > 0
318                    GROUP BY
319                            backups.hostID,
320                            hosts.name,
321                            shares.name,
322                            backups.num,
323                            backups.shareid,
324                            backups.id,
325                            backups.type,
326                            backups.date,
327                            backups.size
328                  ORDER BY backups.date                  ORDER BY backups.date
329          };          };
330          my $sth = $dbh->prepare( $sql );          my $sth = $dbh->prepare( $sql );
Legend:
Removed from v.121  
changed lines
  Added in v.122
  ViewVC Help
Powered by ViewVC 1.1.26