Passing a String Variable into Pymongo Query

Question

I'm trying to scrape a database of information, but was having trouble querying. Here's the basic database setup in MongoDB:

{
  "ID": 346,
  "data": [
    {
      "number": "23",
      "name": "Winnie"
    },
    {
      "number": "12",
      "name": "Finn"
    },
    {
      "number": "99",
      "name": "Todd"
    }
  ]
}


{
  "ID": 346,
  "data": [
    {
      "number": "12",
      "name": "Ram"
    },
    {
      "number": "34",
      "name": "Greg"
    },
    {
      "number": "155",
      "name": "Arnie"
    }
  ]
}

relevant Python code is below:

import pymongo
import json
import io
import sys
from bson.json_util import dumps
from pymongo import MongoClient
stringArr = ['"23"', '"12"', '"155"']
for x in range(0, len(stringArr))
print(collection.find({"data.number" :  stringArr[x]}).count())

When I enter collection.find({"data.number" : "23"}).count() I return the correct number of entries that have "23" as the number in data, so I presume my syntax for find in Python to be messed up, likely having to do with the variable being a string, but I'm fairly inexperienced with MongoDB, let alone PyMongo. Any suggestion would be greatly appreciated!

why do you have '"155"' why not just '155'?

depperm
– depperm

2017-06-13 18:56:26 +00:00
Commented Jun 13, 2017 at 18:56 — depperm
– depperm, Commented Jun 13, 2017 at 18:56
this worked, thanks!!!!

dangus poochie
– dangus poochie

2017-06-13 19:07:01 +00:00
Commented Jun 13, 2017 at 19:07 — dangus poochie
– dangus poochie, Commented Jun 13, 2017 at 19:07

Rubin Porwal · Accepted Answer · 2017-06-14 05:37:15Z

1

$elemMatch operator is used to match values contained within an array field belonging to BSON document.

According to description as mentioned in above question please try executing following raw query in MongoDB shell.

    db.collection.find({
    data: {
        $elemMatch: {
            number: {
                $in: ["23", "12", "155"]
            }
        }
    }
})

answered Jun 14, 2017 at 5:37

Rubin Porwal

3,8451 gold badge27 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

Passing a String Variable into Pymongo 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