toolkit/components/downloads/test/schema_migration/test_migration_to_2.js@6474c204b198 (annotated)
toolkit/components/downloads/test/schema_migration/test_migration_to_2.js
Wed, 31 Dec 2014 06:09:35 +0100
- author
- Michael Schloh von Bennewitz <michael@schloh.com>
- date
- Wed, 31 Dec 2014 06:09:35 +0100
- changeset 0
- 6474c204b198
- permissions
- -rw-r--r--
Cloned upstream origin tor-browser at tor-browser-31.3.0esr-4.5-1-build1
revision ID fc1c9ff7c1b2defdbc039f12214767608f46423f for hacking purpose.
| 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 v1 to v2 |
| 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("v1.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 >= 2); |
| michael@0 | 21 | |
| michael@0 | 22 | // Check that the column no longer exists |
| michael@0 | 23 | try { |
| michael@0 | 24 | // throws when it doesn't exist |
| michael@0 | 25 | stmt = dbConn.createStatement("SELECT iconURL FROM moz_downloads"); |
| michael@0 | 26 | do_throw("should not get here"); |
| michael@0 | 27 | } catch (e) { |
| michael@0 | 28 | do_check_eq(Cr.NS_ERROR_FAILURE, e.result); |
| michael@0 | 29 | } |
| michael@0 | 30 | |
| michael@0 | 31 | // now we check the entries |
| michael@0 | 32 | stmt = dbConn.createStatement( |
| michael@0 | 33 | "SELECT name, source, target, startTime, endTime, state " + |
| michael@0 | 34 | "FROM moz_downloads " + |
| michael@0 | 35 | "WHERE id = 2"); |
| michael@0 | 36 | stmt.executeStep(); |
| michael@0 | 37 | do_check_eq("381603.patch", stmt.getString(0)); |
| michael@0 | 38 | do_check_eq("https://bugzilla.mozilla.org/attachment.cgi?id=266520", |
| michael@0 | 39 | stmt.getUTF8String(1)); |
| michael@0 | 40 | do_check_eq("file:///Users/sdwilsh/Desktop/381603.patch", |
| michael@0 | 41 | stmt.getUTF8String(2)); |
| michael@0 | 42 | do_check_eq(1180493839859230, stmt.getInt64(3)); |
| michael@0 | 43 | do_check_eq(1180493839859230, stmt.getInt64(4)); |
| michael@0 | 44 | do_check_eq(1, stmt.getInt32(5)); |
| michael@0 | 45 | stmt.finalize(); |
| michael@0 | 46 | |
| michael@0 | 47 | cleanup(); |
| michael@0 | 48 | } |
| michael@0 | 49 |
