Source code
Revision control
Copy as Markdown
Other Tools
Test Info:
/* -*- 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
var mDBConn = DBConn();
add_task(async function test_history_clear() {
await PlacesTestUtils.addVisits([
{
transition: TRANSITION_DOWNLOAD,
},
{
transition: TRANSITION_REDIRECT_TEMPORARY,
},
{
transition: TRANSITION_REDIRECT_PERMANENT,
},
]);
// add a place: bookmark
await PlacesUtils.bookmarks.insert({
parentGuid: PlacesUtils.bookmarks.unfiledGuid,
url: `place:parent=${PlacesUtils.bookmarks.tagsGuid}`,
title: "shortcut",
});
// Add an expire never annotation
// Actually expire never annotations are removed as soon as a page is removed
// from the database, so this should act as a normal visit.
await PlacesUtils.history.update({
annotations: new Map([["never", "never"]]),
});
// Add a bookmark
// Bookmarked page should have history cleared and frecency to be recalculated
await PlacesUtils.bookmarks.insert({
parentGuid: PlacesUtils.bookmarks.unfiledGuid,
title: "bookmark",
});
await PlacesTestUtils.addVisits([
]);
await PlacesTestUtils.promiseAsyncUpdates();
// Clear history and wait for the history-cleared event notification.
let promiseClearHistory =
PlacesTestUtils.waitForNotification("history-cleared");
await PlacesUtils.history.clear();
await promiseClearHistory;
await PlacesTestUtils.promiseAsyncUpdates();
// Check that frecency for not cleared items (bookmarks) has been marked
// as to be recalculated.
let stmt = mDBConn.createStatement(
"SELECT h.id FROM moz_places h WHERE frecency <> 0 AND h.recalc_frecency = 0 "
);
Assert.ok(!stmt.executeStep());
stmt.finalize();
stmt = mDBConn.createStatement(
`SELECT h.id FROM moz_places h WHERE h.recalc_frecency = 1
AND EXISTS (SELECT id FROM moz_bookmarks WHERE fk = h.id) LIMIT 1`
);
Assert.ok(stmt.executeStep());
stmt.finalize();
// Check that all visit_counts have been brought to 0
stmt = mDBConn.createStatement(
"SELECT id FROM moz_places WHERE visit_count <> 0 LIMIT 1"
);
Assert.ok(!stmt.executeStep());
stmt.finalize();
// Check that history tables are empty
stmt = mDBConn.createStatement(
"SELECT * FROM (SELECT id FROM moz_historyvisits LIMIT 1)"
);
Assert.ok(!stmt.executeStep());
stmt.finalize();
// Check that all moz_places entries except bookmarks and place: have been removed
stmt = mDBConn.createStatement(
`SELECT h.id FROM moz_places h WHERE
url_hash NOT BETWEEN hash('place', 'prefix_lo') AND hash('place', 'prefix_hi')
AND NOT EXISTS (SELECT id FROM moz_bookmarks WHERE fk = h.id) LIMIT 1`
);
Assert.ok(!stmt.executeStep());
stmt.finalize();
// Check that we only have favicons for retained places
stmt = mDBConn.createStatement(
`SELECT 1
FROM moz_pages_w_icons
LEFT JOIN moz_places h ON url_hash = page_url_hash AND url = page_url
WHERE h.id ISNULL`
);
Assert.ok(!stmt.executeStep());
stmt.finalize();
stmt = mDBConn.createStatement(
`SELECT 1
FROM moz_icons WHERE id NOT IN (
SELECT icon_id FROM moz_icons_to_pages
)`
);
Assert.ok(!stmt.executeStep());
stmt.finalize();
// Check that we only have annotations for retained places
stmt = mDBConn.createStatement(
`SELECT a.id FROM moz_annos a WHERE NOT EXISTS
(SELECT id FROM moz_places WHERE id = a.place_id) LIMIT 1`
);
Assert.ok(!stmt.executeStep());
stmt.finalize();
// Check that we only have inputhistory for retained places
stmt = mDBConn.createStatement(
`SELECT i.place_id FROM moz_inputhistory i WHERE NOT EXISTS
(SELECT id FROM moz_places WHERE id = i.place_id) LIMIT 1`
);
Assert.ok(!stmt.executeStep());
stmt.finalize();
// Check that place:uris have frecency 0
stmt = mDBConn.createStatement(
`SELECT h.id FROM moz_places h
WHERE url_hash BETWEEN hash('place', 'prefix_lo')
AND hash('place', 'prefix_hi')
AND h.frecency <> 0 LIMIT 1`
);
Assert.ok(!stmt.executeStep());
stmt.finalize();
});