From 54edad24dc20d71b9c4e3056533dd8ee6a10e03e Mon Sep 17 00:00:00 2001 From: Claudio Saavedra Date: Mon, 27 Aug 2012 11:26:20 +0300 Subject: 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(-) (limited to 'lib/history') diff --git a/lib/history/ephy-history-service-urls-table.c b/lib/history/ephy-history-service-urls-table.c index ff8bcbdf3..fa1539b22 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 a0a5ea8c7..fe3b951ae 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 fab221c3c..d8c22ae32 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; -- cgit v1.2.3