[rygel] media-db: Implement search for "res"

[Zeeshan Ali Khattak <zeeshanak src gnome org>]

commit 505fbbe127b451d522c4bd5ca05eef07374c3b6e
Author: Jens Georg <mail jensge org>
Date:   Sat Jan 30 21:19:18 2010 +0100

    media-db: Implement search for "res"

 src/rygel/rygel-media-db.vala |    6 +++++-
 1 files changed, 5 insertions(+), 1 deletions(-)
---
diff --git a/src/rygel/rygel-media-db.vala b/src/rygel/rygel-media-db.vala
index e5ba8e8..0b388f7 100644
--- a/src/rygel/rygel-media-db.vala
+++ b/src/rygel/rygel-media-db.vala
@@ -183,7 +183,7 @@ public class Rygel.MediaDB : Object {
     "LIMIT ?,?";
 
     private const string GET_OBJECTS_STRING_WITH_FILTER =
-    "SELECT o.type_fk, o.title, m.size, m.mime_type, " +
+    "SELECT DISTINCT o.type_fk, o.title, m.size, m.mime_type, " +
             "m.width, m.height, m.class, m.author, m.album, " +
             "m.date, m.bitrate, m.sample_freq, m.bits_per_sample, " +
             "m.channels, m.track, m.color_depth, m.duration, " +
@@ -192,6 +192,7 @@ public class Rygel.MediaDB : Object {
         "JOIN Closure c ON o.upnp_id = c.descendant AND c.ancestor = ? " +
         "LEFT OUTER JOIN meta_data m " +
             "ON o.upnp_id = m.object_fk " +
+        "LEFT OUTER JOIN Uri u ON u.object_fk = o.upnp_id " +
     "WHERE %s " +
         "ORDER BY o.type_fk ASC, " +
                  "m.class ASC, " +
@@ -817,6 +818,9 @@ public class Rygel.MediaDB : Object {
         string column = null;
 
         switch (operand) {
+            case "res":
+                column = "u.uri";
+                break;
             case "@id":
                 column = "o.upnp_id";
                 break;