Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(261)

Side by Side Diff: components/history/core/browser/history_database.cc

Issue 2665243003: add a download slices table into history download db (Closed)
Patch Set: use Select changes() instead of select count(*) Created 3 years, 10 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View unified diff | Download patch
OLDNEW
1 // Copyright (c) 2012 The Chromium Authors. All rights reserved. 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 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 "components/history/core/browser/history_database.h" 5 #include "components/history/core/browser/history_database.h"
6 6
7 #include <stdint.h> 7 #include <stdint.h>
8 8
9 #include <algorithm> 9 #include <algorithm>
10 #include <set> 10 #include <set>
(...skipping 18 matching lines...) Expand all
29 #include "base/mac/mac_util.h" 29 #include "base/mac/mac_util.h"
30 #endif 30 #endif
31 31
32 namespace history { 32 namespace history {
33 33
34 namespace { 34 namespace {
35 35
36 // Current version number. We write databases at the "current" version number, 36 // Current version number. We write databases at the "current" version number,
37 // but any previous version that can read the "compatible" one can make do with 37 // but any previous version that can read the "compatible" one can make do with
38 // our database without *too* many bad effects. 38 // our database without *too* many bad effects.
39 const int kCurrentVersionNumber = 32; 39 const int kCurrentVersionNumber = 33;
40 const int kCompatibleVersionNumber = 16; 40 const int kCompatibleVersionNumber = 16;
41 const char kEarlyExpirationThresholdKey[] = "early_expiration_threshold"; 41 const char kEarlyExpirationThresholdKey[] = "early_expiration_threshold";
42 const int kMaxHostsInMemory = 10000; 42 const int kMaxHostsInMemory = 10000;
43 43
44 } // namespace 44 } // namespace
45 45
46 HistoryDatabase::HistoryDatabase( 46 HistoryDatabase::HistoryDatabase(
47 DownloadInterruptReason download_interrupt_reason_none, 47 DownloadInterruptReason download_interrupt_reason_none,
48 DownloadInterruptReason download_interrupt_reason_crash) 48 DownloadInterruptReason download_interrupt_reason_crash)
49 : DownloadDatabase(download_interrupt_reason_none, 49 : DownloadDatabase(download_interrupt_reason_none,
(...skipping 479 matching lines...) Expand 10 before | Expand all | Expand 10 after
529 529
530 if (cur_version == 31) { 530 if (cur_version == 31) {
531 if (!MigrateDownloadSiteInstanceUrl()) { 531 if (!MigrateDownloadSiteInstanceUrl()) {
532 LOG(WARNING) << "Unable to migrate history to version 32"; 532 LOG(WARNING) << "Unable to migrate history to version 32";
533 return sql::INIT_FAILURE; 533 return sql::INIT_FAILURE;
534 } 534 }
535 cur_version++; 535 cur_version++;
536 meta_table_.SetVersionNumber(cur_version); 536 meta_table_.SetVersionNumber(cur_version);
537 } 537 }
538 538
539 if (cur_version == 32) {
540 // New download jobs table is introduced, no migration needed.
541 cur_version++;
542 meta_table_.SetVersionNumber(cur_version);
543 }
Scott Hess - ex-Googler 2017/02/06 21:22:16 maintain the whitespace line between clauses.
qinmin 2017/02/06 23:39:22 Done.
539 // When the version is too old, we just try to continue anyway, there should 544 // When the version is too old, we just try to continue anyway, there should
540 // not be a released product that makes a database too old for us to handle. 545 // not be a released product that makes a database too old for us to handle.
541 LOG_IF(WARNING, cur_version < GetCurrentVersion()) << 546 LOG_IF(WARNING, cur_version < GetCurrentVersion()) <<
542 "History database version " << cur_version << " is too old to handle."; 547 "History database version " << cur_version << " is too old to handle.";
543 548
544 return sql::INIT_OK; 549 return sql::INIT_OK;
545 } 550 }
546 551
547 #if !defined(OS_WIN) 552 #if !defined(OS_WIN)
548 void HistoryDatabase::MigrateTimeEpoch() { 553 void HistoryDatabase::MigrateTimeEpoch() {
549 // Update all the times in the URLs and visits table in the main database. 554 // Update all the times in the URLs and visits table in the main database.
550 ignore_result(db_.Execute( 555 ignore_result(db_.Execute(
551 "UPDATE urls " 556 "UPDATE urls "
552 "SET last_visit_time = last_visit_time + 11644473600000000 " 557 "SET last_visit_time = last_visit_time + 11644473600000000 "
553 "WHERE id IN (SELECT id FROM urls WHERE last_visit_time > 0);")); 558 "WHERE id IN (SELECT id FROM urls WHERE last_visit_time > 0);"));
554 ignore_result(db_.Execute( 559 ignore_result(db_.Execute(
555 "UPDATE visits " 560 "UPDATE visits "
556 "SET visit_time = visit_time + 11644473600000000 " 561 "SET visit_time = visit_time + 11644473600000000 "
557 "WHERE id IN (SELECT id FROM visits WHERE visit_time > 0);")); 562 "WHERE id IN (SELECT id FROM visits WHERE visit_time > 0);"));
558 ignore_result(db_.Execute( 563 ignore_result(db_.Execute(
559 "UPDATE segment_usage " 564 "UPDATE segment_usage "
560 "SET time_slot = time_slot + 11644473600000000 " 565 "SET time_slot = time_slot + 11644473600000000 "
561 "WHERE id IN (SELECT id FROM segment_usage WHERE time_slot > 0);")); 566 "WHERE id IN (SELECT id FROM segment_usage WHERE time_slot > 0);"));
562 } 567 }
563 #endif 568 #endif
564 569
565 } // namespace history 570 } // namespace history
OLDNEW

Powered by Google App Engine
This is Rietveld 408576698