Support collation for MongoDB 3.4+

[cchantep]

No description provided.

[seyuf]

👍 for the collation!

[st3ffan]

Hello @cchantep - Is collation a work in progress / is anyone working on this right now? I'd like to assist if possible

[cchantep]

No WIP

[abdvel]

Why?

[cchantep]

... Because it need to be develop, but nothing ongoing

[lglossman-ring]

@cchantep I see that on 0.16, collation has been added, but at least when using it with 'unique', it doesn't seem to make any effect. Is it really implemented?

[cchantep]

If this is still open, there is still work to be done.

[Marcnuth]

any updates or plan on this?

[cchantep]

any updates or plan on this?

Partial support. Be more specific if you expect something.

[JasonRoyChen]

any updates or plan on this?

Partial support. Be more specific if you expect something.

@cchantep Hi there, I need to use collation in find query to let query result sorted as case insensitive. Is this function already set up?

[cchantep]

any updates or plan on this?

Partial support. Be more specific if you expect something.

@cchantep Hi there, I need to use collation in find query to let query result sorted as case insensitive. Is this function already set up?

http://reactivemongo.org/releases/0.1x/api/reactivemongo/api/collections/GenericQueryBuilder.html#collation(collation:reactivemongo.api.Collation):GenericQueryBuilder.this.Self

[seyuf]

Hi,
hope this will help someone, it's kinda like a workaround but it is working, if you're doing aggregation.
Otherwise depending of one's reactivemongo version, one can simply set collation at index creation

def aggregate(pipeLine: BSONArray): Future[JsObject] = {

    val commandQuery = BSONDocument(
      "aggregate" -> "mycollection",
      "pipeline" -> pipeLine,
      "collation" -> BSONDocument("locale" -> "en", "strength" -> 1)
    )

    val runner = Command.run(BSONSerializationPack)
    db.flatMap(db => {
      runner.apply(db, runner.rawCommand(commandQuery)).one[JsObject]
    })
  }

[cchantep]

Hi,
hope this will help someone, it's kinda like a workaround but it is working, if you're doing aggregation.
Otherwise depending of one's reactivemongo version, one can simply set collation at index creation

def aggregate(pipeLine: BSONArray): Future[JsObject] = {

    val commandQuery = BSONDocument(
      "aggregate" -> "mycollection",
      "pipeline" -> pipeLine,
      "collation" -> BSONDocument("locale" -> "en", "strength" -> 1)
    )

    val runner = Command.run(BSONSerializationPack)
    db.flatMap(db => {
      runner.apply(db, runner.rawCommand(commandQuery)).one[JsObject]
    })
  }

Rather have a look at https://javadoc.io/doc/org.reactivemongo/reactivemongo_2.13/1.0.0/reactivemongo/api/collections/GenericCollection.html#aggregatorContext[T](pipeline:List[GenericCollection.this.PipelineOperator],explain:Boolean,allowDiskUse:Boolean,bypassDocumentValidation:Boolean,readConcern:reactivemongo.api.ReadConcern,readPreference:reactivemongo.api.ReadPreference,writeConcern:reactivemongo.api.WriteConcern,batchSize:Option[Int],cursorOptions:reactivemongo.api.CursorOptions,maxTime:Option[scala.concurrent.duration.FiniteDuration],hint:Option[GenericCollection.this.Hint],comment:Option[String],collation:Option[reactivemongo.api.Collation])(implicitreader:GenericCollection.this.pack.Reader[T]):GenericCollection.this.AggregatorContext[T]

[seyuf]

Thanks @cchantep you're the mvp ;)