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
|
/* -*- 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 jan11_800 = (beginTime + (DAY_MSEC * 5)) * 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 jan5_800 = (beginTime - DAY_MSEC) * 1000;
var dec27_800 = (beginTime - (DAY_MSEC * 10)) * 1000;
var jan15_2145 = (endTime + (MIN_MSEC * 15)) * 1000;
var jan16_2130 = (endTime + (DAY_MSEC)) * 1000;
var jan25_2130 = (endTime + (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)
*/
function run_test()
{
run_next_test();
}
add_task(function* test_abstime_annotation_uri()
{
// Initialize database
yield 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.
do_print("change title");
var change1 = [{isDetails: true, uri:"http://foo.com/",
title: "mo"}, ];
yield task_populateDB(change1);
do_check_false(isInResult({uri: "http://foo.com/"}, root));
var change2 = [{isDetails: true, uri:"http://foo.com/",
title: "moz", lastvisit: endTime}, ];
yield task_populateDB(change2);
dump_table("moz_places");
do_check_false(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"}];
yield task_populateDB(change3);
do_print("LiveUpdate by removing annotation");
do_check_false(isInResult({uri: "http://foo.com/"}, root));
root.containerOpen = false;
});
|
