test_current_from_v38.js

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

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
  );

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

add_task(async function test_select_new_fields() {
  let db = await PlacesUtils.promiseDBConnection();
  await db.execute(`SELECT description, preview_image_url FROM moz_places`);
  Assert.ok(true, "should be able to select description and preview_image_url");
});