Add UMA metrics and histograms for locally managed users.

chrome/browser/history/url_database.cc

 // Copyright (c) 2012 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 93 matching lines @@
       "SELECT" HISTORY_URL_ROW_FIELDS "FROM urls WHERE typed_count > 0"));
 
   while (statement.Step()) {
     URLRow info;
     FillURLRow(statement, &info);
     urls->push_back(info);
   }
   return true;
 }
 
+bool URLDatabase::GetUniqueURLsInRange(base::Time begin_time,
+                                       base::Time end_time,
+                                       int max_results,
+                                       URLRows* urls) {
+  sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
+      "SELECT DISTINCT" HISTORY_URL_ROW_FIELDS "FROM urls "
+      "WHERE last_visit_time > ? AND last_visit_time < ? "
+      "ORDER BY last_visit_time LIMIT ?"));
+
+  // See VisitDatabase::GetVisibleVisitsInRange for more info on how these
+  // times are bound.
+  int64 end = end_time.ToInternalValue();
+  statement.BindInt64(0, begin_time.ToInternalValue());
+  statement.BindInt64(1, end ? end : std::numeric_limits<int64>::max());
+  statement.BindInt64(2,
+      max_results ? max_results : std::numeric_limits<int64>::max());
+
+  while (statement.Step()) {
+    URLRow info;
+    FillURLRow(statement, &info);
+    urls->push_back(info);
+  }
+  return true;
+}
+
 URLID URLDatabase::GetRowForURL(const GURL& url, history::URLRow* info) {
   sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
       "SELECT" HISTORY_URL_ROW_FIELDS "FROM urls WHERE url=?"));
   std::string url_string = GURLToDatabaseURL(url);
   statement.BindString(0, url_string);
 
   if (!statement.Step())
     return 0;  // no data
 
   if (info)
@@ skipping 445 matching lines @@
   return GetDB().Execute(sql.c_str());
 }
 
 bool URLDatabase::CreateMainURLIndex() {
   // Index over URLs so we can quickly look up based on URL.
   return GetDB().Execute(
       "CREATE INDEX IF NOT EXISTS urls_url_index ON urls (url)");
 }
 
 }  // namespace history