[epiphany] Implemented sort by title and url in history service. https://bugzilla.gnome.org/show_bug.cgi?id=699

[Robert Roth <robertroth src gnome org>]

commit 464cbb124ccc278a1a462b2b190b7c7fc67cec8a
Author: Robert Roth <robert roth off gmail com>
Date:   Wed Jun 11 11:23:19 2014 +0300

    Implemented sort by title and url in history service. https://bugzilla.gnome.org/show_bug.cgi?id=699519
    
    Provided support in libepiphany to query the history ordered by
    title or url, ascending or descending.

 lib/history/ephy-history-service-urls-table.c |   12 ++++++++++++
 lib/history/ephy-history-types.h              |    6 +++++-
 2 files changed, 17 insertions(+), 1 deletions(-)
---
diff --git a/lib/history/ephy-history-service-urls-table.c b/lib/history/ephy-history-service-urls-table.c
index f9d577b..026a116 100644
--- a/lib/history/ephy-history-service-urls-table.c
+++ b/lib/history/ephy-history-service-urls-table.c
@@ -288,6 +288,18 @@ ephy_history_service_find_url_rows (EphyHistoryService *self, EphyHistoryQuery *
   case EPHY_HISTORY_SORT_LEAST_RECENTLY_VISITED:
     statement_str = g_string_append (statement_str, "ORDER BY urls.last_visit_time ");
     break;
+  case EPHY_HISTORY_SORT_TITLE_ASCENDING:
+    statement_str = g_string_append (statement_str, "ORDER BY LOWER(urls.title) ");
+    break;
+  case EPHY_HISTORY_SORT_TITLE_DESCENDING:
+    statement_str = g_string_append (statement_str, "ORDER BY LOWER(urls.title) DESC ");
+    break;
+  case EPHY_HISTORY_SORT_URL_ASCENDING:
+    statement_str = g_string_append (statement_str, "ORDER BY LOWER(urls.url) ");
+    break;
+  case EPHY_HISTORY_SORT_URL_DESCENDING:
+    statement_str = g_string_append (statement_str, "ORDER BY LOWER(urls.url) DESC ");
+    break;
   default:
     g_warning ("We don't support this sorting method yet.");
   }
diff --git a/lib/history/ephy-history-types.h b/lib/history/ephy-history-types.h
index ecfd821..5f5f5fe 100644
--- a/lib/history/ephy-history-types.h
+++ b/lib/history/ephy-history-types.h
@@ -51,7 +51,11 @@ typedef enum {
   EPHY_HISTORY_SORT_MOST_RECENTLY_VISITED,
   EPHY_HISTORY_SORT_LEAST_RECENTLY_VISITED,
   EPHY_HISTORY_SORT_MOST_VISITED,
-  EPHY_HISTORY_SORT_LEAST_VISITED
+  EPHY_HISTORY_SORT_LEAST_VISITED,
+  EPHY_HISTORY_SORT_TITLE_ASCENDING,
+  EPHY_HISTORY_SORT_TITLE_DESCENDING,
+  EPHY_HISTORY_SORT_URL_ASCENDING,
+  EPHY_HISTORY_SORT_URL_DESCENDING
 } EphyHistorySortType;
 
 typedef struct