MTurk HIT DataBase Patch v1

Removes current day's hits from the DB to prepare it for the new update

K instalaci tototo skriptu si budete muset nainstalovat rozšíření jako Tampermonkey, Greasemonkey nebo Violentmonkey.

You will need to install an extension such as Tampermonkey to install this script.

K instalaci tohoto skriptu si budete muset nainstalovat rozšíření jako Tampermonkey nebo Violentmonkey.

K instalaci tohoto skriptu si budete muset nainstalovat rozšíření jako Tampermonkey nebo Userscripts.

You will need to install an extension such as Tampermonkey to install this script.

K instalaci tohoto skriptu si budete muset nainstalovat manažer uživatelských skriptů.

(Už mám manažer uživatelských skriptů, nechte mě ho nainstalovat!)

You will need to install an extension such as Stylus to install this style.

You will need to install an extension such as Stylus to install this style.

You will need to install an extension such as Stylus to install this style.

You will need to install a user style manager extension to install this style.

You will need to install a user style manager extension to install this style.

You will need to install a user style manager extension to install this style.

(Už mám manažer uživatelských stylů, nechte mě ho nainstalovat!)

// ==UserScript==
// @name        MTurk HIT DataBase Patch v1
// @namespace https://greasyfork.org/users/710
// @description Removes current day's hits from the DB to prepare it for the new update
// @include     https://www.mturk.com/mturk/dashboard
// @version     10
// @grant       none
// @require     http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js
// ==/UserScript==

var HITStorage = {};
var indexedDB = window.indexedDB || window.webkitIndexedDB ||
    window.mozIndexedDB;
window.IDBTransaction = window.IDBTransaction || window.webkitIDBTransaction || window.mozIDBTransaction;
window.IDBKeyRange = window.IDBKeyRange || window.webkitIDBKeyRange || window.mozIDBKeyRange;
HITStorage.IDBTransactionModes = { "READ_ONLY": "readonly", "READ_WRITE": "readwrite", "VERSION_CHANGE": "versionchange" };
var IDBKeyRange = window.IDBKeyRange;

HITStorage.indexedDB = {};
HITStorage.indexedDB = {};
HITStorage.indexedDB.db = null;

HITStorage.indexedDB.onerror = function(e) {
    console.log(e);
};
var v = 4;

var d = new Date(); // today!
nowYear = d.getFullYear();
nowMonth = d.getMonth()+1;
nowDay = d.getDate();
if (nowMonth < 10)
    nowMonth = "0"+nowMonth;
if (nowDay < 10)
    nowDay = "0"+nowDay;
var x = 40; // go back 45 days!
d.setDate(d.getDate() - x);
thenYear = d.getFullYear();
thenMonth = d.getMonth()+1;
thenDay = d.getDate();
if (thenMonth < 10)
    thenMonth = "0"+thenMonth;
if (thenDay < 10)
    thenDay = "0"+thenDay;
var now = nowYear+"-"+nowMonth+"-"+nowDay;
var then = thenYear+"-"+thenMonth+"-"+thenDay;

if (!localStorage["20150602fix"])
{
    if (confirm("This will delete all hits done from your DB from "+then+" through "+now))
    {
        localStorage["20150602fix"] = 1;
        var request = indexedDB.open("HITDB", 4);
        request.onsuccess = function(e) {
            HITStorage.indexedDB.db = e.target.result;
            var db = HITStorage.indexedDB.db;
            var trans = db.transaction(["HIT"], HITStorage.IDBTransactionModes.READ_WRITE);
            var store = trans.objectStore("HIT");
            range = IDBKeyRange.bound(then, now, false, false);

            store.index('date').openCursor(range).onsuccess = function(event) {
                var cursor = event.target.result;
                if (cursor)
                {
                    console.log(cursor.value.date);
                    cursor.delete();
                    cursor.continue();
                }
                else
                {
                    db.close();
                }
            };
        }
        request = indexedDB.open("HITDB", 4);
        request.onsuccess = function(e) {
            HITStorage.indexedDB.db = e.target.result;
            var db = HITStorage.indexedDB.db;
            var trans = db.transaction(["HIT"], HITStorage.IDBTransactionModes.READ_WRITE);
            var store = trans.objectStore("HIT");
            trans = db.transaction(["STATS"], HITStorage.IDBTransactionModes.READ_WRITE);
            store = trans.objectStore("STATS");

            console.log("Second");
            store.openCursor(range).onsuccess = function(event) {
                var cursor = event.target.result;
                if (cursor)
                {
                    console.log(JSON.stringify(cursor.value));
                    cursor.delete();
                    cursor.continue();
                }
                else
                {
                    db.close();
                }
            };
        }
    }
}