toolkit/components/downloads/test/schema_migration/test_migration_to_3.js@b8a032363ba2 (annotated)
toolkit/components/downloads/test/schema_migration/test_migration_to_3.js
Thu, 22 Jan 2015 13:21:57 +0100
- author
- Michael Schloh von Bennewitz <michael@schloh.com>
- date
- Thu, 22 Jan 2015 13:21:57 +0100
- branch
- TOR_BUG_9701
- changeset 15
- b8a032363ba2
- permissions
- -rw-r--r--
Incorporate requested changes from Mozilla in review:
https://bugzilla.mozilla.org/show_bug.cgi?id=1123480#c6
| 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("v2.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 >= 3); |
| michael@0 | 21 | |
| michael@0 | 22 | // Check that the column exists (statement should not throw) |
| michael@0 | 23 | stmt = dbConn.createStatement("SELECT referrer 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 " + |
| michael@0 | 29 | "FROM moz_downloads " + |
| michael@0 | 30 | "WHERE id = 2"); |
| michael@0 | 31 | stmt.executeStep(); |
| michael@0 | 32 | do_check_eq("381603.patch", stmt.getString(0)); |
| michael@0 | 33 | do_check_eq("https://bugzilla.mozilla.org/attachment.cgi?id=266520", |
| michael@0 | 34 | stmt.getUTF8String(1)); |
| michael@0 | 35 | do_check_eq("file:///Users/sdwilsh/Desktop/381603.patch", |
| michael@0 | 36 | stmt.getUTF8String(2)); |
| michael@0 | 37 | do_check_eq(1180493839859230, stmt.getInt64(3)); |
| michael@0 | 38 | do_check_eq(1180493839859230, stmt.getInt64(4)); |
| michael@0 | 39 | do_check_eq(1, stmt.getInt32(5)); |
| michael@0 | 40 | do_check_true(stmt.getIsNull(6)); |
| michael@0 | 41 | stmt.finalize(); |
| michael@0 | 42 | |
| michael@0 | 43 | cleanup(); |
| michael@0 | 44 | } |
| michael@0 | 45 |
