/* Any copyright is dedicated to the Public Domain.
   http://creativecommons.org/publicdomain/zero/1.0/ */

/**
 * This file tests migration from a preliminary schema version 6 that
 * lacks frecency column and moz_inputhistory table.
 */

add_task(async function setup() {
  await setupPlacesDatabase("places_outdated.sqlite");
});

add_task(async function corrupt_database_not_exists() {
  let corruptPath = PathUtils.join(
    PathUtils.profileDir,
    "places.sqlite.corrupt"
  );
  Assert.ok(
    !(await IOUtils.exists(corruptPath)),
    "Corrupt file should not exist"
  );
});

add_task(async function database_is_valid() {
  Assert.equal(
    PlacesUtils.history.databaseStatus,
    PlacesUtils.history.DATABASE_STATUS_CORRUPT
  );

  let db = await PlacesUtils.promiseDBConnection();
  Assert.equal(await db.getSchemaVersion(), CURRENT_SCHEMA_VERSION);
});

add_task(async function check_columns() {
  // Check the database has been replaced, these would throw otherwise.
  let db = await PlacesUtils.promiseDBConnection();
  await db.execute("SELECT frecency from moz_places");
  await db.execute("SELECT 1 from moz_inputhistory");
});

add_task(async function corrupt_database_exists() {
  let corruptPath = PathUtils.join(
    PathUtils.profileDir,
    "places.sqlite.corrupt"
  );
  Assert.ok(await IOUtils.exists(corruptPath), "Corrupt file should exist");
});