PetitTetonMeteor/server/enhanceSaleDateFields.js

//
// This routine will update the database sales records to take the sales.date field which is YYYYMMDD and add sales.timestamp and sales.weekOfYear fields that duplicate the sales.date field but provide enhanced search capabilities.
// This routine does not change sales.date.  It can be run repeatedly without any problems.
//
// The problems this solves:
// 1. Searching by the week of the year is faster since it does not need to be calculated.
// 2. Searching by using date routines is easier since a conversion from string to date is not required (it is also apparently not possible in the current version of MongoDB).
// 3. Keeping the date field as YYYYMMDD makes sorting and avoiding timezone conversion errors easier.
//

Meteor.methods({
	// Cleans up all Date objects that don't have a time component.  Removes any time component.
	"enhanceSalesDateFields": async function() {
		let sales = await Sales.find({}).fetchAsync();

		for(let i = 0; i < sales.length; i++) {
			let dateString = sales[i].date.toString();
			let timestamp = new Date(Date.UTC(parseInt(dateString.substring(0, 4)), parseInt(dateString.substring(4,6)) - 1, parseInt(dateString.substring(6,8))));
			let weekOfYear = timestamp.getUTCWeek();
			
			if(sales[i]._id === "s9hJLRsQhha3w3ce2") {
				console.log(parseInt(dateString.substring(6,8)));
				console.log("Converted " + sales[i].date + " to " + timestamp + " where the week # is " + weekOfYear);
			}
			
			// Save to the database.
			await Sales.updateAsync(sales[i]._id, {$set: {"timestamp": timestamp.getTime(), weekOfYear}}, {bypassCollection2: true}, function(err, id) {
				if(err) console.log(err);
			});
		}
		
		console.log("Finished enhancing the dates of the Sales entries.");
	}
});