--- /dev/null
+Test IndexedDB's cursor skips deleted entries.
+
+On success, you will see a series of "PASS" messages, followed by "TEST COMPLETE".
+
+
+webkitIndexedDB.open('name')
+PASS 'onsuccess' in result is true
+PASS 'onerror' in result is true
+PASS 'readyState' in result is true
+An event should fire shortly...
+
+Success event fired:
+PASS 'result' in event is true
+PASS 'code' in event is false
+PASS 'message' in event is false
+PASS 'source' in event is true
+PASS event.source != null is true
+PASS 'onsuccess' in event.target is true
+PASS 'onerror' in event.target is true
+PASS 'readyState' in event.target is true
+PASS event.target.readyState is event.target.DONE
+
+db = event.result
+db.setVersion('new version')
+PASS 'onsuccess' in result is true
+PASS 'onerror' in result is true
+PASS 'readyState' in result is true
+An event should fire shortly...
+
+setVersionSuccess():
+Success event fired:
+PASS 'result' in event is true
+PASS 'code' in event is false
+PASS 'message' in event is false
+PASS 'source' in event is true
+PASS event.source != null is true
+PASS 'onsuccess' in event.target is true
+PASS 'onerror' in event.target is true
+PASS 'readyState' in event.target is true
+PASS event.target.readyState is event.target.DONE
+
+trans = event.result
+PASS trans !== null is true
+Deleted all object stores.
+createAndPopulateObjectStore():
+objectStore = db.createObjectStore('store', {keyPath: 'id'})
+objectStore.createIndex('nameIndex', 'name')
+
+resetObjectStore():
+
+basicCursorTest()
+trans = db.transaction([], webkitIDBTransaction.READ_WRITE)
+
+testCursor():
+trans.objectStore('store').openCursor(webkitIDBKeyRange.lowerBound(0))
+PASS 'onsuccess' in result is true
+PASS 'onerror' in result is true
+PASS 'readyState' in result is true
+An event should fire shortly...
+
+0: Alpha
+1: Bravo
+request = trans.objectStore('store').delete(0)
+2: Charlie
+request = trans.objectStore('store').delete(25)
+3: Delta
+request = trans.objectStore('store').delete(5)
+request = trans.objectStore('store').delete(6)
+request = trans.objectStore('store').delete(7)
+4: Echo
+8: India
+9: Juliet
+10: Kilo
+request = trans.objectStore('store').delete(10)
+11: Lima
+12: Mike
+request = trans.objectStore('store').delete(13)
+14: Oscar
+15: Papa
+request = trans.objectStore('store').delete(14)
+16: Quebec
+17: Romeo
+18: Sierra
+19: Tango
+20: Uniform
+request = trans.objectStore('store').delete(17)
+request = trans.objectStore('store').delete(18)
+21: Victor
+22: Whiskey
+23: X-ray
+24: Yankee
+
+
+resetObjectStore():
+
+reverseCursorTest():
+
+testCursor():
+trans.objectStore('store').openCursor(webkitIDBKeyRange.lowerBound(0), webkitIDBCursor.PREV)
+PASS 'onsuccess' in result is true
+PASS 'onerror' in result is true
+PASS 'readyState' in result is true
+An event should fire shortly...
+
+25: Zulu
+24: Yankee
+request = trans.objectStore('store').delete(25)
+23: X-ray
+request = trans.objectStore('store').delete(0)
+22: Whiskey
+request = trans.objectStore('store').delete(20)
+request = trans.objectStore('store').delete(19)
+request = trans.objectStore('store').delete(18)
+21: Victor
+17: Romeo
+16: Quebec
+15: Papa
+request = trans.objectStore('store').delete(15)
+14: Oscar
+13: November
+request = trans.objectStore('store').delete(12)
+11: Lima
+10: Kilo
+request = trans.objectStore('store').delete(11)
+9: Juliet
+8: India
+7: Hotel
+6: Golf
+5: Foxtrot
+request = trans.objectStore('store').delete(7)
+request = trans.objectStore('store').delete(8)
+4: Echo
+3: Delta
+2: Charlie
+1: Bravo
+
+
+resetObjectStore():
+
+indexCursorTest():
+
+testCursor():
+trans.objectStore('store').index('nameIndex').openCursor(webkitIDBKeyRange.lowerBound('Alpha'))
+PASS 'onsuccess' in result is true
+PASS 'onerror' in result is true
+PASS 'readyState' in result is true
+An event should fire shortly...
+
+0: Alpha
+1: Bravo
+request = trans.objectStore('store').delete(0)
+2: Charlie
+request = trans.objectStore('store').delete(25)
+3: Delta
+request = trans.objectStore('store').delete(5)
+request = trans.objectStore('store').delete(6)
+request = trans.objectStore('store').delete(7)
+4: Echo
+8: India
+9: Juliet
+10: Kilo
+request = trans.objectStore('store').delete(10)
+11: Lima
+12: Mike
+request = trans.objectStore('store').delete(13)
+14: Oscar
+15: Papa
+request = trans.objectStore('store').delete(14)
+16: Quebec
+17: Romeo
+18: Sierra
+19: Tango
+20: Uniform
+request = trans.objectStore('store').delete(17)
+request = trans.objectStore('store').delete(18)
+21: Victor
+22: Whiskey
+23: X-ray
+24: Yankee
+
+transactionComplete():
+PASS successfullyParsed is true
+
+TEST COMPLETE
+
--- /dev/null
+<html>
+<head>
+<link rel="stylesheet" href="../../fast/js/resources/js-test-style.css">
+<script src="../../fast/js/resources/js-test-pre.js"></script>
+<script src="../../fast/js/resources/js-test-post-function.js"></script>
+<script src="resources/shared.js"></script>
+</head>
+<body>
+<p id="description"></p>
+<div id="console"></div>
+<script>
+
+description("Test IndexedDB's cursor skips deleted entries.");
+if (window.layoutTestController)
+ layoutTestController.waitUntilDone();
+
+var names = ['Alpha', 'Bravo', 'Charlie', 'Delta', 'Echo', 'Foxtrot', 'Golf',
+ 'Hotel', 'India', 'Juliet', 'Kilo', 'Lima', 'Mike', 'November',
+ 'Oscar', 'Papa', 'Quebec', 'Romeo', 'Sierra', 'Tango', 'Uniform',
+ 'Victor', 'Whiskey', 'X-ray', 'Yankee', 'Zulu'];
+
+test();
+
+function test()
+{
+ result = evalAndLog("webkitIndexedDB.open('name')");
+ verifyResult(result);
+ result.onsuccess = openSuccess;
+ result.onerror = unexpectedErrorCallback;
+}
+
+function openSuccess()
+{
+ verifySuccessEvent(event);
+ var db = evalAndLog("db = event.result");
+
+ result = evalAndLog("db.setVersion('new version')");
+ verifyResult(result);
+ result.onsuccess = setVersionSuccess;
+ result.onerror = unexpectedErrorCallback;
+}
+
+function setVersionSuccess()
+{
+ debug("setVersionSuccess():");
+ verifySuccessEvent(event);
+ window.trans = evalAndLog("trans = event.result");
+ shouldBeTrue("trans !== null");
+ trans.onabort = unexpectedAbortCallback;
+ trans.oncomplete = basicCursorTest;
+
+ deleteAllObjectStores(db, createAndPopulateObjectStore);
+}
+
+function createAndPopulateObjectStore()
+{
+ debug("createAndPopulateObjectStore():");
+
+ var objectStore = evalAndLog("objectStore = db.createObjectStore('store', {keyPath: 'id'})");
+ evalAndLog("objectStore.createIndex('nameIndex', 'name')");
+ resetObjectStore(function() {});
+}
+
+var silentErrorHandler = function() { event.preventDefault(); }
+
+function resetObjectStore(callback)
+{
+ debug("\nresetObjectStore():");
+ if (callback === undefined)
+ callback = function () {};
+
+ var objectStore = trans.objectStore('store');
+ for (var i = 0; i < names.length; i++)
+ objectStore.delete(i).onerror = silentErrorHandler;
+ for (var i = 0; i < names.length; i++)
+ objectStore.add({id: i, name: names[i]}).onerror = unexpectedErrorCallback;
+
+ debug("");
+ callback();
+}
+
+function contains(arr, obj)
+{
+ for (var i = 0; i < arr.length; i++) {
+ if (arr[i] == obj)
+ return true;
+ }
+ return false;
+}
+
+var cursor;
+var deleted;
+var seen;
+
+function testCursor(deleteList, createCursorCommand, callback)
+{
+ debug("\ntestCursor():");
+ deleted = [];
+ seen = [];
+
+ // Create the cursor.
+ request = evalAndLog(createCursorCommand);
+ verifyResult(request);
+
+ request.onerror = unexpectedErrorCallback;
+ request.onsuccess = function () {
+ if (event.result == null) {
+ // Make sure we have seen every non-deleted item.
+ for (var i = 0; i < names.length; i++) {
+ if (contains(deleted, i))
+ continue;
+
+ if (!contains(seen, i))
+ testFailed("Cursor did not see item with id: " + i);
+ }
+
+ // Make sure we used every rule in |deleteList|.
+ for (var i = 0; i < deleteList.length; i++) {
+ if (!contains(seen, deleteList[i].id))
+ testFailed("deleteList rule with id: " + deleteList[i].id + " was never used.");
+ }
+
+ debug("");
+ callback();
+ return;
+ }
+
+ cursor = event.result;
+ debug(event.result.value.id + ": " + event.result.value.name);
+ seen.push(event.result.value.id);
+
+ // Make sure we don't see any deleted items.
+ if (contains(deleted, event.result.value.id))
+ testFailed("Cursor hit previously deleted element.");
+
+ for (var i = 0; i < deleteList.length; i++) {
+ if (event.result.value.id == deleteList[i].id) {
+ // Delete objects targeted by this id.
+ var targets = deleteList[i].targets;
+ for (var j = 0; j < targets.length; j++) {
+ deleted.push(targets[j]);
+ request = evalAndLog("request = trans.objectStore('store').delete(" + targets[j] + ")");
+ request.onerror = unexpectedErrorCallback;
+ if (j == targets.length - 1)
+ request.onsuccess = function() { cursor.continue(); }
+ }
+ return;
+ }
+ }
+
+ cursor.continue();
+ }
+}
+
+function basicCursorTest()
+{
+ debug("basicCursorTest()");
+
+ evalAndLog("trans = db.transaction([], webkitIDBTransaction.READ_WRITE)");
+ trans.onabort = unexpectedAbortCallback;
+ trans.oncomplete = transactionComplete;
+
+ var deletes = [{id: 1, targets: [0]},
+ {id: 2, targets: [names.length - 1]},
+ {id: 3, targets: [5,6,7]},
+ {id: 10, targets: [10]},
+ {id: 12, targets: [13]},
+ {id: 15, targets: [14]},
+ {id: 20, targets: [17,18]}
+ ];
+
+ testCursor(deletes, "trans.objectStore('store').openCursor(webkitIDBKeyRange.lowerBound(0))", function() { resetObjectStore(reverseCursorTest); });
+}
+
+function reverseCursorTest()
+{
+ debug("reverseCursorTest():");
+
+ var deletes = [{id: 24, targets: [names.length - 1]},
+ {id: 23, targets: [0]},
+ {id: 22, targets: [20, 19, 18]},
+ {id: 15, targets: [15]},
+ {id: 13, targets: [12]},
+ {id: 10, targets: [11]},
+ {id: 5, targets: [7,8]}
+ ];
+
+
+ testCursor(deletes, "trans.objectStore('store').openCursor(webkitIDBKeyRange.lowerBound(0), webkitIDBCursor.PREV)", function() { resetObjectStore(indexCursorTest); });
+}
+
+function indexCursorTest()
+{
+ debug("indexCursorTest():");
+
+ var deletes = [{id: 1, targets: [0]},
+ {id: 2, targets: [names.length - 1]},
+ {id: 3, targets: [5,6,7]},
+ {id: 10, targets: [10]},
+ {id: 12, targets: [13]},
+ {id: 15, targets: [14]},
+ {id: 20, targets: [17,18]}
+ ];
+
+ testCursor(deletes, "trans.objectStore('store').index('nameIndex').openCursor(webkitIDBKeyRange.lowerBound('Alpha'))", function() { });
+}
+
+function transactionComplete()
+{
+ debug("transactionComplete():");
+ done();
+}
+
+var successfullyParsed = true;
+
+</script>
+</body>
+</html>