The Tor Browser: toolkit/components/downloads/test/schema_migration/test_migration_to

Cloned upstream origin tor-browser at tor-browser-31.3.0esr-4.5-1-build1
revision ID fc1c9ff7c1b2defdbc039f12214767608f46423f for hacking purpose.

     1 /* This Source Code Form is subject to the terms of the Mozilla Public

     2  * License, v. 2.0. If a copy of the MPL was not distributed with this

     3  * file, You can obtain one at http://mozilla.org/MPL/2.0/. */

     5 // This file tests migration from v3 to v4

     7 function run_test()

8 {

     9   // First import the downloads.sqlite file

    10   importDatabaseFile("v3.sqlite");

    12   // ok, now it is OK to init the download manager - this will perform the

    13   // migration!

    14   var dm = Cc["@mozilla.org/download-manager;1"].

    15            getService(Ci.nsIDownloadManager);

    16   var dbConn = dm.DBConnection;

    17   var stmt = null;

    19   // check schema version

    20   do_check_true(dbConn.schemaVersion >= 4);

    22   // Check that the column exists (statement should not throw)

    23   stmt = dbConn.createStatement("SELECT entityID FROM moz_downloads");

    24   stmt.finalize();

    26   // now we check the entries

    27   stmt = dbConn.createStatement(

    28     "SELECT name, source, target, startTime, endTime, state, referrer, entityID " +

    29     "FROM moz_downloads " +

    30     "WHERE id = 27");

    31   stmt.executeStep();

    32   do_check_eq("Firefox 2.0.0.6.dmg", stmt.getString(0));

    33   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",

    34               stmt.getUTF8String(1));

    35   do_check_eq("file:///Users/sdwilsh/Desktop/Firefox%202.0.0.6.dmg",

    36               stmt.getUTF8String(2));

    37   do_check_eq(1187390974170783, stmt.getInt64(3));

    38   do_check_eq(1187391001257446, stmt.getInt64(4));

    39   do_check_eq(1, stmt.getInt32(5));

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

    41   do_check_true(stmt.getIsNull(7));

    42   stmt.finalize();

    44   cleanup();

    45 }

The Tor Browser / file revision