| 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/web_intents_table.h" | 5 #include "chrome/browser/webdata/web_intents_table.h" |
| 6 | 6 |
| 7 #include "base/logging.h" | 7 #include "base/logging.h" |
| 8 #include "googleurl/src/gurl.h" | 8 #include "googleurl/src/gurl.h" |
| 9 #include "sql/statement.h" | 9 #include "sql/statement.h" |
| 10 | 10 |
| 11 WebIntentsTable::WebIntentsTable(sql::Connection* db, | 11 WebIntentsTable::WebIntentsTable(sql::Connection* db, |
| 12 sql::MetaTable* meta_table) | 12 sql::MetaTable* meta_table) |
| 13 : WebDatabaseTable(db, meta_table) { | 13 : WebDatabaseTable(db, meta_table) { |
| 14 } | 14 } |
| 15 | 15 |
| 16 WebIntentsTable::~WebIntentsTable() { | 16 WebIntentsTable::~WebIntentsTable() { |
| 17 } | 17 } |
| 18 | 18 |
| 19 bool WebIntentsTable::Init() { | 19 bool WebIntentsTable::Init() { |
| 20 if (db_->DoesTableExist("web_intents")) | 20 if (db_->DoesTableExist("web_intents")) |
| 21 return true; | 21 return true; |
| 22 | 22 |
| 23 if (!db_->Execute("CREATE TABLE web_intents (" | 23 if (!db_->Execute("CREATE TABLE web_intents (" |
| 24 "service_url LONGVARCHAR," | 24 "service_url LONGVARCHAR," |
| 25 "action VARCHAR," | 25 "action VARCHAR," |
| 26 "type VARCHAR," | 26 "type VARCHAR," |
| 27 "title VARCHAR," |
| 27 "UNIQUE (service_url, action, type))")) { | 28 "UNIQUE (service_url, action, type))")) { |
| 28 NOTREACHED(); | 29 NOTREACHED(); |
| 29 return false; | 30 return false; |
| 30 } | 31 } |
| 31 | 32 |
| 32 if (!db_->Execute("CREATE INDEX web_intents_index " | 33 if (!db_->Execute("CREATE INDEX web_intents_index " |
| 33 "ON web_intents (action)")) { | 34 "ON web_intents (action)")) { |
| 34 NOTREACHED(); | 35 NOTREACHED(); |
| 35 return false; | 36 return false; |
| 36 } | 37 } |
| (...skipping 24 matching lines...) Expand all Loading... |
| 61 intent.service_url = GURL(tmp); | 62 intent.service_url = GURL(tmp); |
| 62 | 63 |
| 63 intent.action = s.ColumnString16(1); | 64 intent.action = s.ColumnString16(1); |
| 64 intent.type = s.ColumnString16(2); | 65 intent.type = s.ColumnString16(2); |
| 65 | 66 |
| 66 intents->push_back(intent); | 67 intents->push_back(intent); |
| 67 } | 68 } |
| 68 return true; | 69 return true; |
| 69 } | 70 } |
| 70 | 71 |
| 71 bool WebIntentsTable::SetWebIntent(const string16& action, | 72 bool WebIntentsTable::SetWebIntent(const WebIntentData& intent) { |
| 72 const string16& type, | |
| 73 const GURL& service_url) { | |
| 74 sql::Statement s(db_->GetUniqueStatement( | 73 sql::Statement s(db_->GetUniqueStatement( |
| 75 "INSERT OR REPLACE INTO web_intents (service_url, type, action) " | 74 "INSERT OR REPLACE INTO web_intents (service_url, type, action, title) " |
| 76 "VALUES (?, ?, ?)")); | 75 "VALUES (?, ?, ?, ?)")); |
| 77 if (!s) { | 76 if (!s) { |
| 78 NOTREACHED() << "Statement prepare failed"; | 77 NOTREACHED() << "Statement prepare failed"; |
| 79 return false; | 78 return false; |
| 80 } | 79 } |
| 81 | 80 |
| 82 s.BindString(0, service_url.spec()); | 81 s.BindString(0, intent.service_url.spec()); |
| 83 s.BindString16(1, type); | 82 s.BindString16(1, intent.type); |
| 84 s.BindString16(2, action); | 83 s.BindString16(2, intent.action); |
| 84 s.BindString16(3, intent.title); |
| 85 return s.Run(); | 85 return s.Run(); |
| 86 } | 86 } |
| 87 | 87 |
| 88 bool WebIntentsTable::RemoveWebIntent(const string16& action, | 88 // TODO(jhawkins): Investigate the need to remove rows matching only |
| 89 const string16& type, | 89 // |intent.service_url|. It's unlikely the user will be given the ability to |
| 90 const GURL& service_url) { | 90 // remove at the granularity of actions or types. |
| 91 bool WebIntentsTable::RemoveWebIntent(const WebIntentData& intent) { |
| 91 sql::Statement delete_s(db_->GetUniqueStatement( | 92 sql::Statement delete_s(db_->GetUniqueStatement( |
| 92 "DELETE FROM web_intents " | 93 "DELETE FROM web_intents " |
| 93 "WHERE service_url = ? AND action = ? AND type = ?")); | 94 "WHERE service_url = ? AND action = ? AND type = ?")); |
| 94 if (!delete_s) { | 95 if (!delete_s) { |
| 95 NOTREACHED() << "Statement prepare failed"; | 96 NOTREACHED() << "Statement prepare failed"; |
| 96 return false; | 97 return false; |
| 97 } | 98 } |
| 98 | 99 |
| 99 delete_s.BindString(0, service_url.spec()); | 100 delete_s.BindString(0, intent.service_url.spec()); |
| 100 delete_s.BindString16(1, action); | 101 delete_s.BindString16(1, intent.action); |
| 101 delete_s.BindString16(2, type); | 102 delete_s.BindString16(2, intent.type); |
| 102 return delete_s.Run(); | 103 return delete_s.Run(); |
| 103 } | 104 } |
| 104 | 105 |
| OLD | NEW |