Nuvolar/Nuvolar.Scanner.Android.Mobile/views/Test/Test.js

Nuvolar_Scanner_Android.Test = function (params) {
    "use strict";

    function errorHandler(transaction, error) {
        alert("Error : " + error.message + " in " + query);
    }

    var viewModel = {
        onClick: function (e) {
            var db = openDatabase('mydb', '1.0', 'Test DB', 10 * 1024 * 1024);
            var msg;

            db.transaction(function (tx) {
                //tx.executeSql('CREATE TABLE IF NOT EXISTS LOGS (id unique, log)',null,errorHandler);
                tx.executeSql('CREATE TABLE IF NOT EXISTS Products (id unique, ProductNumber, ShortName,Barcode)');
                //tx.executeSql('INSERT INTO LOGS (id, log) VALUES (1, "foobar")');
                //tx.executeSql('INSERT INTO LOGS (id, log) VALUES (2, "logmsg")');
                tx.executeSql('INSERT INTO LOGS (id, log) VALUES (4, "Varuba")');
                tx.executeSql('INSERT INTO LOGS (id, log) VALUES (3, "minyime")');
                msg = '<p>Log message created and row inserted.</p>';
                document.querySelector('#status').innerHTML = msg;
            });

            db.transaction(function (tx) {
                tx.executeSql('SELECT * FROM LOGS', [], function (tx, results) {
                    var len = results.rows.length, i;
                    msg = "<p>Found rows: " + len + "</p>";
                    document.querySelector('#status').innerHTML += msg;

                    for (i = 0; i < len; i++) {
                        msg = "<p><b>" + results.rows.item(i).log + "</b></p>";
                        document.querySelector('#status').innerHTML += msg;
                    }

                    

                }, null);
            });
        }

    };

    return viewModel;
};