in www/sql/index.js [37:88]
var callDatabase = function(index) {
var db = dbs[index] = openDb(index);
if (!db) {
return;
}
databaseOutput("Database opened.");
db.transaction(function (tx) {
tx.executeSql('DROP TABLE IF EXISTS DEMO');
tx.executeSql('CREATE TABLE IF NOT EXISTS DEMO (id unique, data)', [],
function(tx,results) { console.log("Created table"); },
function(tx,err) { alert("Error creating table: "+err.message); });
tx.executeSql('INSERT INTO DEMO (id, data) VALUES (1, "First row")', [],
function(tx,results) { console.log("Insert row1 success"); },
function(tx,err) { alert("Error adding 1st row: "+err.message); });
tx.executeSql('INSERT INTO DEMO (id, data) VALUES (2, "Second row")', [],
function(tx,results) { console.log("Insert row2 success"); },
function(tx,err) { alert("Error adding 2nd row: "+err.message); });
databaseOutput("Data written to DEMO table.");
console.log("Data written to DEMO table.");
tx.executeSql('SELECT * FROM DEMO', [], function (tx, results) {
var len = results.rows.length;
var text = "DEMO table: " + len + " rows found.<br>";
text = text + "<table border='1'><tr><td>Row</td><td>Data</td></tr>";
for (var i=0; i<len; i++){
text = text + "<tr><td>" + i + "</td><td>" + results.rows.item(i).id + ", " + results.rows.item(i).data + "</td></tr>";
}
text = text + "</table>";
databaseOutput(text);
}, function(tx, err) {
alert("Error processing SELECT * SQL: "+err.message);
});
tx.executeSql('SELECT ID FROM DEMO', [], function (tx, results) {
var len = results.rows.length;
var text = "DEMO table: " + len + " rows found.<br>";
text = text + "<table border='1'><tr><td>Row</td><td>Data</td></tr>";
for (var i=0; i<len; i++){
text = text + "<tr><td>" + i + "</td><td>" + results.rows.item(i).id + "</td></tr>";
}
text = text + "</table>";
databaseOutput(text);
}, function(tx, err) {
alert("Error processing SELECT ID SQL: "+err.message);
});
},
function(err) {
console.log("Transaction failed: " + err.message);
});
};