Analysis methods for Mongodb for Health Data

gistfile1.rb

        def analyzeRestaurantNameCount
		return restaurantNameCount = @coll.aggregate([
		    { "$project" => {doc:{str:{fs_fnm: 1}}}},
		    { "$group" => {_id: "$doc.str.fs_fnm", number: { "$sum" => 1 }}},
		    { "$sort" => {"_id" => 1 }}
		])
	end

	def analyzeRestaurantCategoryCount
		restaurantCategoryCount = @coll.aggregate([
		    { "$project" => {doc:{str:{fs_ft_en: 1}}}},
		    { "$group" => {_id: "$doc.str.fs_ft_en", number: { "$sum" => 1 }}},
		    { "$sort" => {"_id" => 1 }}
		])

		# TODO clean up hash creation code with better namming
		newHash={}
		restaurantCategoryCount.each do |x|

			newHash[x["_id"][0]] = x["number"]

		end
		return newHash

	end

	def analyzeRestaurantStreetCount
		return restaurantStreetCount = @coll.aggregate([
		    { "$project" => {doc:{str:{fs_fss: 1}}}},
		    { "$group" => {_id: "$doc.str.fs_fss", number: { "$sum" => 1 }}},
		    { "$sort" => {"_id" => 1 }}
		])
	end

	def analyzeRestaurantCreationDateCount
		return restaurantCreationDateCount = @coll.aggregate([
		    { "$project" => {doc:{str:{fs_fcr_date: 1}}}},
		    { "$group" => {_id: "$doc.str.fs_fcr_date", number: { "$sum" => 1 }}},
		    { "$sort" => {"_id" => 1 }}
		])
	end

	def analyzeRestaurantsCreatedPerMonth
		return restaurantsCreatedPerMonth = @coll.aggregate([
		    { "$project" => {created_month: {"$month" => "$doc.str.fs_fcr_date"}}},
		    { "$group" => {_id: {"created_month" => "$doc.str.fs_fcr_date"}, number: { "$sum" => 1 }}},
		    { "$sort" => {"_id.created_month" => 1}}
		])

	end