1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
|
<!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>
|
