| OLD | NEW |
|---|
| (Empty) |
| 1 <html> | |
| 2 <script> | |
| 3 | |
| 4 // Open a Web SQL database. | |
| 5 var g_db = null; | |
| 6 if (typeof window.openDatabase == "undefined") { | |
| 7 document.write("Error: Web SQL databases are not supported."); | |
| 8 } | |
| 9 try { | |
| 10 g_db = openDatabase("test", "1.0", "test database", 1024 * 1024); | |
| 11 } catch(err) { | |
| 12 document.write("Error: cannot open database."); | |
| 13 } | |
| 14 | |
| 15 // Creates a table named "table1" with one text column named "data". | |
| 16 function createTable() { | |
| 17 if (!g_db) | |
| 18 return; | |
| 19 g_db.transaction( | |
| 20 function(tx) { | |
| 21 tx.executeSql("CREATE TABLE table1 (data TEXT)"); | |
| 22 }, | |
| 23 function(error) { | |
| 24 sendValueToTest(error); | |
| 25 }, | |
| 26 function() { | |
| 27 sendValueToTest("done"); | |
| 28 }); | |
| 29 } | |
| 30 | |
| 31 // Inserts a record into the database. | |
| 32 function insertRecord(text) { | |
| 33 g_db.transaction( | |
| 34 function(tx) { | |
| 35 tx.executeSql("INSERT INTO table1 VALUES (?)", [text]); | |
| 36 }, | |
| 37 function(error) { | |
| 38 sendValueToTest(error); | |
| 39 }, | |
| 40 function() { | |
| 41 sendValueToTest("done"); | |
| 42 }); | |
| 43 } | |
| 44 | |
| 45 // Gets all the records in the database, ordered by their age. | |
| 46 function getRecords() { | |
| 47 g_db.readTransaction(function(tx) { | |
| 48 tx.executeSql( | |
| 49 "SELECT data FROM table1 ORDER BY ROWID", | |
| 50 [], | |
| 51 function(tx, result) { | |
| 52 items = ""; | |
| 53 for (var i = 0; i < result.rows.length; i++) { | |
| 54 if (items != "") | |
| 55 items += ", "; | |
| 56 items += result.rows.item(i).data; | |
| 57 } | |
| 58 sendValueToTest(items); | |
| 59 }, | |
| 60 function(tx, error) { | |
| 61 sendValueToTest(error); | |
| 62 }); | |
| 63 }); | |
| 64 } | |
| 65 | |
| 66 function sendValueToTest(value) { | |
| 67 //alert(value); | |
| 68 window.domAutomationController.setAutomationId(0); | |
| 69 window.domAutomationController.send(value); | |
| 70 } | |
| 71 | |
| 72 </script> | |
| 73 | |
| 74 <body> | |
| 75 This page is used for testing Web SQL databases. | |
| 76 </body> | |
| 77 </html> | |
| OLD | NEW |
|---|
Chromium Code Reviews
Issue 10879018:
Convert the Web SQL Database pyauto test to content_browsertests. (Closed)
Base URL: svn://chrome-svn/chrome/trunk/src/