Lines Matching full:time
26 // different words in the index for each time number.
34 // time Time the corresponding FTS entry was visited.
191 // Note that there is no point in creating an index over time. Since
195 if (!db_.Execute("CREATE TABLE info(time INTEGER NOT NULL)"))
201 db_.Execute("CREATE INDEX info_time ON info(time)");
205 bool TextDatabase::AddPageData(base::Time time,
232 "INSERT INTO info (rowid, time) VALUES (?,?)"));
238 add_to_info.BindInt64(1, time.ToInternalValue());
247 void TextDatabase::DeletePageData(base::Time time, const std::string& url) {
248 // First get all rows that match. Selecing on time (which has an index) allows
250 // generally be only one match per time).
254 "WHERE info.time=? AND pages.url=?"));
257 select_ids.BindInt64(0, time.ToInternalValue());
306 base::Time* first_time_searched) {
310 "SELECT url, title, time, offsets(pages), body "
312 "WHERE pages MATCH ? AND time >= ? AND time < ? "
313 "ORDER BY time DESC "
348 match.time = base::Time::FromInternalValue(statement.ColumnInt64(2));
368 // are none), then we have searched all the time requested, so we can
376 // time we considered.
377 *first_time_searched = results->back().time;