www/sql/index.js

/*
 *
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance
 * with the License.  You may obtain a copy of the License at
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on an
 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 * KIND, either express or implied.  See the License for the
 * specific language governing permissions and limitations
 * under the License.
 *
*/

//-------------------------------------------------------------------------
// HTML5 Database
//-------------------------------------------------------------------------
var dbs = [];
var quotas = [2000000, 2000000];
var names = ['mydb', 'rand' + Math.random()];
function openDb(index) {
    try {
        databaseOutput('Openning db with name: ' + names[index]);
        return openDatabase(names[index], "1.0", "Apache Cordova Demo", quotas[index]);
    } catch (e) {
        databaseOutput('Got exception: ' + e);
    }
}

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


};

var readDatabase = function(index) {
    var db = dbs[index];
  if (!db) {
        db = dbs[index] = openDb(index);
        if (!db) {
            return;
        }
    }
    db.transaction(function (tx) {
        tx.executeSql('SELECT * FROM DEMO WHERE id=2', [], 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 * WHERE id=2 SQL: "+err.message);
        });
    });
}

function increaseQuota(index) {
    quotas[index] *= 2;
    databaseOutput('quota ' + index + ' is now ' + quotas[index]);
}

var databaseOutput = function(s) {
    var el = document.getElementById("database_results");
    el.innerHTML = el.innerHTML + s + "<br>";
};

/**
 * Function called when page has finished loading.
 */
function init() {
    document.addEventListener("deviceready", function() {
        console.log("Device="+device.platform+" "+device.version);
    }, false);
}

window.onload = function() {
  addListenerToClass('callDatabase0', callDatabase, [0]);
  addListenerToClass('readDatabase0', readDatabase, [0]);
  addListenerToClass('increaseQuota0', increaseQuota, [0]);
  addListenerToClass('callDatabase1', callDatabase, 1);
  addListenerToClass('readDatabase1', readDatabase, 1);
  addListenerToClass('increaseQuota1', increaseQuota, 1);
  addListenerToClass('reloadPage', function() {
    location = location.href;
  });
  addListenerToClass('backBtn', backHome);
  init();
}