/* 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 = OS.Path.join(OS.Constants.Path.profileDir,
                                 "places.sqlite.corrupt");
  Assert.ok(!(await OS.File.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 = OS.Path.join(OS.Constants.Path.profileDir,
                                 "places.sqlite.corrupt");
  Assert.ok((await OS.File.exists(corruptPath)), "Corrupt file should exist");
});
