<!DOCTYPE HTML>
<html>
<title>Pseudo-random transactions</title>
<script src="../head.js"></script>
<script src="../common.js"></script>
<script>
var SELECT_STATEMENT_IN_READ_TRANSACTION = 0;
var SELECT_STATEMENT_IN_TRANSACTION = 1;
var INSERT_STATEMENT = 2;
var UPDATE_STATEMENT = 3;
var DELETE_STATEMENT = 4;
var STATEMENTS =
[2, 0, 4, 2, 2, 2, 2, 2, 1, 4, 1, 1, 0, 2, 0, 0, 2, 1, 2, 0,
4, 4, 2, 3, 3, 4, 3, 1, 3, 3, 2, 4, 3, 3, 2, 3, 1, 1, 4, 2,
4, 1, 4, 2, 3, 0, 4, 2, 4, 0, 4, 3, 3, 2, 0, 2, 1, 4, 4, 4,
4, 2, 3, 2, 0, 3, 3, 0, 4, 4, 4, 2, 3, 1, 4, 2, 4, 2, 3, 0,
2, 4, 0, 4, 2, 2, 4, 0, 3, 2, 3, 2, 3, 2, 0, 0, 4, 0, 2, 0];
var transactionsCompleted = 0;
var startTime = 0;
function statementSuccessCallback(tx, data) {}
function statementErrorCallback(tx, error) {}
function transactionSuccessCallback() {
if (++transactionsCompleted == TRANSACTIONS)
testComplete(Date.now() - startTime);
}
function transactionErrorCallback(error) {
testComplete(TEST_FAILED);
}
function customRunTransactions(db) {
var selectIDCounter = 0;
var insertIDCounter = 0;
var updateIDCounter = 0;
var deleteIDCounter = 0;
var randomString = getRandomString();
var randomStringForUpdates = getRandomString();
startTime = Date.now();
for (var i = 0; i < TRANSACTIONS; i++) {
switch (STATEMENTS[i % STATEMENTS.length]) {
case SELECT_STATEMENT_IN_READ_TRANSACTION:
db.readTransaction(
function(tx) {
tx.executeSql('SELECT * FROM Test WHERE ID = ?',
[selectIDCounter++],
statementSuccessCallback, statementErrorCallback);
}, transactionErrorCallback, transactionSuccessCallback);
break;
case SELECT_STATEMENT_IN_TRANSACTION:
db.transaction(
function(tx) {
tx.executeSql('SELECT * FROM Test WHERE ID = ?',
[selectIDCounter++],
statementSuccessCallback, statementErrorCallback);
}, transactionErrorCallback, transactionSuccessCallback);
break;
case INSERT_STATEMENT:
db.transaction(
function(tx) {
tx.executeSql('INSERT INTO Test VALUES (?, ?)',
[insertIDCounter++, randomString],
statementSuccessCallback, statementErrorCallback);
}, transactionErrorCallback, transactionSuccessCallback);
break;
case UPDATE_STATEMENT:
db.transaction(
function(tx) {
tx.executeSql('UPDATE Test SET Foo = ? WHERE ID = ?',
[randomStringForUpdates, updateIDCounter++],
statementSuccessCallback, statementErrorCallback);
}, transactionErrorCallback, transactionSuccessCallback);
break;
case DELETE_STATEMENT:
db.transaction(
function(tx) {
tx.executeSql('DELETE FROM Test WHERE ID = ?',
[deleteIDCounter++],
statementSuccessCallback, statementErrorCallback);
}, transactionErrorCallback, transactionSuccessCallback);
break;
default:
testComplete(TEST_FAILED);
return;
}
}
}
</script>
<body>
<script>
runPerformanceTest({
dbName: "PseudoRandomTransactions",
readOnly: false,
insertRowsAtSetup: true,
transactionCallback: null,
customRunTransactions: customRunTransactions
});
</script>
</body>
</html>