Implement Password Manager aggregate metrics reporting

chrome/browser/password_manager/login_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/password_manager/login_database.h"
 
 #include <algorithm>
 #include <limits>
 
 #include "app/sql/statement.h"
 #include "app/sql/transaction.h"
 #include "base/file_path.h"
+#include "base/histogram.h"
 #include "base/logging.h"
 #include "base/time.h"
 #include "base/utf_string_conversions.h"
 #include "chrome/common/sqlite_utils.h"
 
 using webkit_glue::PasswordForm;
 
 static const int kCurrentVersionNumber = 1;
 static const int kCompatibleVersionNumber = 1;
 
@@ skipping 96 matching lines @@
     }
     if (!db_.Execute("CREATE INDEX logins_signon ON "
                      "logins (signon_realm)")) {
       NOTREACHED();
       return false;
     }
   }
   return true;
 }
 
+void LoginDatabase::ReportMetrics() {
+  sql::Statement s(db_.GetCachedStatement(SQL_FROM_HERE,
+      "SELECT signon_realm, COUNT(username_value) FROM logins "
+      "GROUP BY signon_realm"));
+  if (!s) {
+    NOTREACHED() << "Statement prepare failed";
+    return;
+  }
+
+  int total_accounts = 0;
+  while (s.Step()) {
+    int accounts_per_site = s.ColumnInt(1);
+    total_accounts += accounts_per_site;
+    UMA_HISTOGRAM_CUSTOM_COUNTS("PasswordManager.AccountsPerSite",
+                                accounts_per_site, 0, 32, 6);
+  }
+  UMA_HISTOGRAM_CUSTOM_COUNTS("PasswordManager.TotalAccounts",
+                              total_accounts, 0, 32, 6);
+
+  return;
+}
 
 bool LoginDatabase::AddLogin(const PasswordForm& form) {
   // You *must* change LoginTableColumns if this query changes.
   sql::Statement s(db_.GetCachedStatement(SQL_FROM_HERE,
       "INSERT OR REPLACE INTO logins "
       "(origin_url, action_url, username_element, username_value, "
       " password_element, password_value, submit_element, "
       " signon_realm, ssl_valid, preferred, date_created, "
       " blacklisted_by_user, scheme) "
       "VALUES "
@@ skipping 222 matching lines @@
   s.BindInt(0, blacklisted ? 1 : 0);
 
   while (s.Step()) {
     PasswordForm* new_form = new PasswordForm();
     InitPasswordFormFromStatement(new_form, s);
 
     forms->push_back(new_form);
   }
   return s.Succeeded();
 }