Golang MongoDB Update Query Using Operator IN

Question

Achievement that I want got is query like this in MySQL

UPDATE FROM inbox
SET unread = unread + 1
WHERE
projectID = ? AND
userID IN ("A", "B, "C")

Is MongoDB have query IN like that in MySQL?

I have tried this in Go using https://github.com/mongodb/mongo-go-driver

_, err = m.db.Collection("inbox_counter").UpdateMany(ctx, bson.M{
     "userID":    bson.D{{"$in", userIDs}},
     "projectID": e[0].ProjectID,
}, bson.D{
     {"$inc", bson.D{{"unread", 1}}},
}, options.Update().SetUpsert(true))

But it have no effect to my collections

How does userIDs look like?

thammada.ts
– thammada.ts

2020-07-16 04:12:16 +00:00
Commented Jul 16, 2020 at 4:12 — thammada.ts
– thammada.ts, Commented Jul 16, 2020 at 4:12
@thammada.ts userIDs is []string it is array of user id

mghifariyusuf
– mghifariyusuf

2020-07-16 10:18:51 +00:00
Commented Jul 16, 2020 at 10:18 — mghifariyusuf
– mghifariyusuf, Commented Jul 16, 2020 at 10:18

mkdior · Accepted Answer · 2021-12-27 14:40:16Z

1

Use bson.M{"$in": userIDs} instead of bson.D{{"$in", userIDs}} in filter and for update use bson.M{"$inc": bson.M{"unread": 1}} instead bson.D{{"$inc", bson.D{{"unread", 1}}}}

_, err = m.db.Collection("inbox_counter").UpdateMany(ctx, bson.M{
     "userID":    bson.M{"$in": userIDs},
     "projectID": e[0].ProjectID,
},bson.M{"$inc": bson.M{"unread": 1}}, options.Update().SetUpsert(true))

edited Dec 27, 2021 at 14:40

mkdior

12510 bronze badges

answered Jul 16, 2020 at 4:09

Eklavya

18.6k4 gold badges33 silver badges62 bronze badges

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

1 Comment

mghifariyusuf Over a year ago

I haven't tried this yet but my friend said that you can use $in for Find method only. For now I'm using BulkWrite and define UpdateOne before as []*mongo.Model. Is there different performance with your code?

Collectives™ on Stack Overflow

Golang MongoDB Update Query Using Operator IN

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related