toolkit/components/downloads/test/schema_migration/test_migration_to_4.js@925c144e1f1f (annotated)
toolkit/components/downloads/test/schema_migration/test_migration_to_4.js
Fri, 16 Jan 2015 18:13:44 +0100
- author
- Michael Schloh von Bennewitz <michael@schloh.com>
- date
- Fri, 16 Jan 2015 18:13:44 +0100
- branch
- TOR_BUG_9701
- changeset 14
- 925c144e1f1f
- permissions
- -rw-r--r--
Integrate suggestion from review to improve consistency with existing code.
| michael@0 | 1 | /* This Source Code Form is subject to the terms of the Mozilla Public |
| michael@0 | 2 | * License, v. 2.0. If a copy of the MPL was not distributed with this |
| michael@0 | 3 | * file, You can obtain one at http://mozilla.org/MPL/2.0/. */ |
| michael@0 | 4 | |
| michael@0 | 5 | // This file tests migration from v3 to v4 |
| michael@0 | 6 | |
| michael@0 | 7 | function run_test() |
| michael@0 | 8 | { |
| michael@0 | 9 | // First import the downloads.sqlite file |
| michael@0 | 10 | importDatabaseFile("v3.sqlite"); |
| michael@0 | 11 | |
| michael@0 | 12 | // ok, now it is OK to init the download manager - this will perform the |
| michael@0 | 13 | // migration! |
| michael@0 | 14 | var dm = Cc["@mozilla.org/download-manager;1"]. |
| michael@0 | 15 | getService(Ci.nsIDownloadManager); |
| michael@0 | 16 | var dbConn = dm.DBConnection; |
| michael@0 | 17 | var stmt = null; |
| michael@0 | 18 | |
| michael@0 | 19 | // check schema version |
| michael@0 | 20 | do_check_true(dbConn.schemaVersion >= 4); |
| michael@0 | 21 | |
| michael@0 | 22 | // Check that the column exists (statement should not throw) |
| michael@0 | 23 | stmt = dbConn.createStatement("SELECT entityID FROM moz_downloads"); |
| michael@0 | 24 | stmt.finalize(); |
| michael@0 | 25 | |
| michael@0 | 26 | // now we check the entries |
| michael@0 | 27 | stmt = dbConn.createStatement( |
| michael@0 | 28 | "SELECT name, source, target, startTime, endTime, state, referrer, entityID " + |
| michael@0 | 29 | "FROM moz_downloads " + |
| michael@0 | 30 | "WHERE id = 27"); |
| michael@0 | 31 | stmt.executeStep(); |
| michael@0 | 32 | do_check_eq("Firefox 2.0.0.6.dmg", stmt.getString(0)); |
| michael@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", |
| michael@0 | 34 | stmt.getUTF8String(1)); |
| michael@0 | 35 | do_check_eq("file:///Users/sdwilsh/Desktop/Firefox%202.0.0.6.dmg", |
| michael@0 | 36 | stmt.getUTF8String(2)); |
| michael@0 | 37 | do_check_eq(1187390974170783, stmt.getInt64(3)); |
| michael@0 | 38 | do_check_eq(1187391001257446, stmt.getInt64(4)); |
| michael@0 | 39 | do_check_eq(1, stmt.getInt32(5)); |
| michael@0 | 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)); |
| michael@0 | 41 | do_check_true(stmt.getIsNull(7)); |
| michael@0 | 42 | stmt.finalize(); |
| michael@0 | 43 | |
| michael@0 | 44 | cleanup(); |
| michael@0 | 45 | } |
| michael@0 | 46 |
