test_current_from_v79.js

Enable keyboard shortcuts

/* Any copyright is dedicated to the Public Domain.

 * http://creativecommons.org/publicdomain/zero/1.0/ */

"use strict";

const indices = [

  "moz_newtab_story_click_idx_newtab_click_timestamp",

  "moz_newtab_story_click_idx_newtab_impression_timestamp",

];

add_task(async function setup() {

  let path = await setupPlacesDatabase("places_v79.sqlite");

  let db = await Sqlite.openConnection({ path });

  let rows = await db.execute(

    "SELECT count(*) FROM sqlite_master WHERE name IN(?,?)",

    indices

);

  Assert.equal(rows[0].getResultByIndex(0), 2, "Check indices are present");

  await db.close();

});

add_task(async function database_is_valid() {

  // Accessing the database for the first time triggers 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 count(*) FROM sqlite_master WHERE name IN (?,?)",

    indices

);

  Assert.equal(rows[0].getResultByIndex(0), 0, "Check indices were removed");

});