Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var db = openDatabase("WorkerFoo", "", "", 1),
- results = [];
- //if(db) postMessage('Web Worker DB Built');
- db.transaction( function(tx) {
- tx.executeSql('CREATE TABLE IF NOT EXISTS foos (id REAL UNIQUE, label TEXT, timestamp REAL)', [], function (tx, result) {
- postMessage(result)
- }, function (tx, error) {
- postMessage(error)
- });
- });
- //if(db) postMessage('Table Created');
- db.transaction( function(tx) {
- tx.executeSql("INSERT INTO foos (label, timestamp) values(?, ?)", ['Foo!', new Date().getTime() ], null, null);
- });
- //if(db) postMessage('Data Inserted');
- db.transaction( function(tx){
- tx.executeSql('SELECT * FROM foos', [], function (tx, resultset) {
- var len = resultset.rows.length, i;
- for (i = 0; i < len; i++) {
- results[results.length] = resultset.rows.item(i);
- }
- });
- });
- postMessage(results);
Add Comment
Please, Sign In to add comment