How to write mongodb search in golang using mgo

Question

Here is my JSON file:

[{
    "name": "chetan",
    "age": 23,
    "hobby": ["cricket", "football"]
}, {
    "name": "raj",
    "age": 24,
    "hobby": ["cricket", "golf"]
}]

Here is the golang code I tried but didn't work as expected.

id:= "ket"
c.EnsureIndexKey("hobby")
err = c.Find(bson.M{"$hobby": bson.M{"$search": id,},}).All(&result)

It gives error:

$hobby exit status 1

Are you trying to find documents with hobbies that contain the text ket? — John Smith
– John Smith, Commented May 19, 2016 at 12:09
yes i want to find the whose hobby contain ket like cricket in ket — Chetan Kumar
– Chetan Kumar, Commented May 19, 2016 at 12:11

John Smith · Accepted Answer · 2016-05-19 12:22:13Z

2

From $search I'm assuming you're trying to use a text index/search, but in your case that wouldn't work. Text index doesn't support partials. You can still use regex to find those documents, but performance wise it wouldn't be a wise choice probably, unless you can utilize the index - which in your case wouldn't happen.

Still, you could achieve what you want with:

id := "ket"
regex := bson.M{"$regex": bson.RegEx{Pattern: id}}
err = c.Find(bson.M{"hobby": regex}).All(&result)

answered May 19, 2016 at 12:22

John Smith

2,3414 gold badges23 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to write mongodb search in golang using mgo

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related