47 lines
1.3 KiB
JavaScript
47 lines
1.3 KiB
JavaScript
/* Any copyright is dedicated to the Public Domain.
|
|
http://creativecommons.org/publicdomain/zero/1.0/ */
|
|
|
|
"use strict";
|
|
|
|
// Import common head.
|
|
{
|
|
/* import-globals-from ../head_common.js */
|
|
let commonFile = do_get_file("../head_common.js", false);
|
|
let uri = Services.io.newFileURI(commonFile);
|
|
Services.scriptloader.loadSubScript(uri.spec, this);
|
|
}
|
|
|
|
// Put any other stuff relative to this test folder below.
|
|
|
|
const CURRENT_SCHEMA_VERSION = Ci.nsINavHistoryService.DATABASE_SCHEMA_VERSION;
|
|
const FIRST_UPGRADABLE_SCHEMA_VERSION = 52;
|
|
|
|
async function assertAnnotationsRemoved(db, expectedAnnos) {
|
|
for (let anno of expectedAnnos) {
|
|
let rows = await db.execute(
|
|
`
|
|
SELECT id FROM moz_anno_attributes
|
|
WHERE name = :anno
|
|
`,
|
|
{ anno }
|
|
);
|
|
|
|
Assert.equal(rows.length, 0, `${anno} should not exist in the database`);
|
|
}
|
|
}
|
|
|
|
async function assertNoOrphanAnnotations(db) {
|
|
let rows = await db.execute(`
|
|
SELECT item_id FROM moz_items_annos
|
|
WHERE item_id NOT IN (SELECT id from moz_bookmarks)
|
|
`);
|
|
|
|
Assert.equal(rows.length, 0, `Should have no orphan annotations.`);
|
|
|
|
rows = await db.execute(`
|
|
SELECT id FROM moz_anno_attributes
|
|
WHERE id NOT IN (SELECT id from moz_items_annos)
|
|
`);
|
|
|
|
Assert.equal(rows.length, 0, `Should have no orphan annotation attributes.`);
|
|
}
|