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 |