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