First version of the time slicing on the urls. Not ready for review yet.

chrome/browser/history/visitsegment_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/visitsegment_database.h"
 
 #include <math.h>
 
 #include <algorithm>
 #include <string>
@@ skipping 199 matching lines @@
     insert.BindInt64(2, static_cast<int64>(amount));
 
     return insert.Run();
   }
 }
 
 void VisitSegmentDatabase::QuerySegmentUsage(
     base::Time from_time,
     int max_result_count,
     std::vector<PageUsageData*>* results) {
+  QuerySegmentUsageTimeInterval(from_time, base::Time(), max_result_count,
+                                results);
+}
+void VisitSegmentDatabase::QuerySegmentUsageTimeInterval(
+    base::Time from_time,
+    base::Time to_time,
+    int max_result_count,
+    std::vector<PageUsageData*>* results) {
   // This function gathers the highest-ranked segments in two queries.
   // The first gathers scores for all segments.
   // The second gathers segment data (url, title, etc.) for the highest-ranked
   // segments.
   // TODO(evanm): this disregards the "presentation index", which was what was
   // used to lock results into position.  But the rest of our code currently
   // does as well.
 
   // Gather all the segment scores.
-  sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
-      "SELECT segment_id, time_slot, visit_count "
-      "FROM segment_usage WHERE time_slot >= ? "
-      "ORDER BY segment_id"));
+  sql::Statement statement;
+  if (to_time.is_null()) {
+    statement.Assign(GetDB().GetCachedStatement(SQL_FROM_HERE,
+        "SELECT segment_id, time_slot, visit_count "
+        "FROM segment_usage WHERE time_slot >= ? "
+        "ORDER BY segment_id"));
+  } else {
+    statement.Assign(GetDB().GetCachedStatement(SQL_FROM_HERE,
+        "SELECT segment_id, time_slot, visit_count "
+        "FROM segment_usage WHERE time_slot >= ? AND time_slot <= ?"
+        "ORDER BY segment_id"));
+  }
   if (!statement.is_valid())
     return;
 
-  base::Time ts = from_time.LocalMidnight();
+  base::Time ts = (to_time.is_null()) ? from_time.LocalMidnight() : from_time;
   statement.BindInt64(0, ts.ToInternalValue());
+  if (!to_time.is_null())
+    statement.BindInt64(1, to_time.ToInternalValue());
 
   base::Time now = base::Time::Now();
   SegmentID last_segment_id = 0;
   PageUsageData* pud = NULL;
   float score = 0;
   while (statement.Step()) {
     SegmentID segment_id = statement.ColumnInt64(0);
     if (segment_id != last_segment_id) {
       if (pud) {
         pud->SetScore(score);
@@ skipping 84 matching lines @@
     return false;
 
   sql::Statement delete_seg(GetDB().GetCachedStatement(SQL_FROM_HERE,
       "DELETE FROM segments WHERE url_id = ?"));
   delete_seg.BindInt64(0, url_id);
 
   return delete_seg.Run();
 }
 
 }  // namespace history