1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/toolkit/components/downloads/test/schema_migration/test_migration_to_9.js Wed Dec 31 06:09:35 2014 +0100
1.3 @@ -0,0 +1,74 @@
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 file,
1.6 + * 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 = 9;
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, guid " +
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 + 0,
1.50 + // For the new columns added, check that default values are sensible
1.51 + 'ignored-value'
1.52 + ];
1.53 +
1.54 + // Make sure the values are correct after the migration
1.55 + var i = 0;
1.56 + do_check_eq(data[i], stmt.getString(i++));
1.57 + do_check_eq(data[i], stmt.getUTF8String(i++));
1.58 + do_check_eq(data[i], stmt.getUTF8String(i++));
1.59 + do_check_eq(data[i], stmt.getString(i++));
1.60 + do_check_eq(data[i], stmt.getInt64(i++));
1.61 + do_check_eq(data[i], stmt.getInt64(i++));
1.62 + do_check_eq(data[i], stmt.getInt32(i++));
1.63 + do_check_eq(data[i], stmt.getUTF8String(i++));
1.64 + do_check_eq(data[i], stmt.getUTF8String(i++));
1.65 + do_check_eq(data[i], stmt.getInt64(i++));
1.66 + do_check_eq(data[i], stmt.getInt64(i++));
1.67 + do_check_eq(data[i], stmt.getUTF8String(i++));
1.68 + do_check_eq(data[i], stmt.getUTF8String(i++));
1.69 + do_check_eq(data[i], stmt.getInt32(i++));
1.70 + do_check_eq(data[i], stmt.getInt32(i++));
1.71 + do_check_true(/^[a-zA-Z0-9\-_]{12}$/.test(stmt.getString(i++)));
1.72 +
1.73 + stmt.reset();
1.74 + stmt.finalize();
1.75 +
1.76 + cleanup();
1.77 +}
1.78 \ No newline at end of file
