Golang Bson sort parameters in mgo

sorting go bson mgo
Glenn Walker picture Glenn Walker · Oct 2, 2015 · Viewed 7.7k times · Source

I am trying to pass a multiple sort query to the "Sort" parameter of the mgo package (see https://godoc.org/labix.org/v2/mgo#Query.Sort).

If the parameters are dynamic (currently held in a slice), how can I translate that into a valid sort string.

A working example would be:

db.C(Collection).Find(Query).Limit(limit).Sort("-created_when", "-title").Iter()

But if "-created_when" and "-title" are held in a slice, and I try using a slice join like:

sortBy := []string{"-created_when", "title"}
db.C(Collection).Find(Query).Limit(limit).Sort(strings.Join(sortBy, ",")).Iter()

The query doesn't work correctly.

How can I translate the arbitrary fields in the slice into the .Sort([string1], [string2], ...) format required??

Answer

OneOfOne picture OneOfOne · Oct 2, 2015

Like this:

db.C(Collection).Find(Query).Limit(limit).Sort(sortBy...).Iter()

Related questions

What is the shortest way to simply sort an array of structs by (arbitrary) field names?

I just had a problem where I had an array of structs, e.g. package main import "log" type Planet struct { Name string `json:"name"` Aphelion float64 `json:"aphelion"` // in million km Perihelion float64 `json:"perihelion"` // in million km Axis …

Read More
How to sort a Map[string]int by its values?

Given this code block map[string]int {"hello":10, "foo":20, "bar":20} I would like to print out foo, 20 bar, 20 hello, 10 In the order of highest to lowest Thanks!

Read More
In Golang, how can I sort a list of strings alphabetically without completely ignoring case?

I want the strings to be sorted alphabetically with control over whether "A" comes before "a". In the Less() function using strings.ToLower() doesn't achieve this. Sometimes "A" comes before "a", and sometimes after.

Read More