[epiphany/in-tab-overview: 24/56] ephy-history-service: extend to support URL thumbnail time

[Xan Lopez <xan src gnome org>]

commit 0adfb20bc5552974c42b07daa9a56ff3f5c16d73
Author: Claudio Saavedra <csaavedra igalia com>
Date:   Mon Aug 27 11:26:20 2012 +0300

    ephy-history-service: extend to support URL thumbnail time

 lib/history/ephy-history-service-urls-table.c |   10 ++++++----
 lib/history/ephy-history-types.c              |    2 ++
 lib/history/ephy-history-types.h              |    1 +
 3 files changed, 9 insertions(+), 4 deletions(-)
---
diff --git a/lib/history/ephy-history-service-urls-table.c b/lib/history/ephy-history-service-urls-table.c
index ff8bcbd..fa1539b 100644
--- a/lib/history/ephy-history-service-urls-table.c
+++ b/lib/history/ephy-history-service-urls-table.c
@@ -70,11 +70,11 @@ ephy_history_service_get_url_row (EphyHistoryService *self, const char *url_stri
 
   if (url != NULL && url->id != -1) {
     statement = ephy_sqlite_connection_create_statement (priv->history_database,
-      "SELECT id, url, title, visit_count, typed_count, last_visit_time, hidden_from_overview FROM urls "
+      "SELECT id, url, title, visit_count, typed_count, last_visit_time, hidden_from_overview, thumbnail_update_time FROM urls "
       "WHERE id=?", &error);
   } else {
     statement = ephy_sqlite_connection_create_statement (priv->history_database,
-      "SELECT id, url, title, visit_count, typed_count, last_visit_time, hidden_from_overview FROM urls "
+      "SELECT id, url, title, visit_count, typed_count, last_visit_time, hidden_from_overview, thumbnail_update_time FROM urls "
       "WHERE url=?", &error);
   }
 
@@ -118,6 +118,7 @@ ephy_history_service_get_url_row (EphyHistoryService *self, const char *url_stri
   url->typed_count = ephy_sqlite_statement_get_column_as_int (statement, 4),
   url->last_visit_time = ephy_sqlite_statement_get_column_as_int (statement, 5);
   url->hidden = ephy_sqlite_statement_get_column_as_int (statement, 6);
+  url->thumbnail_time = ephy_sqlite_statement_get_column_as_int (statement, 7);
 
   g_object_unref (statement);
   return url;
@@ -175,7 +176,7 @@ ephy_history_service_update_url_row (EphyHistoryService *self, EphyHistoryURL *u
   g_assert (priv->history_database != NULL);
 
   statement = ephy_sqlite_connection_create_statement (priv->history_database,
-    "UPDATE urls SET title=?, visit_count=?, typed_count=?, last_visit_time=?, hidden_from_overview=? "
+    "UPDATE urls SET title=?, visit_count=?, typed_count=?, last_visit_time=?, hidden_from_overview=?, thumbnail_update_time=? "
     "WHERE id=?", &error);
   if (error) {
     g_error ("Could not build urls table modification statement: %s", error->message);
@@ -188,7 +189,8 @@ ephy_history_service_update_url_row (EphyHistoryService *self, EphyHistoryURL *u
       ephy_sqlite_statement_bind_int (statement, 2, url->typed_count, &error) == FALSE ||
       ephy_sqlite_statement_bind_int (statement, 3, url->last_visit_time, &error) == FALSE ||
       ephy_sqlite_statement_bind_int (statement, 4, url->hidden, &error) == FALSE ||
-      ephy_sqlite_statement_bind_int (statement, 5, url->id, &error) == FALSE) {
+      ephy_sqlite_statement_bind_int (statement, 5, url->thumbnail_time, &error) == FALSE ||
+      ephy_sqlite_statement_bind_int (statement, 6, url->id, &error) == FALSE) {
     g_error ("Could not modify URL in urls table: %s", error->message);
     g_error_free (error);
     return;
diff --git a/lib/history/ephy-history-types.c b/lib/history/ephy-history-types.c
index a0a5ea8..fe3b951 100644
--- a/lib/history/ephy-history-types.c
+++ b/lib/history/ephy-history-types.c
@@ -149,6 +149,8 @@ ephy_history_url_copy (EphyHistoryURL *url)
   copy->id = url->id;
   copy->hidden = url->hidden;
   copy->host = ephy_history_host_copy (url->host);
+  copy->thumbnail_time = url->thumbnail_time;
+
   return copy;
 }
 
diff --git a/lib/history/ephy-history-types.h b/lib/history/ephy-history-types.h
index fab221c..d8c22ae 100644
--- a/lib/history/ephy-history-types.h
+++ b/lib/history/ephy-history-types.h
@@ -71,6 +71,7 @@ typedef struct _EphyHistoryURL
   int visit_count;
   int typed_count;
   int last_visit_time;
+  int thumbnail_time;
   gboolean hidden;
   EphyHistoryHost *host;
 } EphyHistoryURL;