php - Doctrine ODM (MongoDB) MapReduce + Skip

332

I'm working on with a set where I need to use batch-querying due to Doctrine's - and Mongo's -reduce output limitations. However, I'm stupefied about how to do so.

Doctrine ODM'sMapReduce doesn't allow theSkip option. However, I've found and read about injecting a variable intoScope (let's sayn), where it can act as a global counter for theMapReduce, and with anif() check it can effectively skip emits where the counter is less thann.

However, those explanations were for MongoDB's JS implementations (mongoose etc.), whereas I'm working with Doctrine ODM, so I've no idea how to go about this.

Thanks in advance.

342

Answer

Solution:

After a bit of digging through theQueryBuilder class, I've foundmapReduceOptions(array) so added the following to my query after themap:

->mapReduceOptions(array('scope'=>array('skip'=>$BatchSkip,'counter'=>0)))`

i.e.

->map($map)
->mapReduceOptions(array('scope'=>array('skip'=>$BatchSkip,'counter'=>0)))
->reduce($reduce)
->getQuery()->execute()

I then wrapped everything in mymap function withif (counter >= skip && counter < (skip+100))

$map = "function(){
  if (counter >= skip && counter < (skip+100))
  { 
    .
    .
    .
    emit( key, value ); 
  }";

and I increment$BatchSkip in my PHP batch loop.

$BatchSkip+=100;

That does the trick. Reference: MongoDB mapReduce options: https://docs.mongodb.com/manual/reference/command/mapReduce/#mapreduce

People are also looking for solutions to the problem: php - how works or operator in if statements and print

Source

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question