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
104
105
106
107
108
109
110
111
112
113
114
115
116
|
// Copyright (c) 2012 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 "base/file_path.h"
#include "base/file_util.h"
#include "base/scoped_temp_dir.h"
#include "base/utf_string_conversions.h"
#include "chrome/browser/history/android/android_cache_database.h"
#include "chrome/browser/history/android/android_time.h"
#include "chrome/browser/history/history_database.h"
#include "chrome/test/base/testing_profile.h"
#include "testing/gtest/include/gtest/gtest.h"
using base::Time;
using base::TimeDelta;
namespace history {
class AndroidCacheDatabaseTest : public testing::Test {
public:
AndroidCacheDatabaseTest() {
}
~AndroidCacheDatabaseTest() {
}
protected:
virtual void SetUp() {
// Get a temporary directory for the test DB files.
ASSERT_TRUE(temp_dir_.CreateUniqueTempDir());
FilePath history_db_name_ = temp_dir_.path().AppendASCII("history.db");
android_cache_db_name_ = temp_dir_.path().AppendASCII(
"TestAndroidCache.db");
ASSERT_EQ(sql::INIT_OK, history_db_.Init(history_db_name_,
temp_dir_.path()));
ASSERT_EQ(sql::INIT_OK,
history_db_.InitAndroidCacheDatabase(android_cache_db_name_));
}
ScopedTempDir temp_dir_;
FilePath android_cache_db_name_;
HistoryDatabase history_db_;
};
TEST(AndroidCacheDatabaseAttachTest, AttachDatabaseInTransactionNesting) {
ScopedTempDir temp_dir;
FilePath android_cache_db_name;
HistoryDatabase history_db;
ASSERT_TRUE(temp_dir.CreateUniqueTempDir());
FilePath history_db_name = temp_dir.path().AppendASCII("history.db");
android_cache_db_name = temp_dir.path().AppendASCII(
"TestAndroidCache.db");
ASSERT_EQ(sql::INIT_OK, history_db.Init(history_db_name, temp_dir.path()));
// Create nested transactions.
history_db.BeginTransaction();
history_db.BeginTransaction();
history_db.BeginTransaction();
int transaction_nesting = history_db.transaction_nesting();
ASSERT_EQ(sql::INIT_OK,
history_db.InitAndroidCacheDatabase(android_cache_db_name));
// The count of nested transaction is still same.
EXPECT_EQ(transaction_nesting, history_db.transaction_nesting());
}
TEST_F(AndroidCacheDatabaseTest, InitAndroidCacheDatabase) {
// Try to run a sql against the table to verify them exist.
AndroidCacheDatabase* cache_db =
static_cast<AndroidCacheDatabase*>(&history_db_);
EXPECT_TRUE(cache_db->GetDB().Execute(
"DELETE FROM android_cache_db.bookmark_cache"));
EXPECT_TRUE(cache_db->GetDB().Execute(
"DELETE FROM android_cache_db.search_terms"));
}
TEST_F(AndroidCacheDatabaseTest, SearchTermsTable) {
// Test AddSearchTerm.
Time search_time1 = Time::Now() - TimeDelta::FromDays(1);
string16 search_term1(UTF8ToUTF16("search term 1"));
SearchTermID id1 = history_db_.AddSearchTerm(search_term1, search_time1);
ASSERT_TRUE(id1);
SearchTermRow row1;
ASSERT_EQ(id1, history_db_.GetSearchTerm(search_term1, &row1));
EXPECT_EQ(search_term1, row1.term);
EXPECT_EQ(ToDatabaseTime(search_time1),
ToDatabaseTime(row1.last_visit_time));
EXPECT_EQ(id1, row1.id);
// Test UpdateSearchTerm.
SearchTermRow update_row1;
update_row1.term = (UTF8ToUTF16("update search term1"));
update_row1.last_visit_time = Time::Now();
ASSERT_TRUE(history_db_.UpdateSearchTerm(id1, update_row1));
EXPECT_EQ(id1, history_db_.GetSearchTerm(update_row1.term, &row1));
EXPECT_EQ(update_row1.term, row1.term);
EXPECT_EQ(ToDatabaseTime(update_row1.last_visit_time),
ToDatabaseTime(row1.last_visit_time));
EXPECT_EQ(id1, row1.id);
Time search_time2 = Time::Now() - TimeDelta::FromHours(1);
string16 search_term2(UTF8ToUTF16("search term 2"));
SearchTermID id2 = history_db_.AddSearchTerm(search_term2, search_time2);
ASSERT_TRUE(id2);
ASSERT_TRUE(history_db_.SetKeywordSearchTermsForURL(1, 1, search_term2));
ASSERT_TRUE(history_db_.DeleteUnusedSearchTerms());
// The search_term1 was removed.
EXPECT_FALSE(history_db_.GetSearchTerm(update_row1.term, NULL));
// The search_term2 should still in the table.
ASSERT_EQ(id2, history_db_.GetSearchTerm(search_term2, &row1));
EXPECT_EQ(id2, row1.id);
EXPECT_EQ(ToDatabaseTime(search_time2),
ToDatabaseTime(row1.last_visit_time));
EXPECT_EQ(search_term2, row1.term);
}
} // namespace history
|
