converting mongodb arrays into python arrays

Question

I'm writing a code in which i find this kind of database (i'm using pymongo). How can i attribute these arrays inside the wishlist field to python arrays?

Alternatively, how can i search my database for a value inside an array inside the wishlist field. E.g.: i want to find all IDs that have, say, ["feldon","c15", "sp"] in their wishlists

{
    "_id" : "david",
    "password" : "azzzzzaa",
    "url" : "url3",
    "old_url" : "url3",
    "new_url" : ["url1", "url2"],
    "wishlist" : [
        ["all is dust", "mm4", "nm"],
        ["feldon", "c15", "sp"],
        ["feldon", "c15", "sp"],
        ["jenara", "shards", "nm"],
        ["rafiq", "shards", "nm"]
    ]
}

Sede · Accepted Answer · 2016-04-26 23:09:34Z

1

You can use distinct if elements in your sublist and are exactly in the same order.

db.collection.distinct("_id", {"wishlist": ["feldon", "c15", "sp"]})

If not, you need to use the aggregate method and the $redact operator.

db.collection.aggregate([
    {"$redact": {
        "$cond": [
            {"$setIsSubset": [
                [["feldon","c15", "sp"]], 
                "$wishlist"
            ]}, 
            "$$KEEP",
            "$$PRUNE"
        ]
    }}, 
    {"$group": {
        "_id": None, 
        "ids": {"$push": "$_id"}
    }}
])

answered Apr 26, 2016 at 23:09

Sede

61.5k20 gold badges158 silver badges162 bronze badges

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

Collectives™ on Stack Overflow

converting mongodb arrays into python arrays

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