test_migration_to_4.js
/* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/. */
// This file tests migration from v3 to v4
function run_test()
{
// First import the downloads.sqlite file
importDatabaseFile("v3.sqlite");
// ok, now it is OK to init the download manager - this will perform the
// migration!
var dm = Cc["@mozilla.org/download-manager;1"].
getService(Ci.nsIDownloadManager);
var dbConn = dm.DBConnection;
var stmt = null;
// check schema version
do_check_true(dbConn.schemaVersion >= 4);
// Check that the column exists (statement should not throw)
stmt = dbConn.createStatement("SELECT entityID FROM moz_downloads");
stmt.finalize();
// now we check the entries
stmt = dbConn.createStatement(
"SELECT name, source, target, startTime, endTime, state, referrer, entityID " +
"FROM moz_downloads " +
"WHERE id = 27");
stmt.executeStep();
do_check_eq("Firefox 2.0.0.6.dmg", stmt.getString(0));
do_check_eq("http://ftp-mozilla.netscape.com/pub/mozilla.org/firefox/releases/2.0.0.6/mac/en-US/Firefox%202.0.0.6.dmg",
stmt.getUTF8String(1));
do_check_eq("file:///Users/sdwilsh/Desktop/Firefox%202.0.0.6.dmg",
stmt.getUTF8String(2));
do_check_eq(1187390974170783, stmt.getInt64(3));
do_check_eq(1187391001257446, stmt.getInt64(4));
do_check_eq(1, stmt.getInt32(5));
do_check_eq("http://www.mozilla.com/en-US/products/download.html?product=firefox-2.0.0.6&os=osx&lang=en-US",stmt.getUTF8String(6));
do_check_true(stmt.getIsNull(7));
stmt.finalize();
cleanup();
}