The Tor Browser / file comparison
comparison: toolkit/components/downloads/test/schema_migration/test_migration_to_4.js
toolkit/components/downloads/test/schema_migration/test_migration_to_4.js
- branch
- TOR_BUG_9701
- changeset 15
- b8a032363ba2
equal
deleted
inserted
replaced
| -1:000000000000 | 0:6e7054394491 |
|---|---|
| 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/. */ | |
| 4 | |
| 5 // This file tests migration from v3 to v4 | |
| 6 | |
| 7 function run_test() | |
| 8 { | |
| 9 // First import the downloads.sqlite file | |
| 10 importDatabaseFile("v3.sqlite"); | |
| 11 | |
| 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; | |
| 18 | |
| 19 // check schema version | |
| 20 do_check_true(dbConn.schemaVersion >= 4); | |
| 21 | |
| 22 // Check that the column exists (statement should not throw) | |
| 23 stmt = dbConn.createStatement("SELECT entityID FROM moz_downloads"); | |
| 24 stmt.finalize(); | |
| 25 | |
| 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(); | |
| 43 | |
| 44 cleanup(); | |
| 45 } | |
| 46 |
