The Tor Browser / file revision

 /* 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();

 }