From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Sun, 30 Jan 2011 19:20:52 +0000 (+0100)
Subject: expand and fix backups_burned view
X-Git-Url: http://git.rot13.org/?p=BackupPC.git;a=commitdiff_plain;h=bf4ba556b41b4b848755abf2f9923b38bfea0179

expand and fix backups_burned view
---

diff --git a/bin/BackupPC_ASA_SearchUpdate b/bin/BackupPC_ASA_SearchUpdate
index d860037..de465b7 100755
--- a/bin/BackupPC_ASA_SearchUpdate
+++ b/bin/BackupPC_ASA_SearchUpdate
@@ -744,14 +744,16 @@ JOIN shares        ON shareid = shares.id
 
 
 CREATE VIEW backups_burned AS
-SELECT
-	backup_id,
-	count(backup_id) = count(backup_part_id) as burned
-FROM archive
-JOIN archive_parts ON archive.id = archive_id
-JOIN backup_parts  ON backup_part_id = backup_id
-GROUP BY backup_id
-;
+SELECT backup_parts.backup_id,
+count(backup_parts.backup_id) as backup_parts,
+count(archive_burned.archive_id) AS burned_parts,
+count(backup_parts.backup_id) = count(archive_burned.archive_id) as burned
+   FROM backup_parts 
+   left outer JOIN archive_parts ON backup_part_id = backup_parts.id
+   left join archive on archive.id = archive_id
+   left outer join archive_burned on archive_burned.archive_id = archive.id
+  GROUP BY backup_parts.backup_id ;
+
 
 -- triggers for backup_parts consistency
 create or replace function backup_parts_check() returns trigger as '