Guest User

Untitled

a guest
Jun 25th, 2018
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. var db = openDatabase("WorkerFoo", "", "", 1),
  2. results = [];
  3.  
  4.  
  5. //if(db) postMessage('Web Worker DB Built');
  6.  
  7.  
  8.  
  9. db.transaction( function(tx) {
  10.  
  11. tx.executeSql('CREATE TABLE IF NOT EXISTS foos (id REAL UNIQUE, label TEXT, timestamp REAL)', [], function (tx, result) {
  12. postMessage(result)
  13. }, function (tx, error) {
  14. postMessage(error)
  15. });
  16.  
  17. });
  18.  
  19.  
  20. //if(db) postMessage('Table Created');
  21.  
  22.  
  23. db.transaction( function(tx) {
  24. tx.executeSql("INSERT INTO foos (label, timestamp) values(?, ?)", ['Foo!', new Date().getTime() ], null, null);
  25. });
  26.  
  27.  
  28. //if(db) postMessage('Data Inserted');
  29.  
  30.  
  31. db.transaction( function(tx){
  32.  
  33. tx.executeSql('SELECT * FROM foos', [], function (tx, resultset) {
  34. var len = resultset.rows.length, i;
  35.  
  36. for (i = 0; i < len; i++) {
  37. results[results.length] = resultset.rows.item(i);
  38. }
  39. });
  40. });
  41.  
  42. postMessage(results);
Add Comment
Please, Sign In to add comment