344 lines
23 KiB
HTML
344 lines
23 KiB
HTML
<!DOCTYPE html>
|
|
<html>
|
|
<head>
|
|
<script src="../../http/tests/inspector/resources/inspector-test.js"></script>
|
|
<script src="resources/utilities.js"></script>
|
|
<script>
|
|
function test()
|
|
{
|
|
function objectPropertyPreview(remoteObject, name) {
|
|
for (let propertyPreview of remoteObject.preview.propertyPreviews) {
|
|
if (propertyPreview.name === name)
|
|
return propertyPreview;
|
|
}
|
|
return null;
|
|
}
|
|
|
|
let suite = InspectorTest.createAsyncSuite("IndexedDB.requestData");
|
|
|
|
suite.addTestCase({
|
|
name: "ClearDatabases",
|
|
description: "Remove any existing IndexedDB databases.",
|
|
test(resolve, reject) {
|
|
// FIXME: Remove any existing IndexedDB databases that might exist to workaround:
|
|
// <https://webkit.org/b/148006> Each test should run with its own clean data store
|
|
IndexedDBAgent.requestDatabaseNames(WI.networkManager.mainFrame.securityOrigin, (error, names) => {
|
|
InspectorTest.evaluateInPage("deleteDatabaseNames(" + JSON.stringify(names) + ")", resolve);
|
|
});
|
|
}
|
|
});
|
|
|
|
suite.addTestCase({
|
|
name: "RequestDataBasic",
|
|
description: "Request data for an object store with different indexes.",
|
|
test(resolve, reject) {
|
|
InspectorTest.evaluateInPage("createDatabaseWithStores('Database1', 1)");
|
|
IndexedDBAgent.requestDatabase(WI.networkManager.mainFrame.securityOrigin, "Database1", (error, database) => {
|
|
InspectorTest.expectNoError(error);
|
|
|
|
let [emptyObjectStore, reviewersObjectStore, statsObjectStore] = database.objectStores;
|
|
const securityOrigin = WI.networkManager.mainFrame.securityOrigin;
|
|
const skipCount = 0;
|
|
const pageSize = 10;
|
|
|
|
let indexName = "";
|
|
IndexedDBAgent.requestData(securityOrigin, database.name, reviewersObjectStore.name, indexName, skipCount, pageSize, (error, entries, hasMore) => {
|
|
InspectorTest.log("-- No Index");
|
|
InspectorTest.expectNoError(error);
|
|
InspectorTest.expectThat(entries.length === 4, "Should be 4 entries.");
|
|
InspectorTest.expectThat(!hasMore, "Should not have more entries.");
|
|
|
|
let expectedPrimaryKeyOrder = [1, 2, 3, 4];
|
|
let expectedNamesOrderedByPrimaryKey = ["Thirsty Hamster", "Jamming Peacock", "Bustling Badger", "Monstrous Beaver"];
|
|
for (let i = 0; i < entries.length; ++i) {
|
|
let entryPayload = entries[i];
|
|
let primaryKey = WI.RemoteObject.fromPayload(entryPayload.primaryKey);
|
|
let value = WI.RemoteObject.fromPayload(entryPayload.value);
|
|
InspectorTest.expectThat(primaryKey.value === expectedPrimaryKeyOrder[i], `Primary key should be ordered by primary key: ${expectedPrimaryKeyOrder[i]}`);
|
|
InspectorTest.expectThat(objectPropertyPreview(value, "name").value === expectedNamesOrderedByPrimaryKey[i], `Value should be a remote object for: '${expectedNamesOrderedByPrimaryKey[i]}'`);
|
|
}
|
|
});
|
|
|
|
indexName = "Name Index";
|
|
IndexedDBAgent.requestData(securityOrigin, database.name, reviewersObjectStore.name, indexName, skipCount, pageSize, (error, entries, hasMore) => {
|
|
InspectorTest.log("-- Name Index");
|
|
InspectorTest.expectNoError(error);
|
|
InspectorTest.expectThat(entries.length === 4, "Should be 4 entries.");
|
|
InspectorTest.expectThat(!hasMore, "Should not have more entries.");
|
|
|
|
let expectedPrimaryKeyOrder = [3, 2, 4, 1];
|
|
let expectedKeysOrderedByName = ["Bustling Badger", "Jamming Peacock", "Monstrous Beaver", "Thirsty Hamster"];
|
|
let expectedNamesOrderedByName = expectedKeysOrderedByName;
|
|
for (let i = 0; i < entries.length; ++i) {
|
|
let entryPayload = entries[i];
|
|
let primaryKey = WI.RemoteObject.fromPayload(entryPayload.primaryKey);
|
|
let key = WI.RemoteObject.fromPayload(entryPayload.key);
|
|
let value = WI.RemoteObject.fromPayload(entryPayload.value);
|
|
InspectorTest.expectThat(primaryKey.value === expectedPrimaryKeyOrder[i], `Primary key should be ordered by name: ${expectedPrimaryKeyOrder[i]}`);
|
|
InspectorTest.expectThat(key.value === expectedKeysOrderedByName[i], `Key should be ordered by name: '${expectedKeysOrderedByName[i]}'`);
|
|
InspectorTest.expectThat(objectPropertyPreview(value, "name").value === expectedNamesOrderedByName[i], `Value should be a remote object for: '${expectedNamesOrderedByName[i]}'`);
|
|
}
|
|
});
|
|
|
|
indexName = "Email Index";
|
|
IndexedDBAgent.requestData(securityOrigin, database.name, reviewersObjectStore.name, indexName, skipCount, pageSize, (error, entries, hasMore) => {
|
|
InspectorTest.log("-- Email Index");
|
|
InspectorTest.expectNoError(error);
|
|
InspectorTest.expectThat(entries.length === 4, "Should be 4 entries.");
|
|
InspectorTest.expectThat(!hasMore, "Should not have more entries.");
|
|
|
|
let expectedPrimaryKeyOrder = [3, 4, 2, 1];
|
|
let expectedKeysOrderedByEmail = ["badger@webkit.org", "beaver@webkit.org", "hamster@webkit.org", "peacock@webkit.org"];
|
|
let expectedNamesOrderedByEmail = ["Bustling Badger", "Monstrous Beaver", "Thirsty Hamster", "Jamming Peacock"];
|
|
for (let i = 0; i < entries.length; ++i) {
|
|
let entryPayload = entries[i];
|
|
let primaryKey = WI.RemoteObject.fromPayload(entryPayload.primaryKey);
|
|
let key = WI.RemoteObject.fromPayload(entryPayload.key);
|
|
let value = WI.RemoteObject.fromPayload(entryPayload.value);
|
|
InspectorTest.expectThat(primaryKey.value === expectedPrimaryKeyOrder[i], `Primary key should be ordered by email: ${expectedPrimaryKeyOrder[i]}`);
|
|
InspectorTest.expectThat(key.value === expectedKeysOrderedByEmail[i], `Key should be ordered by email: '${expectedKeysOrderedByEmail[i]}'`);
|
|
InspectorTest.expectThat(objectPropertyPreview(value, "name").value === expectedNamesOrderedByEmail[i], `Value should be a remote object for: '${expectedNamesOrderedByEmail[i]}'`);
|
|
}
|
|
});
|
|
|
|
InspectorBackend.runAfterPendingDispatches(resolve);
|
|
});
|
|
}
|
|
});
|
|
|
|
suite.addTestCase({
|
|
name: "RequestDataPagination",
|
|
description: "Request data for an object store with paginated requests.",
|
|
test(resolve, reject) {
|
|
InspectorTest.evaluateInPage("createDatabaseWithStores('Database2', 1)");
|
|
IndexedDBAgent.requestDatabase(WI.networkManager.mainFrame.securityOrigin, "Database2", (error, database) => {
|
|
InspectorTest.expectNoError(error);
|
|
|
|
let [emptyObjectStore, reviewersObjectStore, statsObjectStore] = database.objectStores;
|
|
const securityOrigin = WI.networkManager.mainFrame.securityOrigin;
|
|
const indexName = "";
|
|
const pageSize = 2;
|
|
|
|
let skipCount = 0;
|
|
IndexedDBAgent.requestData(securityOrigin, database.name, reviewersObjectStore.name, indexName, skipCount, pageSize, (error, entries, hasMore) => {
|
|
InspectorTest.log("-- Page 1");
|
|
InspectorTest.expectNoError(error);
|
|
InspectorTest.expectThat(entries.length === 2, "Entries length should match page size.");
|
|
InspectorTest.expectThat(hasMore, "Should have more entries.");
|
|
|
|
let expectedPrimaryKeyOrder = [1, 2];
|
|
let expectedNamesOrderedByPrimaryKey = ["Thirsty Hamster", "Jamming Peacock"];
|
|
for (let i = 0; i < entries.length; ++i) {
|
|
let entryPayload = entries[i];
|
|
let primaryKey = WI.RemoteObject.fromPayload(entryPayload.primaryKey);
|
|
let value = WI.RemoteObject.fromPayload(entryPayload.value);
|
|
InspectorTest.expectThat(primaryKey.value === expectedPrimaryKeyOrder[i], `Primary key should be ordered by primary key: ${expectedPrimaryKeyOrder[i]}`);
|
|
InspectorTest.expectThat(objectPropertyPreview(value, "name").value === expectedNamesOrderedByPrimaryKey[i], `Value should be a remote object for: '${expectedNamesOrderedByPrimaryKey[i]}'`);
|
|
}
|
|
});
|
|
|
|
skipCount = 2;
|
|
IndexedDBAgent.requestData(securityOrigin, database.name, reviewersObjectStore.name, indexName, skipCount, pageSize, (error, entries, hasMore) => {
|
|
InspectorTest.log("-- Page 2");
|
|
InspectorTest.expectNoError(error);
|
|
InspectorTest.expectThat(entries.length === 2, "Entries length should match page size.");
|
|
InspectorTest.expectThat(!hasMore, "Should not have more entries.");
|
|
|
|
let expectedPrimaryKeyOrder = [3, 4];
|
|
let expectedNamesOrderedByPrimaryKey = ["Bustling Badger", "Monstrous Beaver"];
|
|
for (let i = 0; i < entries.length; ++i) {
|
|
let entryPayload = entries[i];
|
|
let primaryKey = WI.RemoteObject.fromPayload(entryPayload.primaryKey);
|
|
let value = WI.RemoteObject.fromPayload(entryPayload.value);
|
|
InspectorTest.expectThat(primaryKey.value === expectedPrimaryKeyOrder[i], `Primary key should be ordered by primary key: ${expectedPrimaryKeyOrder[i]}`);
|
|
InspectorTest.expectThat(objectPropertyPreview(value, "name").value === expectedNamesOrderedByPrimaryKey[i], `Value should be a remote object for: '${expectedNamesOrderedByPrimaryKey[i]}'`);
|
|
}
|
|
});
|
|
|
|
InspectorBackend.runAfterPendingDispatches(resolve);
|
|
});
|
|
}
|
|
});
|
|
|
|
suite.addTestCase({
|
|
name: "RequestDataKeyRangeBounds",
|
|
description: "Request key range bounded data for an object store.",
|
|
test(resolve, reject) {
|
|
InspectorTest.evaluateInPage("createDatabaseWithStores('Database3', 1)");
|
|
IndexedDBAgent.requestDatabase(WI.networkManager.mainFrame.securityOrigin, "Database3", (error, database) => {
|
|
InspectorTest.expectNoError(error);
|
|
|
|
let [emptyObjectStore, reviewersObjectStore, statsObjectStore] = database.objectStores;
|
|
const securityOrigin = WI.networkManager.mainFrame.securityOrigin;
|
|
const indexName = "Name Index";
|
|
const skipCount = 0;
|
|
const pageSize = 10;
|
|
|
|
function stringKeyWithString(string) {
|
|
return {type: "string", string};
|
|
}
|
|
|
|
// Index: Name Index
|
|
// Keys: [3, 2, 4, 1]
|
|
// Values: ["Bustling Badger", "Jamming Peacock", "Monstrous Beaver", "Thirsty Hamster"];
|
|
|
|
// Keys >= "M"
|
|
let keyRange = {lower: stringKeyWithString("M"), lowerOpen: false, upperOpen: true};
|
|
IndexedDBAgent.requestData(securityOrigin, database.name, reviewersObjectStore.name, indexName, skipCount, pageSize, keyRange, (error, entries, hasMore) => {
|
|
InspectorTest.log("-- Keys >= 'M'");
|
|
InspectorTest.log("-- Lower Bound: 'M' (closed)");
|
|
InspectorTest.log("-- Upper Bound: -");
|
|
InspectorTest.expectNoError(error);
|
|
InspectorTest.expectThat(entries.length === 2, "Should be 2 entries.");
|
|
InspectorTest.expectThat(!hasMore, "Should not have more entries.");
|
|
|
|
let expectedPrimaryKeyOrder = [4, 1];
|
|
let expectedNamesOrderedByPrimaryKey = ["Monstrous Beaver", "Thirsty Hamster"];
|
|
for (let i = 0; i < entries.length; ++i) {
|
|
let entryPayload = entries[i];
|
|
let primaryKey = WI.RemoteObject.fromPayload(entryPayload.primaryKey);
|
|
let value = WI.RemoteObject.fromPayload(entryPayload.value);
|
|
InspectorTest.expectThat(primaryKey.value === expectedPrimaryKeyOrder[i], `Primary key should be ordered by primary key: ${expectedPrimaryKeyOrder[i]}`);
|
|
InspectorTest.expectThat(objectPropertyPreview(value, "name").value === expectedNamesOrderedByPrimaryKey[i], `Value should be a remote object for: '${expectedNamesOrderedByPrimaryKey[i]}'`);
|
|
}
|
|
});
|
|
|
|
// Keys > "M"
|
|
keyRange = {lower: stringKeyWithString("M"), lowerOpen: true, upperOpen: true};
|
|
IndexedDBAgent.requestData(securityOrigin, database.name, reviewersObjectStore.name, indexName, skipCount, pageSize, keyRange, (error, entries, hasMore) => {
|
|
InspectorTest.log("-- Keys > 'M'");
|
|
InspectorTest.log("-- Lower Bound: 'M' (open)");
|
|
InspectorTest.log("-- Upper Bound: -");
|
|
InspectorTest.expectNoError(error);
|
|
InspectorTest.expectThat(entries.length === 2, "Should be 2 entries.");
|
|
InspectorTest.expectThat(!hasMore, "Should not have more entries.");
|
|
|
|
let expectedPrimaryKeyOrder = [4, 1];
|
|
let expectedNamesOrderedByPrimaryKey = ["Monstrous Beaver", "Thirsty Hamster"];
|
|
for (let i = 0; i < entries.length; ++i) {
|
|
let entryPayload = entries[i];
|
|
let primaryKey = WI.RemoteObject.fromPayload(entryPayload.primaryKey);
|
|
let value = WI.RemoteObject.fromPayload(entryPayload.value);
|
|
InspectorTest.expectThat(primaryKey.value === expectedPrimaryKeyOrder[i], `Primary key should be ordered by primary key: ${expectedPrimaryKeyOrder[i]}`);
|
|
InspectorTest.expectThat(objectPropertyPreview(value, "name").value === expectedNamesOrderedByPrimaryKey[i], `Value should be a remote object for: '${expectedNamesOrderedByPrimaryKey[i]}'`);
|
|
}
|
|
});
|
|
|
|
// Keys > "Monstrous Beaver"
|
|
keyRange = {lower: stringKeyWithString("Monstrous Beaver"), lowerOpen: true, upperOpen: true};
|
|
IndexedDBAgent.requestData(securityOrigin, database.name, reviewersObjectStore.name, indexName, skipCount, pageSize, keyRange, (error, entries, hasMore) => {
|
|
InspectorTest.log("-- Keys > 'Monstrous Beaver'");
|
|
InspectorTest.log("-- Lower Bound: 'Monstrous Beaver' (open)");
|
|
InspectorTest.log("-- Upper Bound: -");
|
|
InspectorTest.expectNoError(error);
|
|
InspectorTest.expectThat(entries.length === 1, "Should be 1 entry.");
|
|
InspectorTest.expectThat(!hasMore, "Should not have more entries.");
|
|
|
|
let expectedPrimaryKeyOrder = [1];
|
|
let expectedNamesOrderedByPrimaryKey = ["Thirsty Hamster"];
|
|
for (let i = 0; i < entries.length; ++i) {
|
|
let entryPayload = entries[i];
|
|
let primaryKey = WI.RemoteObject.fromPayload(entryPayload.primaryKey);
|
|
let value = WI.RemoteObject.fromPayload(entryPayload.value);
|
|
InspectorTest.expectThat(primaryKey.value === expectedPrimaryKeyOrder[i], `Primary key should be ordered by primary key: ${expectedPrimaryKeyOrder[i]}`);
|
|
InspectorTest.expectThat(objectPropertyPreview(value, "name").value === expectedNamesOrderedByPrimaryKey[i], `Value should be a remote object for: '${expectedNamesOrderedByPrimaryKey[i]}'`);
|
|
}
|
|
});
|
|
|
|
// Keys <= "M"
|
|
keyRange = {upper: stringKeyWithString("M"), lowerOpen: true, upperOpen: false};
|
|
IndexedDBAgent.requestData(securityOrigin, database.name, reviewersObjectStore.name, indexName, skipCount, pageSize, keyRange, (error, entries, hasMore) => {
|
|
InspectorTest.log("-- Keys <= 'M'");
|
|
InspectorTest.log("-- Lower Bound: -");
|
|
InspectorTest.log("-- Upper Bound: 'M' (closed)");
|
|
InspectorTest.expectNoError(error);
|
|
InspectorTest.expectThat(entries.length === 2, "Should be 2 entries.");
|
|
InspectorTest.expectThat(!hasMore, "Should not have more entries.");
|
|
|
|
let expectedPrimaryKeyOrder = [3, 2];
|
|
let expectedNamesOrderedByPrimaryKey = ["Bustling Badger", "Jamming Peacock"];
|
|
for (let i = 0; i < entries.length; ++i) {
|
|
let entryPayload = entries[i];
|
|
let primaryKey = WI.RemoteObject.fromPayload(entryPayload.primaryKey);
|
|
let value = WI.RemoteObject.fromPayload(entryPayload.value);
|
|
InspectorTest.expectThat(primaryKey.value === expectedPrimaryKeyOrder[i], `Primary key should be ordered by primary key: ${expectedPrimaryKeyOrder[i]}`);
|
|
InspectorTest.expectThat(objectPropertyPreview(value, "name").value === expectedNamesOrderedByPrimaryKey[i], `Value should be a remote object for: '${expectedNamesOrderedByPrimaryKey[i]}'`);
|
|
}
|
|
});
|
|
|
|
// Keys <= "Monstrous Beaver"
|
|
keyRange = {upper: stringKeyWithString("Monstrous Beaver"), lowerOpen: true, upperOpen: false};
|
|
IndexedDBAgent.requestData(securityOrigin, database.name, reviewersObjectStore.name, indexName, skipCount, pageSize, keyRange, (error, entries, hasMore) => {
|
|
InspectorTest.log("-- Keys <= 'Monstrous Beaver'");
|
|
InspectorTest.log("-- Lower Bound: -");
|
|
InspectorTest.log("-- Upper Bound: 'Monstrous Beaver' (closed)");
|
|
InspectorTest.expectNoError(error);
|
|
InspectorTest.expectThat(entries.length === 3, "Should be 3 entries.");
|
|
InspectorTest.expectThat(!hasMore, "Should not have more entries.");
|
|
|
|
let expectedPrimaryKeyOrder = [3, 2, 4];
|
|
let expectedNamesOrderedByPrimaryKey = ["Bustling Badger", "Jamming Peacock", "Monstrous Beaver"];
|
|
for (let i = 0; i < entries.length; ++i) {
|
|
let entryPayload = entries[i];
|
|
let primaryKey = WI.RemoteObject.fromPayload(entryPayload.primaryKey);
|
|
let value = WI.RemoteObject.fromPayload(entryPayload.value);
|
|
InspectorTest.expectThat(primaryKey.value === expectedPrimaryKeyOrder[i], `Primary key should be ordered by primary key: ${expectedPrimaryKeyOrder[i]}`);
|
|
InspectorTest.expectThat(objectPropertyPreview(value, "name").value === expectedNamesOrderedByPrimaryKey[i], `Value should be a remote object for: '${expectedNamesOrderedByPrimaryKey[i]}'`);
|
|
}
|
|
});
|
|
|
|
// Keys < "M"
|
|
keyRange = {upper: stringKeyWithString("M"), lowerOpen: true, upperOpen: true};
|
|
IndexedDBAgent.requestData(securityOrigin, database.name, reviewersObjectStore.name, indexName, skipCount, pageSize, keyRange, (error, entries, hasMore) => {
|
|
InspectorTest.log("-- Keys < 'M'");
|
|
InspectorTest.log("-- Lower Bound: -");
|
|
InspectorTest.log("-- Upper Bound: 'M' (open)");
|
|
InspectorTest.expectNoError(error);
|
|
InspectorTest.expectThat(entries.length === 2, "Should be 2 entries.");
|
|
InspectorTest.expectThat(!hasMore, "Should not have more entries.");
|
|
|
|
let expectedPrimaryKeyOrder = [3, 2];
|
|
let expectedNamesOrderedByPrimaryKey = ["Bustling Badger", "Jamming Peacock"];
|
|
for (let i = 0; i < entries.length; ++i) {
|
|
let entryPayload = entries[i];
|
|
let primaryKey = WI.RemoteObject.fromPayload(entryPayload.primaryKey);
|
|
let value = WI.RemoteObject.fromPayload(entryPayload.value);
|
|
InspectorTest.expectThat(primaryKey.value === expectedPrimaryKeyOrder[i], `Primary key should be ordered by primary key: ${expectedPrimaryKeyOrder[i]}`);
|
|
InspectorTest.expectThat(objectPropertyPreview(value, "name").value === expectedNamesOrderedByPrimaryKey[i], `Value should be a remote object for: '${expectedNamesOrderedByPrimaryKey[i]}'`);
|
|
}
|
|
});
|
|
|
|
// "Monstrous Beaver" <= Key <= "Monstrous Beaver"
|
|
keyRange = {lower: stringKeyWithString("Monstrous Beaver"), upper: stringKeyWithString("Monstrous Beaver"), lowerOpen: false, upperOpen: false};
|
|
IndexedDBAgent.requestData(securityOrigin, database.name, reviewersObjectStore.name, indexName, skipCount, pageSize, keyRange, (error, entries, hasMore) => {
|
|
InspectorTest.log("-- 'Monstrous Beaver' <= Key <= 'Monstrous Beaver'");
|
|
InspectorTest.log("-- Lower Bound: 'Monstrous Beaver' (closed)");
|
|
InspectorTest.log("-- Upper Bound: 'Monstrous Beaver' (closed)");
|
|
InspectorTest.expectNoError(error);
|
|
InspectorTest.expectThat(entries.length === 1, "Should be 1 entry.");
|
|
InspectorTest.expectThat(!hasMore, "Should not have more entries.");
|
|
|
|
let expectedPrimaryKeyOrder = [4];
|
|
let expectedNamesOrderedByPrimaryKey = ["Monstrous Beaver"];
|
|
for (let i = 0; i < entries.length; ++i) {
|
|
let entryPayload = entries[i];
|
|
let primaryKey = WI.RemoteObject.fromPayload(entryPayload.primaryKey);
|
|
let value = WI.RemoteObject.fromPayload(entryPayload.value);
|
|
InspectorTest.expectThat(primaryKey.value === expectedPrimaryKeyOrder[i], `Primary key should be ordered by primary key: ${expectedPrimaryKeyOrder[i]}`);
|
|
InspectorTest.expectThat(objectPropertyPreview(value, "name").value === expectedNamesOrderedByPrimaryKey[i], `Value should be a remote object for: '${expectedNamesOrderedByPrimaryKey[i]}'`);
|
|
}
|
|
});
|
|
|
|
InspectorBackend.runAfterPendingDispatches(resolve);
|
|
});
|
|
}
|
|
});
|
|
|
|
suite.runTestCasesAndFinish();
|
|
}
|
|
</script>
|
|
</head>
|
|
<body onload="runTest()">
|
|
</body>
|
|
</html>
|