The Tor Browser / file diff

     1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/toolkit/components/downloads/test/schema_migration/test_migration_to_8.js	Wed Dec 31 06:09:35 2014 +0100
     1.3 @@ -0,0 +1,72 @@
     1.4 +/* This Source Code Form is subject to the terms of the Mozilla Public
     1.5 + * License, v. 2.0. If a copy of the MPL was not distributed with this
     1.6 + * file, You can obtain one at http://mozilla.org/MPL/2.0/. */
     1.7 +
     1.8 +function run_test()
     1.9 +{
    1.10 +  // We're testing migration to this version from one version below
    1.11 +  var targetVersion = 8;
    1.12 +
    1.13 +  // First import the downloads.sqlite file
    1.14 +  importDatabaseFile("v" + (targetVersion - 1) + ".sqlite");
    1.15 +
    1.16 +  // Init the download manager which will try migrating to the new version
    1.17 +  var dm = Cc["@mozilla.org/download-manager;1"].
    1.18 +           getService(Ci.nsIDownloadManager);
    1.19 +  var dbConn = dm.DBConnection;
    1.20 +
    1.21 +  // Check schema version
    1.22 +  do_check_true(dbConn.schemaVersion >= targetVersion);
    1.23 +
    1.24 +  // Make sure all the columns are there
    1.25 +  var stmt = dbConn.createStatement(
    1.26 +    "SELECT name, source, target, tempPath, startTime, endTime, state, " +
    1.27 +           "referrer, entityID, currBytes, maxBytes, mimeType, " +
    1.28 +           "preferredApplication, preferredAction, autoResume " +
    1.29 +    "FROM moz_downloads " +
    1.30 +    "WHERE id = 28");
    1.31 +  stmt.executeStep();
    1.32 +
    1.33 +  // This data is based on the original values in the table
    1.34 +  var data = [
    1.35 +    "firefox-3.0a9pre.en-US.linux-i686.tar.bz2",
    1.36 +    "http://ftp.mozilla.org/pub/mozilla.org/firefox/nightly/latest-trunk/firefox-3.0a9pre.en-US.linux-i686.tar.bz2",
    1.37 +    "file:///Users/Ed/Desktop/firefox-3.0a9pre.en-US.linux-i686.tar.bz2",
    1.38 +    "/Users/Ed/Desktop/+EZWafFQ.bz2.part",
    1.39 +    1192469856209164,
    1.40 +    1192469877017396,
    1.41 +    Ci.nsIDownloadManager.DOWNLOAD_FINISHED,
    1.42 +    "http://ftp.mozilla.org/pub/mozilla.org/firefox/nightly/latest-trunk/",
    1.43 +    "%2210e66c1-8a2d6b-9b33f380%22/9055595/Mon, 15 Oct 2007 11:45:34 GMT",
    1.44 +    1210772,
    1.45 +    9055595,
    1.46 +    "application/x-bzip2",
    1.47 +    "AAAAAAGqAAIAAQxNYWNpbnRvc2ggSEQAAAAAAAAAAAAAAAAAAAC+91IESCsAAAAHc5UUU3R1ZmZJdCBFeHBhbmRlci5hcHAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAdzmb3SGI8AAAAAAAAAAP////8AAAkgAAAAAAAAAAAAAAAAAAAAFFN0dWZmSXQgU3RhbmRhcmQgOS4wABAACAAAvveYVAAAABEACAAAvdJs7wAAAAEACAAHc5UAAAAWAAIAQ01hY2ludG9zaCBIRDpBcHBsaWNhdGlvbnM6U3R1ZmZJdCBTdGFuZGFyZCA5LjA6U3R1ZmZJdCBFeHBhbmRlci5hcHAAAA4AKgAUAFMAdAB1AGYAZgBJAHQAIABFAHgAcABhAG4AZABlAHIALgBhAHAAcAAPABoADABNAGEAYwBpAG4AdABvAHMAaAAgAEgARAASADZBcHBsaWNhdGlvbnMvU3R1ZmZJdCBTdGFuZGFyZCA5LjAvU3R1ZmZJdCBFeHBhbmRlci5hcHAAEwABLwD//wAA",
    1.48 +    2,
    1.49 +    // For the new columns added, check for null or default values
    1.50 +    0,
    1.51 +  ];
    1.52 +
    1.53 +  // Make sure the values are correct after the migration
    1.54 +  var i = 0;
    1.55 +  do_check_eq(data[i], stmt.getString(i++));
    1.56 +  do_check_eq(data[i], stmt.getUTF8String(i++));
    1.57 +  do_check_eq(data[i], stmt.getUTF8String(i++));
    1.58 +  do_check_eq(data[i], stmt.getString(i++));
    1.59 +  do_check_eq(data[i], stmt.getInt64(i++));
    1.60 +  do_check_eq(data[i], stmt.getInt64(i++));
    1.61 +  do_check_eq(data[i], stmt.getInt32(i++));
    1.62 +  do_check_eq(data[i], stmt.getUTF8String(i++));
    1.63 +  do_check_eq(data[i], stmt.getUTF8String(i++));
    1.64 +  do_check_eq(data[i], stmt.getInt64(i++));
    1.65 +  do_check_eq(data[i], stmt.getInt64(i++));
    1.66 +  do_check_eq(data[i], stmt.getUTF8String(i++));
    1.67 +  do_check_eq(data[i], stmt.getUTF8String(i++));
    1.68 +  do_check_eq(data[i], stmt.getInt32(i++));
    1.69 +  do_check_eq(data[i], stmt.getInt32(i++));
    1.70 +
    1.71 +  stmt.reset();
    1.72 +  stmt.finalize();
    1.73 +
    1.74 +  cleanup();
    1.75 +}