how convert mongo shell command to mongocxx grammar

Question

db.members.find( {"groupId": 115, userId: { $in: [ 1000, 1001 ] } } );

I find a lot of place, include MongoDB/GitHub. but no use, Who can tell me how to implement this query use c++, thank you very much!

as follow can not work:

auto members = bsoncxx::builder::basic::array{};
for (vector<string>::size_type i = 0; i != userIds.size(); ++i) {
        int id = std::atoi(userIds[i].c_str());
        bsoncxx::builder::basic::document doc;
        doc.append(kvp("userId", id));
        members.append(doc);
    }

auto docValue = make_document(kvp("id", gid), kvp("$in", members)));
auto res = coll.delete_many(docValue.view());

as follow can not query success, but the shell can find result. — H.He, Feb 08 '18 at 08:59

score 0 · Accepted Answer · answered Feb 08 '18 at 19:23

0

Did you try printing out mongocxx:to_json(docValue) to see what it looks like? I predict it doesn't look like you think. It is going to come out with something like $in : [ { 'userId' : 1001, 'userId' : 1002, ... } ].

Instead, just append to members directly inside the loop:

auto members = bsoncxx::builder::basic::array{};
for (vector<string>::size_type i = 0; i != userIds.size(); ++i) {
        int id = std::atoi(userIds[i].c_str());
        members.append(id);
    }

answered Feb 08 '18 at 19:23

acm

12,183
5
39
68

Thank you very much!According to you, it works well. `auto docValue = make_document(kvp("groupId", 115), kvp("userId", make_document(kvp("$in", members))));` – H.He Feb 09 '18 at 01:52

how convert mongo shell command to mongocxx grammar

1 Answers1