Remove old sessions (OpenCGA version < 1.2)

removeSessions.js

// Extracted from https://stackoverflow.com/questions/3066586/get-string-in-yyyymmdd-format-from-js-date-object
Date.prototype.opencgaDate = function() {
  // We will get the current day minus 7 days
  this.setDate(this.getDate() - 7);
  var mm = this.getMonth() + 1; // getMonth() is zero-based
  var dd = this.getDate();

  return [this.getFullYear(),
          (mm>9 ? '' : '0') + mm,
          (dd>9 ? '' : '0') + dd,
          "000000"
         ].join('');
};

// date will have OpenCGA format with current date - 7
date = parseInt(new Date().opencgaDate());

var users = db.user.find();
for (var i = 0; i < users.length(); i++) {
    var user = users[i];
    var sessions = user.sessions;
    var newSessions = [];
    for (var j = 0; j < sessions.length; j++) {
        var session = sessions[j];
        if (parseInt(session.date) > date) {
            // We only keep the newest sessions
            newSessions.push(session);
        }
    }

    // We only update if there's any modification in the session array
    if (newSessions.length != sessions.length) {
        db.user.update({"_id": user._id}, {$set: {"sessions": newSessions}});
    }
}