1// Copyright 2014 The Chromium Authors. All rights reserved. 2// Use of this source code is governed by a BSD-style license that can be 3// found in the LICENSE file. 4 5#include "components/password_manager/core/browser/webdata/logins_table.h" 6 7#include "base/logging.h" 8#include "base/strings/utf_string_conversions.h" 9#include "base/time/time.h" 10#include "components/os_crypt/ie7_password_win.h" 11#include "sql/statement.h" 12 13bool LoginsTable::AddIE7Login(const IE7PasswordInfo& info) { 14 sql::Statement s(db_->GetUniqueStatement( 15 "INSERT OR REPLACE INTO ie7_logins " 16 "(url_hash, password_value, date_created) " 17 "VALUES (?,?,?)")); 18 s.BindString(0, base::WideToUTF8(info.url_hash)); 19 s.BindBlob(1, &info.encrypted_data.front(), 20 static_cast<int>(info.encrypted_data.size())); 21 s.BindInt64(2, info.date_created.ToTimeT()); 22 23 return s.Run(); 24} 25 26bool LoginsTable::RemoveIE7Login(const IE7PasswordInfo& info) { 27 // Remove a login by UNIQUE-constrained fields. 28 sql::Statement s(db_->GetUniqueStatement( 29 "DELETE FROM ie7_logins WHERE url_hash = ?")); 30 s.BindString(0, base::WideToUTF8(info.url_hash)); 31 32 return s.Run(); 33} 34 35bool LoginsTable::GetIE7Login(const IE7PasswordInfo& info, 36 IE7PasswordInfo* result) { 37 DCHECK(result); 38 sql::Statement s(db_->GetUniqueStatement( 39 "SELECT password_value, date_created FROM ie7_logins " 40 "WHERE url_hash == ? ")); 41 s.BindString16(0, info.url_hash); 42 43 if (s.Step()) { 44 s.ColumnBlobAsVector(0, &result->encrypted_data); 45 result->date_created = base::Time::FromTimeT(s.ColumnInt64(1)); 46 result->url_hash = info.url_hash; 47 } 48 return s.Succeeded(); 49} 50