[grilo-plugins] bookmarks: Implement search all elements
- From: Juan A. Suarez Romero <jasuarez src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [grilo-plugins] bookmarks: Implement search all elements
- Date: Mon, 7 Feb 2011 20:42:09 +0000 (UTC)
commit 7025c9a505ef649c6c81354e6069fe7fefe67100
Author: Juan A. Suarez Romero <jasuarez igalia com>
Date: Wed Feb 2 11:46:22 2011 +0100
bookmarks: Implement search all elements
Signed-off-by: Juan A. Suarez Romero <jasuarez igalia com>
src/bookmarks/grl-bookmarks.c | 8 ++++++--
1 files changed, 6 insertions(+), 2 deletions(-)
---
diff --git a/src/bookmarks/grl-bookmarks.c b/src/bookmarks/grl-bookmarks.c
index c3baf16..e14a078 100644
--- a/src/bookmarks/grl-bookmarks.c
+++ b/src/bookmarks/grl-bookmarks.c
@@ -95,7 +95,8 @@ GRL_LOG_DOMAIN_STATIC(bookmarks_log_domain);
"SELECT b1.*, count(b2.parent <> '') " \
"FROM bookmarks b1 LEFT OUTER JOIN bookmarks b2 " \
" ON b1.id = b2.parent " \
- "WHERE b1.title LIKE '%%%s%%' OR b1.desc LIKE '%%%s%%' " \
+ "WHERE (b1.title LIKE '%%%s%%' OR b1.desc LIKE '%%%s%%') " \
+ " AND b1.type = 1 " \
"GROUP BY b1.id " \
"LIMIT %u OFFSET %u"
@@ -508,7 +509,10 @@ produce_bookmarks_by_text (OperationSpec *os, const gchar *text)
gchar *sql;
GRL_DEBUG ("produce_bookmarks_by_text");
sql = g_strdup_printf (GRL_SQL_GET_BOOKMARKS_BY_TEXT,
- text, text, os->count, os->skip);
+ text? text: "",
+ text? text: "",
+ os->count,
+ os->skip);
produce_bookmarks_from_sql (os, sql);
g_free (sql);
}
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]