Proof of concept implementation of context based history filtering.

components/history/core/browser/url_database.cc

 // Copyright 2014 The Chromium Authors. All rights reserved.
 // Use of this source code is governed by a BSD-style license that can be
 // found in the LICENSE file.
 
 #include "components/history/core/browser/url_database.h"
 
 #include <limits>
 #include <string>
 #include <vector>
 
@@ skipping 50 matching lines @@
 // Convenience to fill a URLRow. Must be in sync with the fields in
 // kURLRowFields.
 void URLDatabase::FillURLRow(sql::Statement& s, URLRow* i) {
   DCHECK(i);
   i->id_ = s.ColumnInt64(0);
   i->url_ = GURL(s.ColumnString(1));
   i->title_ = s.ColumnString16(2);
   i->visit_count_ = s.ColumnInt(3);
   i->typed_count_ = s.ColumnInt(4);
   i->last_visit_ = base::Time::FromInternalValue(s.ColumnInt64(5));
-  i->hidden_ = s.ColumnInt(6) != 0;
+  i->context_ = static_cast<history::HistoryContext>(s.ColumnInt(6));
+  i->hidden_ = s.ColumnInt(7) != 0;
 }
 
 bool URLDatabase::GetURLRow(URLID url_id, URLRow* info) {
   // TODO(brettw) We need check for empty URLs to handle the case where
   // there are old URLs in the database that are empty that got in before
   // we added any checks. We should eventually be able to remove it
   // when all inputs are using GURL (which prohibit empty input).
   sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
       "SELECT" HISTORY_URL_ROW_FIELDS "FROM urls WHERE id=?"));
   statement.BindInt64(0, url_id);
@@ skipping 26 matching lines @@
   if (!statement.Step())
     return 0;  // no data
 
   if (info)
     FillURLRow(statement, info);
   return statement.ColumnInt64(0);
 }
 
 bool URLDatabase::UpdateURLRow(URLID url_id, const URLRow& info) {
   sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
-      "UPDATE urls SET title=?,visit_count=?,typed_count=?,last_visit_time=?,"
+      "UPDATE urls SET title=?,visit_count=?,typed_count=?,last_visit_time=?,context=?,"
         "hidden=?"
       "WHERE id=?"));
   statement.BindString16(0, info.title());
   statement.BindInt(1, info.visit_count());
   statement.BindInt(2, info.typed_count());
   statement.BindInt64(3, info.last_visit().ToInternalValue());
-  statement.BindInt(4, info.hidden() ? 1 : 0);
-  statement.BindInt64(5, url_id);
+  statement.BindInt(4, info.context());
+  statement.BindInt(5, info.hidden() ? 1 : 0);
+  statement.BindInt64(6, url_id);
 
   return statement.Run() && GetDB().GetLastChangeCount() > 0;
 }
 
 URLID URLDatabase::AddURLInternal(const URLRow& info, bool is_temporary) {
   // This function is used to insert into two different tables, so we have to
   // do some shuffling. Unfortinately, we can't use the macro
   // HISTORY_URL_ROW_FIELDS because that specifies the table name which is
   // invalid in the insert syntax.
   #define ADDURL_COMMON_SUFFIX \
@@ skipping 459 matching lines @@
   std::string sql;
   sql.append("CREATE TABLE ");
   sql.append(name);
   sql.append("("
       "id INTEGER PRIMARY KEY,"
       "url LONGVARCHAR,"
       "title LONGVARCHAR,"
       "visit_count INTEGER DEFAULT 0 NOT NULL,"
       "typed_count INTEGER DEFAULT 0 NOT NULL,"
       "last_visit_time INTEGER NOT NULL,"
+      "context INTEGER DEFAULT 0 NOT NULL,"
       "hidden INTEGER DEFAULT 0 NOT NULL,"
       "favicon_id INTEGER DEFAULT 0 NOT NULL)"); // favicon_id is not used now.
 
   return GetDB().Execute(sql.c_str());
 }
 
 bool URLDatabase::CreateMainURLIndex() {
   return GetDB().Execute(
       "CREATE INDEX IF NOT EXISTS urls_url_index ON urls (url)");
 }
@@ skipping 10 matching lines @@
 bool RowQualifiesAsSignificant(const URLRow& row,
                                const base::Time& threshold) {
   const base::Time& real_threshold =
       threshold.is_null() ? AutocompleteAgeThreshold() : threshold;
   return (row.typed_count() >= kLowQualityMatchTypedLimit) ||
          (row.visit_count() >= kLowQualityMatchVisitLimit) ||
          (row.last_visit() >= real_threshold);
 }
 
 }  // namespace history