We needed a way to Map/Reduce our search queries in CakePHP shells. This is our result. Built off of the incredible plugin, https://github.com/ichikaway/cakephp-mongodb

search_log.php

<?php

public function startup(){
	App::import('Datasource', 'Mongodb.Mongodb');
	$this->mongo = ConnectionManager::getDataSource($this->SearchLog->useDbConfig);
}

public function main(){
	$map    = 'function () { emit(this.slug, {count:1}); }';
	$reduce = 'function (key, values) { var count = 0; values.forEach(function (v) {count += v.count;}); return count; }';
	
	$map    = new MongoCode($map);
	$reduce = new MongoCode($reduce);
	
	$this->mongo->ensureIndex($this->SearchLog, array('slug' => 1));
	
	$this->out('Grouping search results into occurences...');
	
	$start = microtime(true);
	
	$this->mongo->mapReduce(array(
		'mapreduce' => $this->SearchLog->table,
		'map' => $map,
		'reduce' => $reduce,
		'out' => 'popular_searches' // Mongo will drop this collection and re-populate it (unless specified otherwise)
	));
	
	$this->out('Done!');
	$this->out('Took '.(microtime(true) - $start).' seconds');
}