| OLD | NEW |
| (Empty) |
| 1 function runTransaction(db) | |
| 2 { | |
| 3 db.transaction(function(tx) { | |
| 4 // Execute a read-only statement | |
| 5 tx.executeSql("SELECT COUNT(*) FROM Test;"); | |
| 6 | |
| 7 // Execute a write statement to make sure SQLite tries to acquire an excl
usive lock on the DB file | |
| 8 tx.executeSql("INSERT INTO Test VALUES (?);", [1]); | |
| 9 }); | |
| 10 } | |
| 11 | |
| 12 var db1 = openDatabaseSync("MultipleTransactionsOnDifferentHandlesTest", "1.0", | |
| 13 "Test transactions on different handles to the same D
B.", 1); | |
| 14 db1.transaction(function(tx) { | |
| 15 tx.executeSql("CREATE TABLE IF NOT EXISTS Test (Foo int);"); | |
| 16 }); | |
| 17 | |
| 18 var db2 = openDatabaseSync("MultipleTransactionsOnDifferentHandlesTest", "1.0", | |
| 19 "Test transactions on different handles to the same D
B.", 1); | |
| 20 if (db1 == db2) | |
| 21 postMessage("FAIL: db1 == db2"); | |
| 22 else { | |
| 23 try { | |
| 24 runTransaction(db1); | |
| 25 runTransaction(db2); | |
| 26 postMessage("PASS"); | |
| 27 } catch (err) { | |
| 28 postMessage("FAIL: " + err); | |
| 29 } | |
| 30 } | |
| 31 | |
| 32 postMessage("done"); | |
| OLD | NEW |