Implement PasswordStore::GetAllStats

components/password_manager/core/browser/statistics_table.cc

 // Copyright 2015 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/password_manager/core/browser/statistics_table.h"
 
 #include <stdint.h>
 
 #include <algorithm>
 #include <limits>
 #include <set>
 
 #include "base/memory/ptr_util.h"
 #include "sql/connection.h"
 #include "sql/statement.h"
 
 namespace password_manager {
 namespace {
 
 // Convenience enum for interacting with SQL queries that use all the columns.
 enum LoginTableColumns {
   COLUMN_ORIGIN_DOMAIN = 0,
   COLUMN_USERNAME,
   COLUMN_DISMISSALS,
   COLUMN_DATE,
 };
 
+// Iterates through all rows of s constructing a stats vector.
+std::vector<InteractionsStats> StatementToInteractionsStats(sql::Statement* s) {
+  std::vector<InteractionsStats> results;
+  while (s->Step()) {
+    results.push_back(InteractionsStats());
+    results.back().origin_domain = GURL(s->ColumnString(COLUMN_ORIGIN_DOMAIN));
+    results.back().username_value = s->ColumnString16(COLUMN_USERNAME);
+    results.back().dismissal_count = s->ColumnInt(COLUMN_DISMISSALS);
+    results.back().update_time =
+        base::Time::FromInternalValue(s->ColumnInt64(COLUMN_DATE));
+  }
+
+  return results;
+}
+
 }  // namespace
 
 InteractionsStats::InteractionsStats() = default;
 
 bool operator==(const InteractionsStats& lhs, const InteractionsStats& rhs) {
   return lhs.origin_domain == rhs.origin_domain &&
          lhs.username_value == rhs.username_value &&
          lhs.dismissal_count == rhs.dismissal_count &&
          lhs.update_time == rhs.update_time;
 }
@@ skipping 61 matching lines @@
 bool StatisticsTable::RemoveRow(const GURL& domain) {
   if (!domain.is_valid())
     return false;
   sql::Statement s(db_->GetCachedStatement(SQL_FROM_HERE,
                                            "DELETE FROM stats WHERE "
                                            "origin_domain = ? "));
   s.BindString(0, domain.spec());
   return s.Run();
 }
 
+std::vector<InteractionsStats> StatisticsTable::GetAllRows() {
+  static constexpr char query[] =
+      "SELECT origin_domain, username_value, "
+      "dismissal_count, update_time FROM stats";
+  sql::Statement s(db_->GetCachedStatement(SQL_FROM_HERE, query));
+  return StatementToInteractionsStats(&s);
+}
+
 std::vector<InteractionsStats> StatisticsTable::GetRows(const GURL& domain) {
   if (!domain.is_valid())
     return std::vector<InteractionsStats>();
   const char query[] =
       "SELECT origin_domain, username_value, "
       "dismissal_count, update_time FROM stats WHERE origin_domain == ?";
   sql::Statement s(db_->GetCachedStatement(SQL_FROM_HERE, query));
   s.BindString(0, domain.spec());
-  std::vector<InteractionsStats> result;
-  while (s.Step()) {
-    result.push_back(InteractionsStats());
-    result.back().origin_domain = GURL(s.ColumnString(COLUMN_ORIGIN_DOMAIN));
-    result.back().username_value = s.ColumnString16(COLUMN_USERNAME);
-    result.back().dismissal_count = s.ColumnInt(COLUMN_DISMISSALS);
-    result.back().update_time =
-        base::Time::FromInternalValue(s.ColumnInt64(COLUMN_DATE));
-  }
-  return result;
+  return StatementToInteractionsStats(&s);
 }
 
 bool StatisticsTable::RemoveStatsByOriginAndTime(
     const base::Callback<bool(const GURL&)>& origin_filter,
     base::Time delete_begin,
     base::Time delete_end) {
   if (delete_end.is_null())
     delete_end = base::Time::Max();
 
   // All origins.
@@ skipping 33 matching lines @@
     origin_delete_statement.BindString(0, origin);
     origin_delete_statement.BindInt64(1, delete_begin.ToInternalValue());
     origin_delete_statement.BindInt64(2, delete_end.ToInternalValue());
     success = success && origin_delete_statement.Run();
   }
 
   return success;
 }
 
 }  // namespace password_manager