2012-08-16 00:50:52 +00:00
|
|
|
<!DOCTYPE html>
|
2014-02-12 18:17:47 +00:00
|
|
|
<script src="../../resources/js-test.js"></script>
|
2012-08-16 00:50:52 +00:00
|
|
|
<script src="resources/shared.js"></script>
|
|
|
|
|
<script>
|
2012-09-19 22:53:20 +00:00
|
|
|
|
2012-08-16 00:50:52 +00:00
|
|
|
description("Verify edge cases that lazy index population in an IndexedDB implementation might reveal.");
|
|
|
|
|
|
2012-11-15 01:19:01 +00:00
|
|
|
indexedDBTest(prepareDatabase, verifyPreExistingIndex);
|
2012-08-16 00:50:52 +00:00
|
|
|
function prepareDatabase()
|
|
|
|
|
{
|
2012-11-15 01:19:01 +00:00
|
|
|
connection = event.target.result;
|
|
|
|
|
deleteAllObjectStores(connection);
|
|
|
|
|
evalAndLog("store = connection.createObjectStore('store')");
|
|
|
|
|
evalAndLog("store.createIndex('index1', 'name', {unique: true})");
|
2012-08-16 00:50:52 +00:00
|
|
|
}
|
|
|
|
|
|
|
|
|
|
function verifyPreExistingIndex()
|
|
|
|
|
{
|
|
|
|
|
debug("Verify that uniqueness constraints are enforced with a pre-existing index:");
|
2012-11-15 01:19:01 +00:00
|
|
|
evalAndLog("trans = connection.transaction('store', 'readwrite')");
|
|
|
|
|
evalAndLog("store = trans.objectStore('store')");
|
|
|
|
|
evalAndLog("request1 = store.put({name: 'bob'}, 1)");
|
|
|
|
|
evalAndLog("request2 = store.put({name: 'bob'}, 2)");
|
|
|
|
|
evalAndLog("state = 0");
|
|
|
|
|
|
|
|
|
|
request1.onerror = unexpectedErrorCallback;
|
|
|
|
|
request1.onsuccess = function () {
|
|
|
|
|
debug("request1 received success event");
|
|
|
|
|
shouldBe("++state", "1");
|
|
|
|
|
};
|
2012-08-16 00:50:52 +00:00
|
|
|
|
2012-11-15 01:19:01 +00:00
|
|
|
request2.onsuccess = unexpectedSuccessCallback;
|
|
|
|
|
request2.onerror = function () {
|
|
|
|
|
debug("request2 received error event");
|
|
|
|
|
shouldBe("++state", "2");
|
|
|
|
|
};
|
|
|
|
|
|
|
|
|
|
trans.oncomplete = unexpectedCompleteCallback;
|
|
|
|
|
trans.onabort = function () {
|
|
|
|
|
debug("transaction aborted");
|
|
|
|
|
shouldBe("++state", "3");
|
|
|
|
|
shouldBe("trans.error.name", "'ConstraintError'");
|
|
|
|
|
verifyCreateThenPut();
|
2012-08-16 00:50:52 +00:00
|
|
|
};
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
function verifyCreateThenPut()
|
|
|
|
|
{
|
|
|
|
|
debug("");
|
|
|
|
|
debug("Verify that uniqueness constraints are enforced when index is created before puts:");
|
|
|
|
|
|
2012-11-15 01:19:01 +00:00
|
|
|
evalAndLog("connection.close()");
|
|
|
|
|
request = evalAndLog("indexedDB.open(dbname, 2)");
|
|
|
|
|
request.onerror = verifyPutThenCreate;
|
|
|
|
|
request.onblocked = unexpectedBlockedCallback;
|
|
|
|
|
request.onsuccess = unexpectedSuccessCallback;
|
|
|
|
|
request.onupgradeneeded = function() {
|
|
|
|
|
connection = request.result;
|
|
|
|
|
trans = request.transaction;
|
2012-08-16 00:50:52 +00:00
|
|
|
|
|
|
|
|
evalAndLog("deleteAllObjectStores(connection)");
|
|
|
|
|
|
|
|
|
|
evalAndLog("store = connection.createObjectStore('store')");
|
|
|
|
|
evalAndLog("store.createIndex('index2', 'name', {unique: true})");
|
|
|
|
|
evalAndLog("request1 = store.put({name: 'carol'}, 1)");
|
|
|
|
|
evalAndLog("request2 = store.put({name: 'carol'}, 2)");
|
|
|
|
|
evalAndLog("state = 0");
|
|
|
|
|
|
|
|
|
|
request1.onerror = unexpectedErrorCallback;
|
|
|
|
|
request1.onsuccess = function () {
|
|
|
|
|
debug("request1 (index2) received success event");
|
|
|
|
|
shouldBe("++state", "1");
|
|
|
|
|
};
|
|
|
|
|
|
|
|
|
|
request2.onsuccess = unexpectedSuccessCallback;
|
|
|
|
|
request2.onerror = function () {
|
|
|
|
|
debug("request2 (index2) received error event");
|
|
|
|
|
shouldBe("++state", "2");
|
|
|
|
|
};
|
|
|
|
|
|
|
|
|
|
trans.oncomplete = unexpectedCompleteCallback;
|
|
|
|
|
trans.onabort = function () {
|
|
|
|
|
debug("transaction aborted");
|
|
|
|
|
shouldBe("++state", "3");
|
2012-10-15 22:19:08 +00:00
|
|
|
shouldBe("trans.error.name", "'ConstraintError'");
|
2012-08-16 00:50:52 +00:00
|
|
|
};
|
|
|
|
|
};
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
function verifyPutThenCreate()
|
|
|
|
|
{
|
|
|
|
|
debug("");
|
|
|
|
|
debug("Verify that uniqueness constraints are enforced when index is created after puts:");
|
|
|
|
|
|
2012-11-15 01:19:01 +00:00
|
|
|
request = evalAndLog("indexedDB.open(dbname, 3)");
|
|
|
|
|
request.onerror = verifyPutThenCreateThenPut;
|
|
|
|
|
request.onblocked = unexpectedBlockedCallback;
|
|
|
|
|
request.onsuccess = unexpectedSuccessCallback;
|
|
|
|
|
request.onupgradeneeded = function() {
|
|
|
|
|
connection = request.result;
|
|
|
|
|
trans = request.transaction;
|
2012-08-16 00:50:52 +00:00
|
|
|
|
|
|
|
|
evalAndLog("deleteAllObjectStores(connection)");
|
|
|
|
|
|
|
|
|
|
evalAndLog("store = connection.createObjectStore('store')");
|
|
|
|
|
evalAndLog("request1 = store.put({name: 'ted'}, 1)");
|
|
|
|
|
evalAndLog("request2 = store.put({name: 'ted'}, 2)");
|
|
|
|
|
evalAndLog("store.createIndex('index3', 'name', {unique: true})");
|
|
|
|
|
evalAndLog("state = 0");
|
|
|
|
|
|
|
|
|
|
request1.onerror = unexpectedErrorCallback;
|
|
|
|
|
request1.onsuccess = function () {
|
|
|
|
|
debug("request1 received success event");
|
|
|
|
|
shouldBe("++state", "1");
|
|
|
|
|
};
|
|
|
|
|
|
|
|
|
|
request2.onerror = unexpectedErrorCallback;
|
|
|
|
|
request2.onsuccess = function () {
|
|
|
|
|
debug("request2 received success event");
|
|
|
|
|
shouldBe("++state", "2");
|
|
|
|
|
};
|
|
|
|
|
|
|
|
|
|
trans.oncomplete = unexpectedCompleteCallback;
|
|
|
|
|
trans.onabort = function () {
|
|
|
|
|
debug("transaction aborted");
|
|
|
|
|
shouldBe("++state", "3");
|
2012-10-15 22:19:08 +00:00
|
|
|
shouldBe("trans.error.name", "'ConstraintError'");
|
2012-08-16 00:50:52 +00:00
|
|
|
};
|
|
|
|
|
};
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
function verifyPutThenCreateThenPut()
|
|
|
|
|
{
|
|
|
|
|
debug("");
|
|
|
|
|
debug("Verify that uniqueness constraints are enforced when index is created between puts:");
|
|
|
|
|
|
2012-11-15 01:19:01 +00:00
|
|
|
request = evalAndLog("indexedDB.open(dbname, 4)");
|
|
|
|
|
request.onerror = finishJSTest;
|
|
|
|
|
request.onblocked = unexpectedBlockedCallback;
|
|
|
|
|
request.onsuccess = unexpectedSuccessCallback;
|
|
|
|
|
request.onupgradeneeded = function() {
|
|
|
|
|
connection = request.result;
|
|
|
|
|
trans = request.transaction;
|
2012-08-16 00:50:52 +00:00
|
|
|
|
|
|
|
|
evalAndLog("deleteAllObjectStores(connection)");
|
|
|
|
|
|
|
|
|
|
evalAndLog("store = connection.createObjectStore('store')");
|
|
|
|
|
evalAndLog("request1 = store.put({name: 'alice'}, 1)");
|
|
|
|
|
evalAndLog("store.createIndex('index4', 'name', {unique: true})");
|
|
|
|
|
evalAndLog("request2 = store.put({name: 'alice'}, 2)");
|
|
|
|
|
evalAndLog("state = 0");
|
|
|
|
|
|
|
|
|
|
request1.onerror = unexpectedErrorCallback;
|
|
|
|
|
request1.onsuccess = function () {
|
|
|
|
|
debug("request1 received success event");
|
|
|
|
|
shouldBe("++state", "1");
|
|
|
|
|
};
|
|
|
|
|
|
|
|
|
|
request2.onsuccess = unexpectedSuccessCallback;
|
|
|
|
|
request2.onerror = function () {
|
|
|
|
|
debug("request2 received error event");
|
|
|
|
|
shouldBe("++state", "2");
|
|
|
|
|
};
|
|
|
|
|
|
|
|
|
|
trans.oncomplete = unexpectedCompleteCallback;
|
|
|
|
|
trans.onabort = function () {
|
|
|
|
|
debug("transaction aborted");
|
|
|
|
|
shouldBe("++state", "3");
|
2012-10-15 22:19:08 +00:00
|
|
|
shouldBe("trans.error.name", "'ConstraintError'");
|
2012-08-16 00:50:52 +00:00
|
|
|
};
|
|
|
|
|
};
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
</script>
|
