lms: add dtime=0 condition to all queries involving files table

[profile/ivi/rygel.git] / src / plugins / lms / rygel-lms-album.vala

diff --git a/src/plugins/lms/rygel-lms-album.vala b/src/plugins/lms/rygel-lms-album.vala
index 7898fa7..3c23dc3 100644 (file)
--- a/src/plugins/lms/rygel-lms-album.vala
+++ b/src/plugins/lms/rygel-lms-album.vala
@@ -34,13 +34,13 @@ public class Rygel.LMS.Album : Rygel.LMS.CategoryContainer {
         "ON audios.artist_id = audio_artists.id " +
         "LEFT JOIN audio_albums " +
         "ON audios.album_id = audio_albums.id " +
-        "WHERE audios.id = files.id AND audios.album_id = %s " +
+        "WHERE dtime = 0 AND audios.id = files.id AND audios.album_id = %s " +
         "LIMIT ? OFFSET ?;";
 
     private static const string SQL_COUNT_TEMPLATE =
         "SELECT COUNT(audios.id) " +
         "FROM audios, files " +
-        "WHERE audios.id = files.id AND audios.album_id = %s;";
+        "WHERE dtime = 0 AND audios.id = files.id AND audios.album_id = %s;";
 
     private static const string SQL_COUNT_WITH_FILTER_TEMPLATE =
         "SELECT COUNT(audios.id), audios.title as title, " +
@@ -51,7 +51,7 @@ public class Rygel.LMS.Album : Rygel.LMS.CategoryContainer {
         "ON audios.artist_id = audio_artists.id " +
         "LEFT JOIN audio_albums " +
         "ON audios.album_id = audio_albums.id " +
-        "WHERE audios.id = files.id AND audios.album_id = %s;";
+        "WHERE dtime = 0 AND audios.id = files.id AND audios.album_id = %s;";
 
     private static const string SQL_FIND_OBJECT_TEMPLATE =
         "SELECT files.id, files.path, files.size, " +
@@ -63,7 +63,7 @@ public class Rygel.LMS.Album : Rygel.LMS.CategoryContainer {
         "ON audios.artist_id = audio_artists.id " +
         "LEFT JOIN audio_albums " +
         "ON audios.album_id = audio_albums.id " +
-        "WHERE files.id = ? AND audios.id = files.id AND audios.album_id = %s;";
+        "WHERE dtime = 0 AND files.id = ? AND audios.id = files.id AND audios.album_id = %s;";
 
     protected override MediaObject? object_from_statement (Statement statement) {
         var id = statement.column_int (0);