OLD | NEW |
| (Empty) |
1 <!DOCTYPE HTML> | |
2 <html> | |
3 <title>Pseudo-random transactions</title> | |
4 <script src="../head.js"></script> | |
5 <script src="../common.js"></script> | |
6 <script> | |
7 var SELECT_STATEMENT_IN_READ_TRANSACTION = 0; | |
8 var SELECT_STATEMENT_IN_TRANSACTION = 1; | |
9 var INSERT_STATEMENT = 2; | |
10 var UPDATE_STATEMENT = 3; | |
11 var DELETE_STATEMENT = 4; | |
12 var STATEMENTS = | |
13 [2, 0, 4, 2, 2, 2, 2, 2, 1, 4, 1, 1, 0, 2, 0, 0, 2, 1, 2, 0, | |
14 4, 4, 2, 3, 3, 4, 3, 1, 3, 3, 2, 4, 3, 3, 2, 3, 1, 1, 4, 2, | |
15 4, 1, 4, 2, 3, 0, 4, 2, 4, 0, 4, 3, 3, 2, 0, 2, 1, 4, 4, 4, | |
16 4, 2, 3, 2, 0, 3, 3, 0, 4, 4, 4, 2, 3, 1, 4, 2, 4, 2, 3, 0, | |
17 2, 4, 0, 4, 2, 2, 4, 0, 3, 2, 3, 2, 3, 2, 0, 0, 4, 0, 2, 0]; | |
18 | |
19 var transactionsCompleted = 0; | |
20 var startTime = 0; | |
21 | |
22 function statementSuccessCallback(tx, data) {} | |
23 function statementErrorCallback(tx, error) {} | |
24 | |
25 function transactionSuccessCallback() { | |
26 if (++transactionsCompleted == TRANSACTIONS) | |
27 testComplete(Date.now() - startTime); | |
28 } | |
29 | |
30 function transactionErrorCallback(error) { | |
31 testComplete(TEST_FAILED); | |
32 } | |
33 | |
34 function customRunTransactions(db) { | |
35 var selectIDCounter = 0; | |
36 var insertIDCounter = 0; | |
37 var updateIDCounter = 0; | |
38 var deleteIDCounter = 0; | |
39 var randomString = getRandomString(); | |
40 var randomStringForUpdates = getRandomString(); | |
41 startTime = Date.now(); | |
42 for (var i = 0; i < TRANSACTIONS; i++) { | |
43 switch (STATEMENTS[i % STATEMENTS.length]) { | |
44 case SELECT_STATEMENT_IN_READ_TRANSACTION: | |
45 db.readTransaction( | |
46 function(tx) { | |
47 tx.executeSql('SELECT * FROM Test WHERE ID = ?', | |
48 [selectIDCounter++], | |
49 statementSuccessCallback, statementErrorCallback); | |
50 }, transactionErrorCallback, transactionSuccessCallback); | |
51 break; | |
52 case SELECT_STATEMENT_IN_TRANSACTION: | |
53 db.transaction( | |
54 function(tx) { | |
55 tx.executeSql('SELECT * FROM Test WHERE ID = ?', | |
56 [selectIDCounter++], | |
57 statementSuccessCallback, statementErrorCallback); | |
58 }, transactionErrorCallback, transactionSuccessCallback); | |
59 break; | |
60 case INSERT_STATEMENT: | |
61 db.transaction( | |
62 function(tx) { | |
63 tx.executeSql('INSERT INTO Test VALUES (?, ?)', | |
64 [insertIDCounter++, randomString], | |
65 statementSuccessCallback, statementErrorCallback); | |
66 }, transactionErrorCallback, transactionSuccessCallback); | |
67 break; | |
68 case UPDATE_STATEMENT: | |
69 db.transaction( | |
70 function(tx) { | |
71 tx.executeSql('UPDATE Test SET Foo = ? WHERE ID = ?', | |
72 [randomStringForUpdates, updateIDCounter++], | |
73 statementSuccessCallback, statementErrorCallback); | |
74 }, transactionErrorCallback, transactionSuccessCallback); | |
75 break; | |
76 case DELETE_STATEMENT: | |
77 db.transaction( | |
78 function(tx) { | |
79 tx.executeSql('DELETE FROM Test WHERE ID = ?', | |
80 [deleteIDCounter++], | |
81 statementSuccessCallback, statementErrorCallback); | |
82 }, transactionErrorCallback, transactionSuccessCallback); | |
83 break; | |
84 default: | |
85 testComplete(TEST_FAILED); | |
86 return; | |
87 } | |
88 } | |
89 } | |
90 </script> | |
91 | |
92 <body> | |
93 <script> | |
94 runPerformanceTest({ | |
95 dbName: "PseudoRandomTransactions", | |
96 readOnly: false, | |
97 insertRowsAtSetup: true, | |
98 transactionCallback: null, | |
99 customRunTransactions: customRunTransactions | |
100 }); | |
101 </script> | |
102 </body> | |
103 </html> | |
OLD | NEW |