Makes the in memory db update rows that have search terms associated

chrome/browser/history/url_database.cc

 // Copyright (c) 2010 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 "chrome/browser/history/url_database.h"
 
 #include <algorithm>
 #include <limits>
 #include <string>
 #include <vector>
@@ skipping 368 matching lines @@
   if (!statement)
     return false;
 
   statement.BindInt64(0, keyword_id);
   statement.BindInt64(1, url_id);
   statement.BindString16(2, l10n_util::ToLower(term));
   statement.BindString16(3, term);
   return statement.Run();
 }
 
+bool URLDatabase::GetKeywordSearchTermRow(URLID url_id,
+                                          KeywordSearchTermRow* row) {
+  DCHECK(url_id);
+  sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
+      "SELECT keyword_id, term FROM keyword_search_terms WHERE url_id=?"));
+  if (!statement)
+    return false;
+
+  statement.BindInt64(0, url_id);
+  if (!statement.Step())
+    return false;
+
+  if (row) {
+    row->url_id = url_id;
+    row->keyword_id = statement.ColumnInt64(0);
+    row->term = statement.ColumnString16(1);
+  }
+  return true;
+}
+
 void URLDatabase::DeleteAllSearchTermsForKeyword(
     TemplateURLID keyword_id) {
   DCHECK(keyword_id);
   sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
       "DELETE FROM keyword_search_terms WHERE keyword_id=?"));
   if (!statement)
     return;
 
   statement.BindInt64(0, keyword_id);
   statement.Run();
@@ skipping 103 matching lines @@
   // this likely already exists (and the same below).
   GetDB().Execute("CREATE INDEX urls_url_index ON urls (url)");
 }
 
 void URLDatabase::CreateSupplimentaryURLIndices() {
   // Add a favicon index.  This is useful when we delete urls.
   GetDB().Execute("CREATE INDEX urls_favicon_id_INDEX ON urls (favicon_id)");
 }
 
 }  // namespace history