third_party/WebKit/LayoutTests/storage/indexeddb/resources/cursor-prev-no-duplicate.js

   1 if (this.importScripts) {
   2     importScripts('../../../resources/js-test.js');
   3     importScripts('shared.js');
   4 }
   5
   6 description("Test IndexedDB behavior when iterating backwards with and without NO_DUPLICATE");
   7
   8 indexedDBTest(prepareDatabase, populateStore);
   9 function prepareDatabase()
  10 {
  11     db = event.target.result;
  12     store = evalAndLog("store = db.createObjectStore('store')");
  13     evalAndLog("store.createIndex('index', 'sorted')");
  14 }
  15
  16 function populateStore()
  17 {
  18     debug("");
  19     debug("populating store...");
  20     evalAndLog("trans = db.transaction('store', 'readwrite')");
  21     evalAndLog("store = trans.objectStore('store');");
  22     trans.onerror = unexpectedErrorCallback;
  23     trans.onabort = unexpectedAbortCallback;
  24
  25     evalAndLog("store.put({sorted: 3, value: 111}, 1)");
  26     evalAndLog("store.put({sorted: 2, value: 222}, 2)");
  27     evalAndLog("store.put({sorted: 1, value: 333}, 3)");
  28     evalAndLog("store.put({sorted: 10, value: 444}, 17)");
  29     evalAndLog("store.put({sorted: 10, value: 555}, 16)");
  30     evalAndLog("store.put({sorted: 10, value: 666}, 15)");
  31     trans.oncomplete = testFarRangeCursor_closed;
  32 }
  33
  34
  35 function testFarRangeCursor_closed()
  36 {
  37     debug("");
  38     debug("testFarRangeCursor: upper bound is well out of range, results always the same, whether open or closed");
  39
  40     runTest(makeOpenCursor("store", 7, false, "'prev'"),
  41             { expectedValue: 333, expectedKey: 3},
  42             testFarRangeCursor_open);
  43 }
  44
  45 function testFarRangeCursor_open()
  46 {
  47     runTest(makeOpenCursor("store", 7, true, "'prev'"),
  48             { expectedValue: 333, expectedKey: 3},
  49             testFarRangeCursor_indexClosed);
  50 }
  51
  52 function testFarRangeCursor_indexClosed()
  53 {
  54     // here '7' refers to the 'sorted' value
  55     runTest(makeOpenCursor("index", 7, false, "'prev'"),
  56             { expectedValue: 111, expectedKey: 3, expectedPrimaryKey: 1},
  57             testFarRangeCursor_indexOpen);
  58 }
  59 function testFarRangeCursor_indexOpen()
  60 {
  61     runTest(makeOpenCursor("index", 7, true, "'prev'"),
  62             { expectedValue: 111, expectedKey: 3, expectedPrimaryKey: 1},
  63             testFarRangeCursor_indexKeyOpen);
  64 }
  65
  66 function testFarRangeCursor_indexKeyOpen()
  67 {
  68     // here '7' refers to the sorted value
  69     runTest(makeOpenKeyCursor("index", 7, false, "'prev'"),
  70             { expectedKey: 3, expectedPrimaryKey: 1},
  71             testFarRangeCursor_indexKeyClosed);
  72 }
  73
  74 function testFarRangeCursor_indexKeyClosed()
  75 {
  76     runTest(makeOpenKeyCursor("index", 7, true, "'prev'"),
  77             { expectedKey: 3, expectedPrimaryKey: 1},
  78             testBoundaryCursor_closed);
  79 }
  80
  81 function testBoundaryCursor_closed()
  82 {
  83     runTest(makeOpenCursor("store", 3, false, "'prev'"),
  84             { expectedValue: 333, expectedKey: 3},
  85             testBoundaryCursor_open);
  86 };
  87
  88 function testBoundaryCursor_open()
  89 {
  90     runTest(makeOpenCursor("store", 3, true, "'prev'"),
  91             { expectedValue: 222, expectedKey: 2},
  92             testBoundaryCursor_indexClosed);
  93 }
  94
  95 function testBoundaryCursor_indexClosed()
  96 {
  97     // by index sort order, we should return them in a different order
  98     runTest(makeOpenCursor("index", 3, false, "'prev'"),
  99             { expectedValue: 111, expectedKey: 3, expectedPrimaryKey: 1},
 100             testBoundaryCursor_indexOpen);
 101 }
 102
 103 function testBoundaryCursor_indexOpen()
 104 {
 105     runTest(makeOpenCursor("index", 3, true, "'prev'"),
 106             { expectedValue: 222, expectedKey: 2, expectedPrimaryKey: 2},
 107             testBoundaryCursor_indexKeyClosed);
 108 }
 109
 110 function testBoundaryCursor_indexKeyClosed()
 111 {
 112
 113     // now the value doesn't matter, just the primary key
 114     runTest(makeOpenKeyCursor("index", 3, false, "'prev'"),
 115             { expectedKey: 3, expectedPrimaryKey: 1},
 116             testBoundaryCursor_indexKeyOpen);
 117 }
 118
 119 function testBoundaryCursor_indexKeyOpen()
 120 {
 121     runTest(makeOpenKeyCursor("index", 3, true, "'prev'"),
 122             { expectedKey: 2, expectedPrimaryKey: 2},
 123             testNoDuplicate_closed);
 124 }
 125
 126 function testNoDuplicate_closed()
 127 {
 128     debug("testNoDuplicate: there are 3 values, but we should return always the first one");
 129
 130     // PREV_NO_DUPLICATE doesn't really affect non-indexed
 131     // cursors, but we should make sure we get the right one
 132     // anyway
 133     runTest(makeOpenCursor("store", 15, false, "'prevunique'"),
 134             { expectedValue: 666, expectedKey: 15, expectedPrimaryKey: 15 },
 135             testNoDuplicate_open);
 136 }
 137
 138 function testNoDuplicate_open()
 139 {
 140     // still three values, but now the index says we should return the
 141     // second one
 142     runTest(makeOpenCursor("index", 15, false, "'prevunique'"),
 143             { expectedValue: 666, expectedKey: 10, expectedPrimaryKey: 15},
 144             testNoDuplicate_indexKeyClosed);
 145 }
 146
 147
 148 function testNoDuplicate_indexKeyClosed()
 149 {
 150     // same behavior as above, without a value
 151     runTest(makeOpenKeyCursor("index", 15, false, "'prevunique'"),
 152             { expectedKey: 10, expectedPrimaryKey: 15},
 153             finishJSTest);
 154 }
 155
 156
 157 function makeOpenCursor(obj, upperBound, open, direction)
 158 {
 159     return obj + ".openCursor(IDBKeyRange.upperBound(" + upperBound + ", " +
 160         open + "), " +
 161             direction + ")";
 162 }
 163
 164 function makeOpenKeyCursor(obj, upperBound, open, direction)
 165 {
 166     return obj + ".openKeyCursor(IDBKeyRange.upperBound(" + upperBound + ", " +
 167         open + "), " +
 168             direction + ")";
 169 }
 170
 171 function runTest(openCursor, expectation, callback)
 172 {
 173     trans = db.transaction('store', 'readonly');
 174
 175     // expose these for code in openCursor
 176     store = trans.objectStore('store');
 177     index = store.index('index');
 178     trans.onerror = unexpectedErrorCallback;
 179     trans.onabort = unexpectedAbortCallback;
 180     trans.oncomplete = function() {
 181         debug("DONE");
 182         debug("");
 183         callback();
 184     };
 185
 186     storeReq = evalAndLog("storeReq = " + openCursor);
 187     storeReq.onsuccess = function() {
 188         cursor = event.target.result;
 189         if (cursor === null) {
 190             testFailed("null cursor");
 191             return;
 192         }
 193
 194         shouldBe("cursor.key", JSON.stringify(expectation.expectedKey));
 195         if ("value" in cursor) {
 196             shouldBe("cursor.value.value", JSON.stringify(expectation.expectedValue));
 197         } else if ("expectedValue" in expectation)
 198             testFailed("Test broken: shouldn't have expectedValue");
 199
 200         if ("expectedPrimaryKey" in expectation) {
 201             shouldBe("cursor.primaryKey", JSON.stringify(expectation.expectedPrimaryKey));
 202         }
 203     };
 204 }