Scuilion/gist:d1609aa3bcdf606be163

## gistfile1.txt
<html>
    <head>
        <script>
            var standup = {};
            standup.webdb = {};
            standup.webdb.db = null;
            standup.webdb.open = function() {
                var dbSize = 5 * 1024 * 1024; // 5MB
                standup.webdb.db = openDatabase("Standup", "1", "standup manager", dbSize);
            }
            standup.webdb.onError = function(tx, e) {
                alert("there has been and error: " + e.message);
            }
            standup.webdb.onSuccess = function(tx, r) {
                var loadDailyStatusItems = function(tx, rs) {
                    var rowOutput;
                    var mainDiv = document.getElementById("dailyStatus");
                    for (var i=0; i < rs.rows.length; i++) {
                        rowOutput += rs.rows[i].ID + ': ' + rs.rows[i].NAME + ': ' + rs.rows[i].added_on + "</br>";
                        //rowOutput += JSON.stringify(rs.rows[i], null, 2);

                    }
                    mainDiv.innerHTML = rowOutput;
                }
                standup.webdb.getAllDailyStatusItems(loadDailyStatusItems);
            }

            standup.webdb.getAllDailyStatusItems = function(renderFunc) {
                var db = standup.webdb.db;
                db.transaction(function(tx) {
                    tx.executeSql("SELECT * FROM standup", [], renderFunc,
                                standup.webdb.onError);
                });
            }
            standup.webdb.createTable = function() {
                var db = standup.webdb.db;
                db.transaction(function(tx) {
                    tx.executeSql("DROP TABLE standup");
                    tx.executeSql("CREATE TABLE IF NOT EXISTS " +
                                   "standup(ID INTEGER PRIMARY KEY ASC, " +
                                   "NAME varchar(20), added_on DATETIME)", []);
                });
            }
            standup.webdb.addStatus = function(dailyStatus) {
                var db = standup.webdb.db;
                db.transaction(function(tx){
                    var addedOn = new Date();
                    tx.executeSql("INSERT INTO standup(name, added_on) VALUES(?, ?)",
                        [dailyStatus, addedOn],
                        standup.webdb.onSuccess,
                        standup.webdb.onError);
                });
            }
            standup.webdb.init = function() {
                standup.webdb.open();
                standup.webdb.createTable();
                //standup.webdb.addStatus("something");
                //standup.webdb.addStatus("another thing");
            }

        </script>
    </head>
    <body onload="standup.webdb.init()">
        Here is a title
        <div id="dailyStatus"/>
    </body>
</html>
	<html>
	<head>
	<script>
	var standup = {};
	standup.webdb = {};
	standup.webdb.db = null;
	standup.webdb.open = function() {
	var dbSize = 5 * 1024 * 1024; // 5MB
	standup.webdb.db = openDatabase("Standup", "1", "standup manager", dbSize);
	}
	standup.webdb.onError = function(tx, e) {
	alert("there has been and error: " + e.message);
	}
	standup.webdb.onSuccess = function(tx, r) {
	var loadDailyStatusItems = function(tx, rs) {
	var rowOutput;
	var mainDiv = document.getElementById("dailyStatus");
	for (var i=0; i < rs.rows.length; i++) {
	rowOutput += rs.rows[i].ID + ': ' + rs.rows[i].NAME + ': ' + rs.rows[i].added_on + "</br>";
	//rowOutput += JSON.stringify(rs.rows[i], null, 2);

	}
	mainDiv.innerHTML = rowOutput;
	}
	standup.webdb.getAllDailyStatusItems(loadDailyStatusItems);
	}

	standup.webdb.getAllDailyStatusItems = function(renderFunc) {
	var db = standup.webdb.db;
	db.transaction(function(tx) {
	tx.executeSql("SELECT * FROM standup", [], renderFunc,
	standup.webdb.onError);
	});
	}
	standup.webdb.createTable = function() {
	var db = standup.webdb.db;
	db.transaction(function(tx) {
	tx.executeSql("DROP TABLE standup");
	tx.executeSql("CREATE TABLE IF NOT EXISTS " +
	"standup(ID INTEGER PRIMARY KEY ASC, " +
	"NAME varchar(20), added_on DATETIME)", []);
	});
	}
	standup.webdb.addStatus = function(dailyStatus) {
	var db = standup.webdb.db;
	db.transaction(function(tx){
	var addedOn = new Date();
	tx.executeSql("INSERT INTO standup(name, added_on) VALUES(?, ?)",
	[dailyStatus, addedOn],
	standup.webdb.onSuccess,
	standup.webdb.onError);
	});
	}
	standup.webdb.init = function() {
	standup.webdb.open();
	standup.webdb.createTable();
	//standup.webdb.addStatus("something");
	//standup.webdb.addStatus("another thing");
	}

	</script>
	</head>
	<body onload="standup.webdb.init()">
	Here is a title
	<div id="dailyStatus"/>
	</body>
	</html>