Mongo scripts for fixing image ids on YNMP

fix-organization-image-ids.js

var organizations = db.organizations.find();

var re = new RegExp(/^http\:\/\/yournextmp.popit.mysociety.org\/organizations\/(\d+)\/image\/(\w+)/);

var needsSaving;
var updated = 0;

organizations.forEach(function(organization) {
  if (organization.images) {
    needsSaving = false;
    organization.images.forEach(function(image) {
      if (!(image._id instanceof ObjectId)) {
        var result = re.exec(image.url);
        if (result) {
          image._id = ObjectId(result[2]);
        } else {
          image._id = new ObjectId();
        }
        needsSaving = true;
      }
    });
    if (needsSaving) {
      db.organizations.save(organization);
      updated++;
    }
  }
});

print("Updated", updated, "records");

fix-person-image-ids.js

var people = db.persons.find();

var re = new RegExp(/^http\:\/\/yournextmp.popit.mysociety.org\/persons\/(\d+)\/image\/(\w+)/);

var needsSaving;
var updated = 0;

people.forEach(function(person) {
  if (person.images) {
    needsSaving = false;
    person.images.forEach(function(image) {
      if (!(image._id instanceof ObjectId)) {
        var result = re.exec(image.url);
        if (result) {
          image._id = ObjectId(result[2]);
        } else {
          image._id = new ObjectId();
        }
        needsSaving = true;
      }
    });
    if (needsSaving) {
      db.persons.save(person);
      updated++;
    }
  }
});

print("Updated", updated, "records");