3 <script src="../../fast/js/resources/js-test-pre.js"></script>
4 <script src="resources/shared.js"></script>
7 <p id="description"></p>
8 <div id="console"></div>
11 description("Test IndexedDB's cursor update.");
12 if (window.layoutTestController)
13 layoutTestController.waitUntilDone();
19 request = evalAndLog("webkitIndexedDB.open('cursor-update')");
20 request.onsuccess = openSuccess;
21 request.onerror = unexpectedErrorCallback;
24 function openSuccess()
26 var db = evalAndLog("db = event.target.result");
28 request = evalAndLog("db.setVersion('new version')");
29 request.onsuccess = setVersionSuccess;
30 request.onerror = unexpectedErrorCallback;
33 function setVersionSuccess()
35 debug("setVersionSuccess():");
36 window.trans = evalAndLog("trans = event.target.result");
37 shouldBeTrue("trans !== null");
38 trans.onabort = unexpectedAbortCallback;
39 trans.oncomplete = openBasicCursor;
41 deleteAllObjectStores(db);
43 var objectStore = evalAndLog("objectStore = db.createObjectStore('basicStore')");
44 evalAndLog("objectStore.add('myValue1', 'myKey1').onerror = unexpectedErrorCallback");
45 evalAndLog("objectStore.add('myValue2', 'myKey2').onerror = unexpectedErrorCallback");
46 evalAndLog("objectStore.add('myValue3', 'myKey3').onerror = unexpectedErrorCallback");
47 evalAndLog("objectStore.add('myValue4', 'myKey4').onerror = unexpectedErrorCallback");
49 var objectStore = evalAndLog("objectStore = db.createObjectStore('autoIncrementStore', {autoIncrement: true})");
50 evalAndLog("objectStore.add('foo1').onerror = unexpectedErrorCallback");
51 evalAndLog("objectStore.add('foo2').onerror = unexpectedErrorCallback");
52 evalAndLog("objectStore.add('foo3').onerror = unexpectedErrorCallback");
53 evalAndLog("objectStore.add('foo4').onerror = unexpectedErrorCallback");
55 var objectStore = evalAndLog("objectStore = db.createObjectStore('keyPathStore', {keyPath: 'id'})");
56 evalAndLog("objectStore.createIndex('numberIndex', 'number')");
57 evalAndLog("objectStore.add({number: 1, id: 1}).onerror = unexpectedErrorCallback");
58 evalAndLog("objectStore.add({number: 2, id: 2}).onerror = unexpectedErrorCallback");
59 evalAndLog("objectStore.add({number: 3, id: 3}).onerror = unexpectedErrorCallback");
60 evalAndLog("objectStore.add({number: 4, id: 4}).onerror = unexpectedErrorCallback");
63 function openBasicCursor()
65 debug("openBasicCursor()");
66 evalAndLog("trans = db.transaction(['basicStore', 'autoIncrementStore', 'keyPathStore'], webkitIDBTransaction.READ_WRITE)");
67 trans.onabort = unexpectedAbortCallback;
68 trans.oncomplete = transactionComplete;
70 keyRange = webkitIDBKeyRange.lowerBound("myKey1");
71 window.objectStore = evalAndLog("trans.objectStore('basicStore')");
72 request = evalAndLog("objectStore.openCursor(keyRange)");
73 request.onsuccess = basicUpdateCursor;
74 request.onerror = unexpectedErrorCallback;
78 function basicUpdateCursor()
80 debug("basicUpdateCursor()");
81 shouldBe("event.target.source", "objectStore");
82 if (event.target.result == null) {
83 shouldBe("counter", "5");
86 request = evalAndLog("trans.objectStore('basicStore').openCursor(keyRange)");
87 request.onsuccess = basicCheckCursor;
88 request.onerror = unexpectedErrorCallback;
92 request = evalAndLog("event.target.result.update('myUpdatedValue' + counter++)");
93 request.onsuccess = function() { evalAndLog("event.target.source.continue()"); }
94 request.onerror = unexpectedErrorCallback;
97 function basicCheckCursor()
99 debug("basicCheckCursor()");
100 if (event.target.result == null) {
101 shouldBe("counter", "5");
104 keyRange = webkitIDBKeyRange.lowerBound(1);
105 request = evalAndLog("trans.objectStore('autoIncrementStore').openCursor(keyRange)");
106 request.onsuccess = autoIncrementUpdateCursor;
107 request.onerror = unexpectedErrorCallback;
111 shouldBeEqualToString("event.target.result.key", "myKey" + counter);
112 shouldBeEqualToString("event.target.result.value", "myUpdatedValue" + counter++);
113 evalAndLog("event.target.result.continue()");
116 function autoIncrementUpdateCursor()
118 debug("autoIncrementUpdateCursor()");
119 if (event.target.result == null) {
120 shouldBe("counter", "5");
123 request = evalAndLog("trans.objectStore('autoIncrementStore').openCursor(keyRange)");
124 request.onsuccess = autoIncrementCheckCursor;
125 request.onerror = unexpectedErrorCallback;
129 request = evalAndLog("event.target.result.update('myUpdatedFoo' + counter++)");
130 request.onsuccess = function() { evalAndLog("event.target.source.continue()"); }
131 request.onerror = unexpectedErrorCallback;
134 function autoIncrementCheckCursor()
136 debug("autoIncrementCheckCursor()");
137 if (event.target.result == null) {
138 shouldBe("counter", "5");
141 keyRange = webkitIDBKeyRange.lowerBound(1);
142 request = evalAndLog("trans.objectStore('keyPathStore').openCursor(keyRange)");
143 request.onsuccess = keyPathUpdateCursor;
144 request.onerror = unexpectedErrorCallback;
148 shouldBe("event.target.result.key", "counter");
149 shouldBeEqualToString("event.target.result.value", "myUpdatedFoo" + counter++);
150 evalAndLog("event.target.result.continue()");
153 function keyPathUpdateCursor()
155 debug("keyPathUpdateCursor()");
156 if (event.target.result == null) {
157 shouldBe("counter", "5");
160 request = evalAndLog("trans.objectStore('keyPathStore').openCursor(keyRange)");
161 request.onsuccess = keyPathCheckCursor;
162 request.onerror = unexpectedErrorCallback;
166 request = evalAndLog("event.target.result.update({id: 100 + counter, number: 100 + counter})");
167 request.onsuccess = unexpectedSuccessCallback;
168 request.onerror = function() {
169 shouldBe("event.target.errorCode", "webkitIDBDatabaseException.DATA_ERR");
171 evalAndLog("event.preventDefault()");
173 request = evalAndLog("event.target.source.update({id: counter, number: 100 + counter++})");
174 request.onsuccess = function() { evalAndLog("event.target.source.continue()") };
175 request.onerror = unexpectedErrorCallback;
179 function keyPathCheckCursor()
181 debug("keyPathCheckCursor()");
182 if (event.target.result == null) {
183 shouldBe("counter", "5");
186 keyRange = webkitIDBKeyRange.lowerBound(101);
187 request = evalAndLog("trans.objectStore('keyPathStore').index('numberIndex').openKeyCursor(keyRange)");
188 request.onsuccess = keyCursor;
189 request.onerror = unexpectedErrorCallback;
193 shouldBe("event.target.result.key", "counter");
194 shouldBe("event.target.result.value.id", "counter");
195 shouldBe("event.target.result.value.number", (counter + 100).toString());
197 evalAndLog("event.target.result.continue()");
202 debug("keyCursor()");
203 if (event.target.result == null) {
204 shouldBe("counter", "5");
208 shouldBe("event.target.result.key", "counter + 100");
209 shouldBe("event.target.result.primaryKey", "counter");
212 debug("event.target.result.update({id: counter, number: counter + 200})");
213 event.target.result.update({id: counter, number: counter + 200});
214 testFailed("Expected exception.");
217 shouldBe("code", "webkitIDBDatabaseException.NOT_ALLOWED_ERR");
221 event.target.result.continue();
224 function transactionComplete()
226 debug("transactionComplete()");