1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
|
// Copyright (c) 2006-2008 The Chromium Authors. All rights reserved.
// Use of this source code is governed by a BSD-style license that can be
// found in the LICENSE file.
#include "chrome/browser/history/in_memory_database.h"
#include "base/logging.h"
#include "base/string_util.h"
namespace history {
InMemoryDatabase::InMemoryDatabase() : URLDatabase(), db_(NULL) {
}
InMemoryDatabase::~InMemoryDatabase() {
}
bool InMemoryDatabase::InitDB() {
DCHECK(!db_) << "Already initialized!";
if (sqlite3_open(":memory:", &db_) != SQLITE_OK) {
NOTREACHED() << "Cannot open memory database";
return false;
}
statement_cache_ = new SqliteStatementCache(db_);
DBCloseScoper scoper(&db_, &statement_cache_); // closes the DB on error
// No reason to leave data behind in memory when rows are removed.
sqlite3_exec(db_, "PRAGMA auto_vacuum=1", NULL, NULL, NULL);
// Set the database page size to 4K for better performance.
sqlite3_exec(db_, "PRAGMA page_size=4096", NULL, NULL, NULL);
// Ensure this is really an in-memory-only cache.
sqlite3_exec(db_, "PRAGMA temp_store=MEMORY", NULL, NULL, NULL);
// Create the URL table, but leave it empty for now.
if (!CreateURLTable(false)) {
NOTREACHED() << "Unable to create table";
return false;
}
// Succeeded, keep the DB open.
scoper.Detach();
db_closer_.Attach(&db_, &statement_cache_);
return true;
}
bool InMemoryDatabase::InitFromScratch() {
if (!InitDB())
return false;
// InitDB doesn't create the index so in the disk-loading case, it can be
// added afterwards.
CreateMainURLIndex();
return true;
}
bool InMemoryDatabase::InitFromDisk(const std::wstring& history_name) {
if (!InitDB())
return false;
// Attach to the history database on disk. (We can't ATTACH in the middle of
// a transaction.)
SQLStatement attach;
if (attach.prepare(db_, "ATTACH ? AS history") != SQLITE_OK) {
NOTREACHED() << "Unable to attach to history database.";
return false;
}
attach.bind_string(0, WideToUTF8(history_name));
if (attach.step() != SQLITE_DONE) {
NOTREACHED() << "Unable to bind";
return false;
}
// Copy URL data to memory.
if (sqlite3_exec(db_,
"INSERT INTO urls SELECT * FROM history.urls WHERE typed_count > 0",
NULL, NULL, NULL) != SQLITE_OK) {
// Unable to get data from the history database. This is OK, the file may
// just not exist yet.
}
// Detach from the history database on disk.
if (sqlite3_exec(db_, "DETACH history", NULL, NULL, NULL) != SQLITE_OK) {
NOTREACHED() << "Unable to detach from history database.";
return false;
}
// Index the table, this is faster than creating the index first and then
// inserting into it.
CreateMainURLIndex();
return true;
}
sqlite3* InMemoryDatabase::GetDB() {
return db_;
}
SqliteStatementCache& InMemoryDatabase::GetStatementCache() {
return *statement_cache_;
}
} // namespace history
|
