1 files changed, 94 insertions, 0 deletions
diff --git a/src/plugins/lms/rygel-lms-image-year.vala b/src/plugins/lms/rygel-lms-image-year.vala
new file mode 100644
index 00000000..1c32b71e
--- /dev/null
+++ b/src/plugins/lms/rygel-lms-image-year.vala
@@ -0,0 +1,94 @@
+/*
+ * 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.ImageYear : Rygel.LMS.CategoryContainer {
+    private static const string SQL_ALL_TEMPLATE =
+        "SELECT images.id, title, artist, date, width, height, path, size, dlna_profile, dlna_mime, strftime('%Y', date, 'unixepoch') as year " +
+        "FROM images, files " +
+        "WHERE images.id = files.id AND year = '%s' " +
+        "LIMIT ? OFFSET ?;";
+
+    private static const string SQL_COUNT_TEMPLATE =
+        "SELECT count(images.id), strftime('%Y', date, 'unixepoch') as year " +
+        "FROM images, files " +
+        "WHERE images.id = files.id AND year = '%s';";
+
+    private static const string SQL_FIND_OBJECT_TEMPLATE =
+        "SELECT images.id, title, artist, date, width, height, path, size, dlna_profile, dlna_mime, strftime('%Y', date, 'unixepoch') as year " +
+        "FROM images, files " +
+        "WHERE files.id = ? AND images.id = files.id AND year = '%s';";
+
+    protected override MediaObject? object_from_statement (Statement statement) {
+        var id = statement.column_int(0);
+        var path = statement.column_text(6);
+        var mime_type = statement.column_text(9);
+
+        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(1);
+        var image = new ImageItem(this.build_child_id (id), this, title);
+        image.ref_id = this.build_reference_id (id);
+        image.creator = statement.column_text(2);
+        TimeVal tv = { (long) statement.column_int(3), (long) 0 };
+        image.date = tv.to_iso8601 ();
+        image.width = statement.column_int(4);
+        image.height = statement.column_int(5);
+        image.size = statement.column_int(7);
+        image.mime_type = mime_type;
+        image.dlna_profile = statement.column_text(8);
+        File file = File.new_for_path(path);
+        image.add_uri (file.get_uri ());
+
+        return image;
+    }
+
+    private static string get_sql_all (string year) {
+        return (SQL_ALL_TEMPLATE.printf (year));
+    }
+    private static string get_sql_find_object (string year) {
+        return (SQL_FIND_OBJECT_TEMPLATE.printf (year));
+    }
+    private static string get_sql_count (string year) {
+        return (SQL_COUNT_TEMPLATE.printf (year));
+    }
+
+    public ImageYear (MediaContainer parent,
+                      string         year,
+                      LMS.Database   lms_db) {
+        base ("%s".printf (year),
+              parent,
+              year,
+              lms_db,
+              get_sql_all (year),
+              get_sql_find_object (year),
+              get_sql_count (year));
+    }
+}