OLD | NEW |
1 // Copyright (c) 2006-2008 The Chromium Authors. All rights reserved. | 1 // Copyright (c) 2006-2008 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/history/download_database.h" | 5 #include "chrome/browser/history/download_database.h" |
6 | 6 |
7 #include <limits> | 7 #include <limits> |
8 #include <vector> | 8 #include <vector> |
9 | 9 |
10 #include "chrome/browser/download/download_manager.h" | 10 #include "chrome/browser/download/download_manager.h" |
(...skipping 37 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
48 return false; | 48 return false; |
49 } | 49 } |
50 return true; | 50 return true; |
51 } | 51 } |
52 | 52 |
53 bool DownloadDatabase::DropDownloadTable() { | 53 bool DownloadDatabase::DropDownloadTable() { |
54 return sqlite3_exec(GetDB(), "DROP TABLE downloads", NULL, NULL, NULL) == | 54 return sqlite3_exec(GetDB(), "DROP TABLE downloads", NULL, NULL, NULL) == |
55 SQLITE_OK; | 55 SQLITE_OK; |
56 } | 56 } |
57 | 57 |
58 void DownloadDatabase::QueryDownloads(std::vector<DownloadCreateInfo>* results)
{ | 58 void DownloadDatabase::QueryDownloads( |
| 59 std::vector<DownloadCreateInfo>* results) { |
59 results->clear(); | 60 results->clear(); |
60 | 61 |
61 SQLITE_UNIQUE_STATEMENT(statement, GetStatementCache(), | 62 SQLITE_UNIQUE_STATEMENT(statement, GetStatementCache(), |
62 "SELECT id, full_path, url, start_time, received_bytes, " | 63 "SELECT id, full_path, url, start_time, received_bytes, " |
63 "total_bytes, state " | 64 "total_bytes, state " |
64 "FROM downloads " | 65 "FROM downloads " |
65 "ORDER BY start_time"); | 66 "ORDER BY start_time"); |
66 if (!statement.is_valid()) | 67 if (!statement.is_valid()) |
67 return; | 68 return; |
68 | 69 |
(...skipping 80 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
149 // downloads where an index by time will give us a lot of benefit. | 150 // downloads where an index by time will give us a lot of benefit. |
150 SQLITE_UNIQUE_STATEMENT(statement, GetStatementCache(), | 151 SQLITE_UNIQUE_STATEMENT(statement, GetStatementCache(), |
151 "DELETE FROM downloads WHERE start_time >= ? AND start_time < ? " | 152 "DELETE FROM downloads WHERE start_time >= ? AND start_time < ? " |
152 "AND (State = ? OR State = ?)"); | 153 "AND (State = ? OR State = ?)"); |
153 if (!statement.is_valid()) | 154 if (!statement.is_valid()) |
154 return; | 155 return; |
155 | 156 |
156 time_t start_time = delete_begin.ToTimeT(); | 157 time_t start_time = delete_begin.ToTimeT(); |
157 time_t end_time = delete_end.ToTimeT(); | 158 time_t end_time = delete_end.ToTimeT(); |
158 statement->bind_int64(0, start_time); | 159 statement->bind_int64(0, start_time); |
159 statement->bind_int64(1, end_time ? end_time : std::numeric_limits<int64>::max
()); | 160 statement->bind_int64( |
| 161 1, |
| 162 end_time ? end_time : std::numeric_limits<int64>::max()); |
160 statement->bind_int(2, DownloadItem::COMPLETE); | 163 statement->bind_int(2, DownloadItem::COMPLETE); |
161 statement->bind_int(3, DownloadItem::CANCELLED); | 164 statement->bind_int(3, DownloadItem::CANCELLED); |
162 statement->step(); | 165 statement->step(); |
163 } | 166 } |
164 | 167 |
165 void DownloadDatabase::SearchDownloads(std::vector<int64>* results, | 168 void DownloadDatabase::SearchDownloads(std::vector<int64>* results, |
166 const std::wstring& search_text) { | 169 const std::wstring& search_text) { |
167 SQLITE_UNIQUE_STATEMENT(statement, GetStatementCache(), | 170 SQLITE_UNIQUE_STATEMENT(statement, GetStatementCache(), |
168 "SELECT id FROM downloads WHERE url LIKE ? " | 171 "SELECT id FROM downloads WHERE url LIKE ? " |
169 "OR full_path LIKE ? ORDER BY id"); | 172 "OR full_path LIKE ? ORDER BY id"); |
170 if (!statement.is_valid()) | 173 if (!statement.is_valid()) |
171 return; | 174 return; |
172 | 175 |
173 std::wstring text(L"%"); | 176 std::wstring text(L"%"); |
174 text.append(search_text); | 177 text.append(search_text); |
175 text.append(L"%"); | 178 text.append(L"%"); |
176 statement->bind_wstring(0, text); | 179 statement->bind_wstring(0, text); |
177 statement->bind_wstring(1, text); | 180 statement->bind_wstring(1, text); |
178 | 181 |
179 while (statement->step() == SQLITE_ROW) | 182 while (statement->step() == SQLITE_ROW) |
180 results->push_back(statement->column_int64(0)); | 183 results->push_back(statement->column_int64(0)); |
181 } | 184 } |
182 | 185 |
183 } // namespace history | 186 } // namespace history |
OLD | NEW |