after importing, always delete albums without corresponding tracks

git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/trunk/muggle-plugin@1019 e10066b5-e1e2-0310-b819-94efdf66514b

1 files changed, 3 insertions, 0 deletions

diff --git a/mg_db.c b/mg_db.c
index 30b7829..ec39ad6 100644
--- a/mg_db.c
+++ b/mg_db.c
@@ -446,6 +446,9 @@ mgDb::Sync(char * const * path_argv)
 		}
 		fts_close(fts);
 	}
+	mgDebug(1,"Deleted %d albums because they have no tracks",
+		Execute("DELETE FROM album WHERE NOT EXISTS(SELECT 1 FROM"
+		" tracks WHERE tracks.sourceid=album.cddbid)"));
 	Commit();
 	SyncEnd();
 	showimportcount(importcount,true);