IdeaWeave server scripts

lowerCaseTags.js

var cursor = db.tags.find();

while ( cursor.hasNext() ) {
	var tag = cursor.next();

	tag.title = tag.title.trim().toLowerCase();
	db.tags.save(tag);
	print("Updated", tag.title);
}

removeDuplicateTags.js

var cursor = db.tags.find();
var validTags = [];

while ( cursor.hasNext() ) {
	var tag = cursor.next();
	var name = tag.title.trim().toLowerCase();
	
	if(validTags.indexOf(name) >= 0) {
		print("Removing", name);
		db.tags.remove({ _id: tag._id });
	} else {
		print("Skipping", name);
		validTags.push(name);
	}
}

removeOldChallengeProjectLinks.js

var cursor = db.challenges.find();

while ( cursor.hasNext() ) {
	var challenge = cursor.next();
	print("Examining challenge", challenge._id);

	var newProjects = [];
	for(var i = 0; i < challenge.projects.length; i++) {
		if(db.projects.findOne({ _id: challenge.projects[i] })) {
			print("  Including project", challenge.projects[i]);
			newProjects.push(challenge.projects[i]);
		} else {
			print("  ** EXCLUDING project", challenge.projects[i]);
		}
	}

	//print("  newProjects", newProjects)
	db.challenges.update({ _id: challenge._id }, { $set: { projects: newProjects } });
}

removeOldCreditLinks.js

var cursor = db.credits.find();

var creditsToRemove = [];

while ( cursor.hasNext() ) {
	var credit = cursor.next();
	print("Examining credit", credit._id);

	if(db.badges.findOne({ _id: credit.badge })) {
		print("  Badge exists");
	} else {
		print("  ** Badge does not exist");
		creditsToRemove.push(credit._id);
	}
}

print("Removing credits", creditsToRemove);
for(var i = 0; i < creditsToRemove.length; i++) {	
	db.credits.remove({ _id: creditsToRemove[i] }, { justOne: true });
}

updateTagCounts.js

var cursor = db.tags.find();

while ( cursor.hasNext() ) {
	var tag = cursor.next();

	tag.userCount = db.users.count({ tags: { $in: [tag._id] } });
	tag.projectCount = db.projects.count({ tags: { $in: [tag._id] } });
	tag.challengeCount = db.challenges.count({ tags: { $in: [tag._id] } });
	tag.ideaCount = db.ideas.count({ tags: { $in: [tag._id] } });
	tag.entityCount = tag.userCount + tag.projectCount + tag.challengeCount + tag.ideaCount;

	// Remove old count field
	delete tag.number;

	print("Updating tag", tag.title, "counts to", tag.userCount, tag.projectCount, tag.challengeCount, tag.ideaCount, tag.entityCount);
	db.tags.save(tag);
}