Implement MongoDB query in Python

Question

i have this query and it is working in MongoDB Booster, but i don't understand why i can't only copy this in Python, as i do for query on MySQL, and what should I do with this query, so it can work normally in MongoDB

Query that works in MongoDB Booster but it doesn't work when i copy in Python looks like this:

db.bol_rac.aggregate( [
  {
    $project:
      {
        "id" : 1,
        "id_drz": 1,    
        "location" :
        {          
             $cond: { if: { $eq: [ "$id_drzavljanstvo", 688 ] }, then: "Country", else: "Foreign country" }          
         }
      }
   }
] );

Please show exactly how you tried to run this in Python.

Daniel Roseman
– Daniel Roseman

2017-10-14 16:43:04 +00:00
Commented Oct 14, 2017 at 16:43 — Daniel Roseman
– Daniel Roseman, Commented Oct 14, 2017 at 16:43

Milica Pavlovic · Accepted Answer · 2017-10-14 17:07:09Z

1

i mean on this, i have success to solve the problem, problem is that i haven't add '' on if,else,then ..

  from pymongo import MongoClient
    client = MongoClient()

    db = client.bol_rac

    cursor = db.bol_rac.aggregate([
      {
        '$project':
          {
            'id' : 1,
            'id_drz': 1,    
            'location' :
            {          
                 '$cond': { 'if': { '$eq': [ '$id_drz', 688 ] }, 'then': 'Country', 'else': 'Foreign country' }          
             }
          }
       }
    ])

    for document in cursor:
        print(document)

answered Oct 14, 2017 at 17:07

Milica Pavlovic

1098 bronze badges

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

Collectives™ on Stack Overflow

Implement MongoDB query in Python

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