☰

Clear BLOCK table in HITDB

Completely empty the BLOCK table in HITDB

  1. // ==UserScript==
  2. // @name        Clear BLOCK table in HITDB
  3. // @namespace   localhost
  4. // @description Completely empty the BLOCK table in HITDB
  5. // @include     https://www.mturk.com/mturk/dashboard
  6. // @require		http://code.jquery.com/jquery-2.1.1.js
  7. // @version     1.0.1
  8. // @grant       none
  9. // ==/UserScript==
  10. var HITStorage = {};
  11. var indexedDB = window.indexedDB || window.webkitIndexedDB || window.mozIndexedDB;
  12. window.IDBTransaction = window.IDBTransaction || window.webkitIDBTransaction || window.mozIDBTransaction;
  13. window.IDBKeyRange = window.IDBKeyRange || window.webkitIDBKeyRange || window.mozIDBKeyRange;
  14.  
  15. var IDBKeyRange = window.IDBKeyRange;
  16.  
  17. HITStorage.indexedDB = {};
  18. HITStorage.indexedDB = {};
  19. HITStorage.indexedDB.db = null;
  20.  
  21. HITStorage.indexedDB.onerror = function(e) {
  22.   console.log(e);
  23. };
  24. var v = 4;
  25.  
  26. HITStorage.indexedDB.deleteBLOCKS = function () {
  27.   var request = indexedDB.open("HITDB", v);
  28.   console.log("request starting");
  29.   request.onsuccess = function(e) {
  30.     
  31.     HITStorage.indexedDB.db = e.target.result;
  32.     var db = HITStorage.indexedDB.db;
  33. 	  var trans = db.transaction(["BLOCKS"], "readwrite");
  34.     var clearRequest = trans.objectStore("BLOCKS").clear();    
  35.     clearRequest.onsuccess = function (e) {
  36.       alert("BLOCKS deleted!");
  37.     }
  38.   }
  39. }
  40.  
  41. $('body').append("<button id='deleteBlocks' >Delete Blocks</button>");
  42.  
  43. $(document).on('click', '#deleteBlocks', function () {
  44.   console.log("Deleting blocks");
  45.   HITStorage.indexedDB.deleteBLOCKS();
  46. });