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
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
|
/* -*- indent-tabs-mode: nil; js-indent-level: 2 -*- */
/* vim:set ts=2 sw=2 sts=2 et: */
/* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/. */
const DAY_MSEC = 86400000;
const MIN_MSEC = 60000;
const HOUR_MSEC = 3600000;
// Jan 6 2008 at 8am is our begin edge of the query
var beginTimeDate = new Date(2008, 0, 6, 8, 0, 0, 0);
// Jan 15 2008 at 9:30pm is our ending edge of the query
var endTimeDate = new Date(2008, 0, 15, 21, 30, 0, 0);
// These as millisecond values
var beginTime = beginTimeDate.getTime();
var endTime = endTimeDate.getTime();
// Some range dates inside our query - mult by 1000 to convert to PRTIME
var jan7_800 = (beginTime + DAY_MSEC) * 1000;
var jan6_815 = (beginTime + MIN_MSEC * 15) * 1000;
var jan14_2130 = (endTime - DAY_MSEC) * 1000;
var jan15_2045 = (endTime - MIN_MSEC * 45) * 1000;
var jan12_1730 = (endTime - DAY_MSEC * 3 - HOUR_MSEC * 4) * 1000;
// Dates outside our query - mult by 1000 to convert to PRTIME
var jan6_700 = (beginTime - HOUR_MSEC) * 1000;
var dec27_800 = (beginTime - DAY_MSEC * 10) * 1000;
// So that we can easily use these too, convert them to PRTIME
beginTime *= 1000;
endTime *= 1000;
/**
* Array of objects to build our test database
*/
var goodAnnoName = "moz-test-places/testing123";
var val = "test";
var badAnnoName = "text/foo";
// The test data for our database, note that the ordering of the results that
// will be returned by the query (the isInQuery: true objects) is IMPORTANT.
// see compareArrayToResult in head_queries.js for more info.
var testData = [
// Test flat domain with annotation
{
isInQuery: true,
isVisit: true,
isDetails: true,
isPageAnnotation: true,
uri: "http://foo.com/",
annoName: goodAnnoName,
annoVal: val,
lastVisit: jan14_2130,
title: "moz",
},
// Begin the invalid queries:
// Test www. style URI is not included, with an annotation
{
isInQuery: false,
isVisit: true,
isDetails: true,
isPageAnnotation: true,
uri: "http://www.foo.com/yiihah",
annoName: goodAnnoName,
annoVal: val,
lastVisit: jan7_800,
title: "moz",
},
// Test subdomain not inclued at the leading time edge
{
isInQuery: false,
isVisit: true,
isDetails: true,
uri: "http://mail.foo.com/yiihah",
title: "moz",
lastVisit: jan6_815,
},
// Test https protocol
{
isInQuery: false,
isVisit: true,
isDetails: true,
title: "moz",
uri: "https://foo.com/",
lastVisit: jan15_2045,
},
// Test ftp protocol
{
isInQuery: false,
isVisit: true,
isDetails: true,
uri: "ftp://foo.com/ftp",
lastVisit: jan12_1730,
title: "hugelongconfmozlagurationofwordswithasearchtermsinit whoo-hoo",
},
// Test too early
{
isInQuery: false,
isVisit: true,
isDetails: true,
title: "moz",
uri: "http://foo.com/tooearly.php",
lastVisit: jan6_700,
},
// Test Bad Annotation
{
isInQuery: false,
isVisit: true,
isDetails: true,
isPageAnnotation: true,
title: "moz",
uri: "http://foo.com/badanno.htm",
lastVisit: jan12_1730,
annoName: badAnnoName,
annoVal: val,
},
// Test afterward, one to update
{
isInQuery: false,
isVisit: true,
isDetails: true,
title: "changeme",
uri: "http://foo.com/changeme1.htm",
lastVisit: jan12_1730,
},
// Test invalid title
{
isInQuery: false,
isVisit: true,
isDetails: true,
title: "changeme2",
uri: "http://foo.com/changeme2.htm",
lastVisit: jan7_800,
},
// Test changing the lastVisit
{
isInQuery: false,
isVisit: true,
isDetails: true,
title: "moz",
uri: "http://foo.com/changeme3.htm",
lastVisit: dec27_800,
},
];
/**
* This test will test a Query using several terms and do a bit of negative
* testing for items that should be ignored while querying over history.
* The Query:WHERE absoluteTime(matches) AND searchTerms AND URI
* AND annotationIsNot(match) GROUP BY Domain, Day SORT BY uri,ascending
* excludeITems(should be ignored)
*/
add_task(async function test_abstime_annotation_uri() {
// Initialize database
await task_populateDB(testData);
// Query
var query = PlacesUtils.history.getNewQuery();
query.beginTime = beginTime;
query.endTime = endTime;
query.beginTimeReference = PlacesUtils.history.TIME_RELATIVE_EPOCH;
query.endTimeReference = PlacesUtils.history.TIME_RELATIVE_EPOCH;
query.searchTerms = "moz";
query.uri = uri("http://foo.com");
query.annotation = "text/foo";
query.annotationIsNot = true;
// Options
var options = PlacesUtils.history.getNewQueryOptions();
options.sortingMode = options.SORT_BY_URI_ASCENDING;
options.resultType = options.RESULTS_AS_URI;
// The next two options should be ignored
// can't use this one, breaks test - bug 419779
// options.excludeItems = true;
// Results
var result = PlacesUtils.history.executeQuery(query, options);
var root = result.root;
root.containerOpen = true;
// Ensure the result set is correct
compareArrayToResult(testData, root);
// live update.
info("change title");
var change1 = [{ isDetails: true, uri: "http://foo.com/", title: "mo" }];
await task_populateDB(change1);
Assert.ok(!isInResult({ uri: "http://foo.com/" }, root));
var change2 = [
{
isDetails: true,
uri: "http://foo.com/",
title: "moz",
lastvisit: endTime,
},
];
await task_populateDB(change2);
dump_table("moz_places");
Assert.ok(!isInResult({ uri: "http://foo.com/" }, root));
// Let's delete something from the result set - using annotation
var change3 = [
{
isPageAnnotation: true,
uri: "http://foo.com/",
annoName: badAnnoName,
annoVal: "test",
},
];
await task_populateDB(change3);
info("LiveUpdate by removing annotation");
Assert.ok(!isInResult({ uri: "http://foo.com/" }, root));
root.containerOpen = false;
});
|
