1 // Copyright (c) 2012 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.
5 #include "chrome/browser/history/android/android_cache_database.h"
7 #include "base/file_util.h"
8 #include "chrome/browser/history/android/android_time.h"
9 #include "sql/statement.h"
12 using base::TimeDelta;
16 AndroidCacheDatabase::AndroidCacheDatabase() {
19 AndroidCacheDatabase::~AndroidCacheDatabase() {
22 sql::InitStatus AndroidCacheDatabase::InitAndroidCacheDatabase(
23 const base::FilePath& db_name) {
24 if (!CreateDatabase(db_name))
25 return sql::INIT_FAILURE;
28 return sql::INIT_FAILURE;
30 if (!CreateBookmarkCacheTable())
31 return sql::INIT_FAILURE;
33 if (!CreateSearchTermsTable())
34 return sql::INIT_FAILURE;
39 bool AndroidCacheDatabase::AddBookmarkCacheRow(const Time& created_time,
40 const Time& last_visit_time,
42 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
43 "INSERT INTO android_cache_db.bookmark_cache (created_time, "
44 "last_visit_time, url_id) VALUES (?, ?, ?)"));
46 statement.BindInt64(0, ToDatabaseTime(created_time));
47 statement.BindInt64(1, ToDatabaseTime(last_visit_time));
48 statement.BindInt64(2, url_id);
50 if (!statement.Run()) {
51 LOG(ERROR) << GetDB().GetErrorMessage();
58 bool AndroidCacheDatabase::ClearAllBookmarkCache() {
59 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
60 "DELETE FROM android_cache_db.bookmark_cache"));
61 if (!statement.Run()) {
62 LOG(ERROR) << GetDB().GetErrorMessage();
68 bool AndroidCacheDatabase::MarkURLsAsBookmarked(
69 const std::vector<URLID>& url_ids) {
71 std::ostringstream oss;
72 for (std::vector<URLID>::const_iterator i = url_ids.begin();
73 i != url_ids.end(); ++i) {
84 std::string sql("UPDATE android_cache_db.bookmark_cache "
85 "SET bookmark = 1 WHERE url_id in (");
86 sql.append(oss.str());
88 if (!GetDB().Execute(sql.c_str())) {
89 LOG(ERROR) << GetDB().GetErrorMessage();
95 bool AndroidCacheDatabase::SetFaviconID(URLID url_id,
96 favicon_base::FaviconID favicon_id) {
97 sql::Statement update_statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
98 "UPDATE android_cache_db.bookmark_cache "
99 "SET favicon_id = ? WHERE url_id = ? "));
101 update_statement.BindInt64(0, favicon_id);
102 update_statement.BindInt64(1, url_id);
103 if (!update_statement.Run()) {
104 LOG(ERROR) << GetDB().GetErrorMessage();
110 SearchTermID AndroidCacheDatabase::AddSearchTerm(
111 const base::string16& term,
112 const base::Time& last_visit_time) {
113 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
114 "INSERT INTO android_cache_db.search_terms (search, "
115 "date) VALUES (?, ?)"));
117 statement.BindString16(0, term);
118 statement.BindInt64(1, ToDatabaseTime(last_visit_time));
120 if (!statement.Run()) {
121 LOG(ERROR) << GetDB().GetErrorMessage();
125 return GetDB().GetLastInsertRowId();
128 bool AndroidCacheDatabase::UpdateSearchTerm(SearchTermID id,
129 const SearchTermRow& row) {
130 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
131 "UPDATE android_cache_db.search_terms "
132 "SET search = ?, date = ? "
135 statement.BindString16(0, row.term);
136 statement.BindInt64(1, ToDatabaseTime(row.last_visit_time));
137 statement.BindInt64(2, id);
139 return statement.Run();
142 SearchTermID AndroidCacheDatabase::GetSearchTerm(const base::string16& term,
143 SearchTermRow* row) {
144 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
145 "SELECT _id, search, date "
146 "FROM android_cache_db.search_terms "
149 if (!statement.is_valid()) {
150 LOG(ERROR) << GetDB().GetErrorMessage();
153 statement.BindString16(0, term);
154 if (!statement.Step())
158 row->id = statement.ColumnInt64(0);
159 row->term = statement.ColumnString16(1);
160 row->last_visit_time = FromDatabaseTime(statement.ColumnInt64(2));
162 return statement.ColumnInt64(0);
165 bool AndroidCacheDatabase::DeleteUnusedSearchTerms() {
166 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
167 "DELETE FROM android_cache_db.search_terms "
168 "WHERE search NOT IN (SELECT DISTINCT term FROM keyword_search_terms)"
170 if (!statement.is_valid())
172 return statement.Run();
175 bool AndroidCacheDatabase::CreateDatabase(const base::FilePath& db_name) {
177 sql::Connection::Delete(db_name_);
179 // Using a new connection, otherwise we can not create the database.
180 sql::Connection connection;
182 // The db doesn't store too much data, so we don't need that big a page
184 connection.set_page_size(2048);
185 connection.set_cache_size(32);
187 // Run the database in exclusive mode. Nobody else should be accessing the
188 // database while we're running, and this will give somewhat improved perf.
189 connection.set_exclusive_locking();
191 if (!connection.Open(db_name_)) {
192 LOG(ERROR) << connection.GetErrorMessage();
199 bool AndroidCacheDatabase::CreateBookmarkCacheTable() {
200 const char* name = "android_cache_db.bookmark_cache";
201 DCHECK(!GetDB().DoesTableExist(name));
204 sql.append("CREATE TABLE ");
207 "id INTEGER PRIMARY KEY,"
208 "created_time INTEGER NOT NULL," // Time in millisecond.
209 "last_visit_time INTEGER NOT NULL," // Time in millisecond.
210 "url_id INTEGER NOT NULL," // url id in urls table.
211 "favicon_id INTEGER DEFAULT NULL," // favicon id.
212 "bookmark INTEGER DEFAULT 0" // whether is bookmark.
214 if (!GetDB().Execute(sql.c_str())) {
215 LOG(ERROR) << GetDB().GetErrorMessage();
219 sql.assign("CREATE INDEX ");
220 sql.append("android_cache_db.bookmark_cache_url_id_idx ON "
221 "bookmark_cache(url_id)");
222 if (!GetDB().Execute(sql.c_str())) {
223 LOG(ERROR) << GetDB().GetErrorMessage();
229 bool AndroidCacheDatabase::CreateSearchTermsTable() {
230 const char* name = "android_cache_db.search_terms";
232 // The table's column name matchs Android's definition.
234 sql.append("CREATE TABLE ");
237 "_id INTEGER PRIMARY KEY,"
238 "date INTEGER NOT NULL," // last visit time in millisecond.
239 "search LONGVARCHAR NOT NULL)"); // The actual search term.
241 if (!GetDB().Execute(sql.c_str())) {
242 LOG(ERROR) << GetDB().GetErrorMessage();
246 sql.assign("CREATE INDEX "
247 "android_cache_db.search_terms_term_idx ON "
248 "search_terms(search)");
249 if (!GetDB().Execute(sql.c_str())) {
250 LOG(ERROR) << GetDB().GetErrorMessage();
256 bool AndroidCacheDatabase::Attach() {
257 // Commit all open transactions to make attach succeed.
258 int transaction_nesting = GetDB().transaction_nesting();
259 int count = transaction_nesting;
261 GetDB().CommitTransaction();
263 bool result = DoAttach();
265 // No matter whether the attach succeeded or not, we need to create the
266 // transaction stack again.
267 count = transaction_nesting;
269 GetDB().BeginTransaction();
273 bool AndroidCacheDatabase::DoAttach() {
274 std::string sql("ATTACH ? AS android_cache_db");
275 sql::Statement attach(GetDB().GetUniqueStatement(sql.c_str()));
276 if (!attach.is_valid())
277 // Keep the transaction open, even though we failed.
280 attach.BindString(0, db_name_.value());
282 LOG(ERROR) << GetDB().GetErrorMessage();
289 } // namespace history