Golang MongoDB delete multiple items in one query

Question

I have a match table in my DB and I need to delete multiple items from it and I was wondering if there is a way to do this using a single query. I get deleteList of type []primitive.ObjectID in my Go code. deleteList is basically a list of match.id that need to be deleted. I could easily do it ranging through my slice of deleteList and deleting all the matches 1 by 1, but I feel like there should be a more efficient way of doing it in one query instead of flooding my db with multiple queries.

Does anyone know a possible solution for this?

Thank you.

Can you please share some code that you tried?

Hamza Anis
– Hamza Anis

2022-09-27 09:14:29 +00:00
Commented Sep 27, 2022 at 9:14 — Hamza Anis
– Hamza Anis, Commented Sep 27, 2022 at 9:14

icza · Accepted Answer · 2022-09-27 09:15:50Z

2

You may use Collection.DeleteMany().

Construct a filter that matches any of your IDs, and pass that to DeleteMany() like this:

c := ...                      // acquire match collection
ids := []primitive.ObjectID{} // the id list to delete

filter := bson.M{"_id": bson.M{"$in": ids}}

if _, err := c.DeleteMany(ctx, filter); err != nil {
    // handle error
}

answered Sep 27, 2022 at 9:15

icza

423k78 gold badges1k silver badges905 bronze badges

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

Collectives™ on Stack Overflow

Golang MongoDB delete multiple items in one query

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