The Tor Browser: services/common/tests/unit/test_async

Cloned upstream origin tor-browser at tor-browser-31.3.0esr-4.5-1-build1
revision ID fc1c9ff7c1b2defdbc039f12214767608f46423f for hacking purpose.

     1 /* Any copyright is dedicated to the Public Domain.

     2  * http://creativecommons.org/publicdomain/zero/1.0/ */

     4 Cu.import("resource://gre/modules/XPCOMUtils.jsm");

     5 Cu.import("resource://services-common/async.js");

     6 Cu.import("resource://services-common/utils.js");

     8 _("Make sure querySpinningly will synchronously fetch rows for a query asyncly");

    10 const SQLITE_CONSTRAINT_VIOLATION = 19;  // http://www.sqlite.org/c3ref/c_abort.html

    12 let Svc = {};

    13 XPCOMUtils.defineLazyServiceGetter(Svc, "Form",

    14                                    "@mozilla.org/satchel/form-history;1",

    15                                    "nsIFormHistory2");

    17 function querySpinningly(query, names) {

    18   let q = Svc.Form.DBConnection.createStatement(query);

    19   let r = Async.querySpinningly(q, names);

    20   q.finalize();

    21   return r;

    22 }

    24 function run_test() {

    25   initTestLogging("Trace");

    27   _("Make sure the call is async and allows other events to process");

    28   let isAsync = false;

    29   CommonUtils.nextTick(function() { isAsync = true; });

    30   do_check_false(isAsync);

    32   _("Empty out the formhistory table");

    33   let r0 = querySpinningly("DELETE FROM moz_formhistory");

    34   do_check_eq(r0, null);

    36   _("Make sure there's nothing there");

    37   let r1 = querySpinningly("SELECT 1 FROM moz_formhistory");

    38   do_check_eq(r1, null);

    40   _("Insert a row");

    41   let r2 = querySpinningly("INSERT INTO moz_formhistory (fieldname, value) VALUES ('foo', 'bar')");

    42   do_check_eq(r2, null);

    44   _("Request a known value for the one row");

    45   let r3 = querySpinningly("SELECT 42 num FROM moz_formhistory", ["num"]);

    46   do_check_eq(r3.length, 1);

    47   do_check_eq(r3[0].num, 42);

    49   _("Get multiple columns");

    50   let r4 = querySpinningly("SELECT fieldname, value FROM moz_formhistory", ["fieldname", "value"]);

    51   do_check_eq(r4.length, 1);

    52   do_check_eq(r4[0].fieldname, "foo");

    53   do_check_eq(r4[0].value, "bar");

    55   _("Get multiple columns with a different order");

    56   let r5 = querySpinningly("SELECT fieldname, value FROM moz_formhistory", ["value", "fieldname"]);

    57   do_check_eq(r5.length, 1);

    58   do_check_eq(r5[0].fieldname, "foo");

    59   do_check_eq(r5[0].value, "bar");

    61   _("Add multiple entries (sqlite doesn't support multiple VALUES)");

    62   let r6 = querySpinningly("INSERT INTO moz_formhistory (fieldname, value) SELECT 'foo', 'baz' UNION SELECT 'more', 'values'");

    63   do_check_eq(r6, null);

    65   _("Get multiple rows");

    66   let r7 = querySpinningly("SELECT fieldname, value FROM moz_formhistory WHERE fieldname = 'foo'", ["fieldname", "value"]);

    67   do_check_eq(r7.length, 2);

    68   do_check_eq(r7[0].fieldname, "foo");

    69   do_check_eq(r7[1].fieldname, "foo");

    71   _("Make sure updates work");

    72   let r8 = querySpinningly("UPDATE moz_formhistory SET value = 'updated' WHERE fieldname = 'more'");

    73   do_check_eq(r8, null);

    75   _("Get the updated");

    76   let r9 = querySpinningly("SELECT value, fieldname FROM moz_formhistory WHERE fieldname = 'more'", ["fieldname", "value"]);

    77   do_check_eq(r9.length, 1);

    78   do_check_eq(r9[0].fieldname, "more");

    79   do_check_eq(r9[0].value, "updated");

    81   _("Grabbing fewer fields than queried is fine");

    82   let r10 = querySpinningly("SELECT value, fieldname FROM moz_formhistory", ["fieldname"]);

    83   do_check_eq(r10.length, 3);

    85   _("Generate an execution error");

    86   let query = "INSERT INTO moz_formhistory (fieldname, value) VALUES ('one', NULL)";

    87   let stmt = Svc.Form.DBConnection.createStatement(query);

    88   let r11, except; ;

    89   try {

    90     r11 = Async.querySpinningly(stmt);

    91   } catch(e) {

    92     except = e;

    93   }

    94   stmt.finalize()

    95   do_check_true(!!except);

    96   do_check_eq(except.result, SQLITE_CONSTRAINT_VIOLATION);

    98   _("Cleaning up");

    99   querySpinningly("DELETE FROM moz_formhistory");

   101   _("Make sure the timeout got to run before this function ends");

   102   do_check_true(isAsync);

   103 }

The Tor Browser / file revision