firefox-main/toolkit/components/places/tests/migration/test_current_from_v82.js (file symbol)

Source code

Revision control

Copy as Markdown

Other Tools

Test Info: Warnings

/* Any copyright is dedicated to the Public Domain.
"use strict";
add_task(async function setup() {
let path = await setupPlacesDatabase("places_v82.sqlite");
let db = await Sqlite.openConnection({ path });
await db.execute(`
INSERT INTO moz_places (url, guid, url_hash, frecency, recalc_frecency)
VALUES
-- Zero frecency
('https://example1.com', '___________1', '123456', 0, 0),
-- Positive frecency
('https://example2.com', '___________2', '123456', 1, 0),
-- Negative frecency
('https://example3.com', '___________3', '123456', -1, 0)
`);
let rows = await db.execute(`
SELECT frecency, recalc_frecency
FROM moz_places
WHERE url_hash = '123456'
`);
Assert.equal(rows.length, 3, "There should be three rows.");
for (let row of rows) {
Assert.equal(
row.getResultByName("recalc_frecency"),
0,
"Row should have recalc_frecency equal to 0."
);
}
Assert.equal(
rows[0].getResultByName("frecency"),
0,
"Should have zero frecency."
);
Assert.greater(
rows[1].getResultByName("frecency"),
0,
"Should have a frecency greater than 0."
);
Assert.less(
rows[2].getResultByName("frecency"),
0,
"Should have a frecency less than 0."
);
await db.close();
});
add_task(async function database_is_valid() {
// trigger migration
Assert.equal(
PlacesUtils.history.databaseStatus,
PlacesUtils.history.DATABASE_STATUS_UPGRADED
);
const db = await PlacesUtils.promiseDBConnection();
Assert.equal(await db.getSchemaVersion(), CURRENT_SCHEMA_VERSION);
let rows = await db.execute(`
SELECT recalc_frecency FROM moz_places
WHERE url_hash = '123456'
`);
Assert.equal(
rows[0].getResultByName("recalc_frecency"),
0,
"Recalc frecency should still be 0."
);
Assert.equal(
rows[1].getResultByName("recalc_frecency"),
1,
"Recalc frecency should be 1."
);
Assert.equal(
rows[2].getResultByName("recalc_frecency"),
0,
"Recalc frecency should still be 0."
);
});