[Password Manager] Add UMA statistics for PasswordForm::ssl_valid usage

components/password_manager/core/browser/login_database.cc

 // Copyright 2014 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/login_database.h"
 
 #include <algorithm>
 #include <limits>
 
 #include "base/bind.h"
 #include "base/files/file_path.h"
 #include "base/logging.h"
 #include "base/metrics/histogram_macros.h"
 #include "base/pickle.h"
 #include "base/strings/string_util.h"
 #include "base/strings/stringprintf.h"
 #include "base/time/time.h"
 #include "components/autofill/core/common/password_form.h"
 #include "components/password_manager/core/browser/affiliation_utils.h"
 #include "components/password_manager/core/browser/password_manager_client.h"
 #include "components/password_manager/core/browser/password_manager_metrics_util.h"
 #include "google_apis/gaia/gaia_auth_util.h"
 #include "google_apis/gaia/gaia_urls.h"
 #include "sql/connection.h"
 #include "sql/statement.h"
 #include "sql/transaction.h"
+#include "url/url_constants.h"
 
 using autofill::PasswordForm;
 
 namespace password_manager {
 
 const int kCurrentVersionNumber = 13;
 static const int kCompatibleVersionNumber = 1;
 
 base::Pickle SerializeVector(const std::vector<base::string16>& vec) {
   base::Pickle p;
@@ skipping 483 matching lines @@
                      "WHERE a.blacklisted_by_user=0 AND a.username_value='' "
                      "AND NOT EXISTS (SELECT * FROM logins b "
                      "WHERE b.blacklisted_by_user=0 AND b.username_value!='' "
                      "AND a.signon_realm = b.signon_realm)"));
   if (standalone_empty_usernames_statement.Step()) {
     int num_entries = standalone_empty_usernames_statement.ColumnInt(0);
     UMA_HISTOGRAM_COUNTS_100(
         "PasswordManager.EmptyUsernames.WithoutCorrespondingNonempty",
         num_entries);
   }
+
+  sql::Statement invalid_ssl_cert_statement(db_.GetCachedStatement(
+      SQL_FROM_HERE, "SELECT origin_url, ssl_valid FROM logins;"));
+
+  if (!invalid_ssl_cert_statement.is_valid())
+    return;
+
+  while (invalid_ssl_cert_statement.Step()) {
+    GURL url = GURL(invalid_ssl_cert_statement.ColumnString(0));
+
+    if (url.SchemeIs(url::kHttpsScheme)) {
+      metrics_util::LogUMAHistogramBoolean(
+          "PasswordManager.UserStoredPasswordWithInvalidSSLCert",
+          invalid_ssl_cert_statement.ColumnInt(1) == 0);
+    }
+  }
 }
 
 PasswordStoreChangeList LoginDatabase::AddLogin(const PasswordForm& form) {
   PasswordStoreChangeList list;
   if (!DoesMatchConstraints(form))
     return list;
   std::string encrypted_password;
   if (EncryptedString(
           clear_password_values_ ? base::string16() : form.password_value,
           &encrypted_password) != ENCRYPTION_RESULT_SUCCESS)
@@ skipping 417 matching lines @@
     UMA_HISTOGRAM_ENUMERATION("PasswordManager.PslDomainMatchTriggering",
                               psl_domain_match_metric, PSL_DOMAIN_MATCH_COUNT);
   }
 
   if (!statement->Succeeded())
     return false;
   return true;
 }
 
 }  // namespace password_manager