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
|
/* Any copyright is dedicated to the Public Domain.
http://creativecommons.org/publicdomain/zero/1.0/ */
// Tests that recalc_frecency in the moz_origins table works is consistent.
add_task(async function test() {
// test recalc_frecency is set to 1 when frecency of a page changes.
// Add a couple visits, then remove one of them.
const now = new Date();
const host = "mozilla.org";
const url = `https://${host}/test/`;
await PlacesTestUtils.addVisits([
{
url,
visitDate: now,
},
{
url,
visitDate: new Date(new Date().setDate(now.getDate() - 30)),
},
]);
Assert.equal(
await PlacesTestUtils.getDatabaseValue("moz_origins", "recalc_frecency", {
host,
}),
1,
"Frecency should be calculated"
);
Assert.equal(
await PlacesTestUtils.getDatabaseValue(
"moz_origins",
"recalc_alt_frecency",
{
host,
}
),
1,
"Alt frecency should be calculated"
);
await PlacesFrecencyRecalculator.recalculateAnyOutdatedFrecencies();
let alt_frecency = await PlacesTestUtils.getDatabaseValue(
"moz_origins",
"alt_frecency",
{ host }
);
let frecency = await PlacesTestUtils.getDatabaseValue(
"moz_origins",
"frecency",
{ host }
);
// Remove only one visit (otherwise the page would be orphaned).
await PlacesUtils.history.removeVisitsByFilter({
beginDate: new Date(now.valueOf() - 10000),
endDate: new Date(now.valueOf() + 10000),
});
await PlacesFrecencyRecalculator.recalculateAnyOutdatedFrecencies();
Assert.equal(
await PlacesTestUtils.getDatabaseValue("moz_origins", "recalc_frecency", {
host,
}),
0,
"Should have been calculated"
);
Assert.greater(
frecency,
await PlacesTestUtils.getDatabaseValue("moz_origins", "frecency", {
host,
}),
"frecency should have decreased"
);
Assert.equal(
await PlacesTestUtils.getDatabaseValue(
"moz_origins",
"recalc_alt_frecency",
{ host }
),
0,
"Should have been calculated"
);
Assert.greater(
alt_frecency,
await PlacesTestUtils.getDatabaseValue("moz_origins", "alt_frecency", {
host,
}),
"alternative frecency should have decreased"
);
// Add another page to the same host.
const url2 = `https://${host}/second/`;
await PlacesTestUtils.addVisits(url2);
// Remove the first page.
await PlacesUtils.history.remove(url);
Assert.equal(
await PlacesTestUtils.getDatabaseValue("moz_origins", "recalc_frecency", {
host,
}),
1,
"Frecency should be calculated"
);
Assert.equal(
await PlacesTestUtils.getDatabaseValue(
"moz_origins",
"recalc_alt_frecency",
{ host }
),
1,
"Alt frecency should be calculated"
);
});
|