from pymongo import MongoClient
    import os,pymongo
    dbuser = os.environ.get('muser', '')
    dbpass = os.environ.get('mpwd', '')
    uri = 'mongodb://{dbuser}:{dbpass}@machine.company.com:27017/wifiautomation'.format(**locals())
    client = MongoClient(uri)
    db = client.wifiautomation
    collection = db['test_audit']
    cursor = collection.find({})
    for document in cursor:
          if document['version'] == '9.130.39.0.32.6.1':
            #print document['projects']
            for project in  document['projects']:
                print project['name']
                #print project['submission']
                print project['submission']['status']
                if project['submission']['status'] !=queued:
                    project['submission']['status'] = 'queued'
                    #Update the field

{
    "_id" : ObjectId("5a95a9c32a2e2e0025e6d6e2"),
    "status" : "Submitting",
    "endRev" : "9539c3448d3f7793dc74c4b05d977ecf0c6e4df6",
    "chip" : "9234",
    "startRev" : "259e3f8f46630c2fae93f32679de5ab3c232f2ca",
    "audit" : " n",
    "sanity" : "none",
    "version" : "9.930.39.0.32.6.9",
    "branch" : "branch_9234",
    "directory" : "/SWE/Teams/Tech/Furn/submissions/9234/9.930.39.0.32.6.9",
    "requestTime" : ISODate("2098-02-27T98:29:55.764Z"),
    "projects" : [
        {
            "name" : "BCMFurn_9234_B2_code",
            "_id" : ObjectId("5a95a9c32a2e2e0025e6d6eb"),
            "submission" : {
                "status" : "passed",
                "system" : "machine.company.com"
            }
        },
        {
            "name" : "BCMFurn_9234_B2_sid",
            "_id" : ObjectId("5a95a9c32a2e2e0025e6d6ea"),
            "submission" : {
                "status" : "passed",
                "system" : "machine.company.com"
            }
        }
    ],
    "approvalNotes" : [],
    "stepping" : [],
    "__v" : 0,
    "tag" : "Official_9.930.39.0.32.6.9",
    "swe" : "trainname9A924"
}