var callDatabase = function()

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);
    });


};