/services/sync/tests/unit/test_async_querySpinningly.js

http://github.com/zpao/v8monkey · JavaScript · 92 lines · 74 code · 18 blank · 0 comment · 0 complexity · f92615568eb63ded53bea96e9de868f2 MD5 · raw file

  1. _("Make sure querySpinningly will synchronously fetch rows for a query asyncly");
  2. Cu.import("resource://services-sync/async.js");
  3. const SQLITE_CONSTRAINT_VIOLATION = 19; // http://www.sqlite.org/c3ref/c_abort.html
  4. function querySpinningly(query, names) {
  5. let q = Svc.Form.DBConnection.createStatement(query);
  6. let r = Async.querySpinningly(q, names);
  7. q.finalize();
  8. return r;
  9. }
  10. function run_test() {
  11. initTestLogging("Trace");
  12. _("Make sure the call is async and allows other events to process");
  13. let isAsync = false;
  14. Utils.nextTick(function() { isAsync = true; });
  15. do_check_false(isAsync);
  16. _("Empty out the formhistory table");
  17. let r0 = querySpinningly("DELETE FROM moz_formhistory");
  18. do_check_eq(r0, null);
  19. _("Make sure there's nothing there");
  20. let r1 = querySpinningly("SELECT 1 FROM moz_formhistory");
  21. do_check_eq(r1, null);
  22. _("Insert a row");
  23. let r2 = querySpinningly("INSERT INTO moz_formhistory (fieldname, value) VALUES ('foo', 'bar')");
  24. do_check_eq(r2, null);
  25. _("Request a known value for the one row");
  26. let r3 = querySpinningly("SELECT 42 num FROM moz_formhistory", ["num"]);
  27. do_check_eq(r3.length, 1);
  28. do_check_eq(r3[0].num, 42);
  29. _("Get multiple columns");
  30. let r4 = querySpinningly("SELECT fieldname, value FROM moz_formhistory", ["fieldname", "value"]);
  31. do_check_eq(r4.length, 1);
  32. do_check_eq(r4[0].fieldname, "foo");
  33. do_check_eq(r4[0].value, "bar");
  34. _("Get multiple columns with a different order");
  35. let r5 = querySpinningly("SELECT fieldname, value FROM moz_formhistory", ["value", "fieldname"]);
  36. do_check_eq(r5.length, 1);
  37. do_check_eq(r5[0].fieldname, "foo");
  38. do_check_eq(r5[0].value, "bar");
  39. _("Add multiple entries (sqlite doesn't support multiple VALUES)");
  40. let r6 = querySpinningly("INSERT INTO moz_formhistory (fieldname, value) SELECT 'foo', 'baz' UNION SELECT 'more', 'values'");
  41. do_check_eq(r6, null);
  42. _("Get multiple rows");
  43. let r7 = querySpinningly("SELECT fieldname, value FROM moz_formhistory WHERE fieldname = 'foo'", ["fieldname", "value"]);
  44. do_check_eq(r7.length, 2);
  45. do_check_eq(r7[0].fieldname, "foo");
  46. do_check_eq(r7[1].fieldname, "foo");
  47. _("Make sure updates work");
  48. let r8 = querySpinningly("UPDATE moz_formhistory SET value = 'updated' WHERE fieldname = 'more'");
  49. do_check_eq(r8, null);
  50. _("Get the updated");
  51. let r9 = querySpinningly("SELECT value, fieldname FROM moz_formhistory WHERE fieldname = 'more'", ["fieldname", "value"]);
  52. do_check_eq(r9.length, 1);
  53. do_check_eq(r9[0].fieldname, "more");
  54. do_check_eq(r9[0].value, "updated");
  55. _("Grabbing fewer fields than queried is fine");
  56. let r10 = querySpinningly("SELECT value, fieldname FROM moz_formhistory", ["fieldname"]);
  57. do_check_eq(r10.length, 3);
  58. _("Generate an execution error");
  59. let query = "INSERT INTO moz_formhistory (fieldname, value) VALUES ('one', NULL)";
  60. let stmt = Svc.Form.DBConnection.createStatement(query);
  61. let r11, except; ;
  62. try {
  63. r11 = Async.querySpinningly(stmt);
  64. } catch(e) {
  65. except = e;
  66. }
  67. stmt.finalize()
  68. do_check_true(!!except);
  69. do_check_eq(except.result, SQLITE_CONSTRAINT_VIOLATION);
  70. _("Cleaning up");
  71. querySpinningly("DELETE FROM moz_formhistory");
  72. _("Make sure the timeout got to run before this function ends");
  73. do_check_true(isAsync);
  74. }