1 files changed, 122 insertions, 0 deletions
diff --git a/src/plugins/lms/rygel-lms-all-music.vala b/src/plugins/lms/rygel-lms-all-music.vala
new file mode 100644
index 00000000..f856a929
--- /dev/null
+++ b/src/plugins/lms/rygel-lms-all-music.vala
@@ -0,0 +1,122 @@
+/*
+ * Copyright (C) 2013 Intel Corporation.
+ *
+ * Author: Jussi Kukkonen <jussi.kukkonen@intel.com>
+ *
+ * This file is part of Rygel.
+ *
+ * Rygel is free software; you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation; either version 2 of the License, or
+ * (at your option) any later version.
+ *
+ * Rygel is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with this program; if not, write to the Free Software Foundation,
+ * Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
+ */
+
+using Rygel;
+using Sqlite;
+
+public class Rygel.LMS.AllMusic : Rygel.LMS.CategoryContainer {
+    private static const string SQL_ALL_TEMPLATE =
+        "SELECT files.id, files.path, files.size, " +
+               "audios.title as title, audios.trackno, audios.length, audios.channels, audios.sampling_rate, audios.bitrate, audios.dlna_profile, audios.dlna_mime, " +
+               "audio_artists.name as artist, " +
+               "audio_albums.name " +
+        "FROM audios, files " +
+        "LEFT JOIN audio_artists " +
+        "ON audios.artist_id = audio_artists.id " +
+        "LEFT JOIN audio_albums " +
+        "ON audios.album_id = audio_albums.id " +
+        "WHERE audios.id = files.id %s " +
+        "LIMIT ? OFFSET ?;";
+
+    private static const string SQL_COUNT =
+        "SELECT COUNT(audios.id) " +
+        "FROM audios, files " +
+        "WHERE audios.id = files.id;";
+
+    private static const string SQL_COUNT_WITH_FILTER_TEMPLATE =
+        "SELECT COUNT(audios.id), audios.title as title, " +
+               "audio_artists.name as artist " +
+        "FROM audios, files " +
+        "LEFT JOIN audio_artists " +
+        "ON audios.artist_id = audio_artists.id " +
+        "WHERE audios.id = files.id %s;";
+
+    private static const string SQL_FIND_OBJECT =
+        "SELECT files.id, files.path, files.size, " +
+               "audios.title, audios.trackno, audios.length, audios.channels, audios.sampling_rate, audios.bitrate, audios.dlna_profile, audios.dlna_mime, " + 
+               "audio_artists.name, " +
+               "audio_albums.name " +
+        "FROM audios, files " +
+        "LEFT JOIN audio_artists " +
+        "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;";
+
+    protected override string get_sql_all_with_filter (string filter) {
+        if (filter.length == 0) {
+            return this.sql_all;
+        }
+        var filter_str = "AND %s".printf (filter);
+        return (AllMusic.SQL_ALL_TEMPLATE.printf (filter_str));
+    }
+
+    protected override string get_sql_count_with_filter (string filter) {
+        if (filter.length == 0) {
+            return this.sql_count;
+        }
+        var filter_str = "AND %s".printf (filter);
+        return (AllMusic.SQL_COUNT_WITH_FILTER_TEMPLATE.printf (filter_str));
+    }
+
+    protected override MediaObject? object_from_statement (Statement statement) {
+        var id = statement.column_int (0);
+        var path = statement.column_text (1);
+        var mime_type = statement.column_text(10);
+
+        if (mime_type == null || mime_type.length == 0) {
+            /* TODO is this correct? */
+            debug ("Skipping music item %d (%s) with no MIME type",
+                   id,
+                   path);
+            return null;
+        }
+
+        var title = statement.column_text(3);
+        var song_id = this.build_child_id (id);
+        var song = new MusicItem (song_id, this, title);
+        song.size = statement.column_int(2);
+        song.track_number = statement.column_int(4);
+        song.duration = statement.column_int(5);
+        song.channels = statement.column_int(6);
+        song.sample_freq = statement.column_int(7); 
+        song.bitrate = statement.column_int(8);
+        song.dlna_profile = statement.column_text(9);
+        song.mime_type = mime_type;
+        song.artist = statement.column_text(11);
+        song.album = statement.column_text(12);
+        File file = File.new_for_path (path);
+        song.add_uri (file.get_uri ());
+
+        return song;
+    }
+
+    public AllMusic (MediaContainer parent, LMS.Database lms_db) {
+        base("all",
+             parent,
+             _("All"),
+             lms_db,
+             AllMusic.SQL_ALL_TEMPLATE.printf (""),
+             AllMusic.SQL_FIND_OBJECT,
+             AllMusic.SQL_COUNT);
+    }
+}