Guest User

Untitled

a guest
Mar 23rd, 2018
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.04 KB | None | 0 0
  1. from pymongo import MongoClient
  2. from bson.objectid import ObjectId
  3. import os,pymongo
  4. dbuser = os.environ.get('muser', '')
  5. dbpass = os.environ.get('mpwd', '')
  6. uri = 'mongodb://{dbuser}:{dbpass}@machineip/test'.format(**locals())
  7. client = MongoClient(uri)
  8. db = client.data
  9. collection = db['test']
  10. print db.version
  11.  
  12. cursor = collection.find({})
  13. for document in cursor:
  14. if document['version'] == '9.130.39.0.32.6.1':
  15. for project in document['projects']:
  16. project_id = project['_id']
  17. if project['submission']['status'] != 'queued':
  18. project.update(
  19. { "_id" : ObjectId(project_id)
  20. },
  21. { "$set":
  22. {
  23. "status": "queued"
  24. }
  25.  
  26. Traceback (most recent call last):
  27. File "script.py", line 23, in <module>
  28. "status": "queued"
  29. TypeError: update expected at most 1 arguments, got 2
  30.  
  31. {
  32. "_id" : ObjectId("5a95a1c32a2e2e0025e6d6e2"),
  33. "status" : "Submitting",
  34. "sanity" : "none",
  35. "version" : "9.130.39.0.32.6.1",
  36. "requestTime" : ISODate("2018-02-27T18:21:55.764Z"),
  37. "projects" : [
  38. {
  39. "name" : "BCMFurm_4364_B2_ekans",
  40. "_id" : ObjectId("5a95a1c32a2e2e0025e6d6eb"),
  41. "submission" : {
  42. "status" : "passed", --> this status should change to "queued"
  43. "system" : "machine.com"
  44. }
  45. },
  46. {
  47. "name" : "BCMFurm_4364_B2_sid",
  48. "_id" : ObjectId("5a95a1c32a2e2e0025e6d6ea"),
  49. "submission" : {
  50. "status" : "passed",--> this status should change to "queued"
  51. "system" : "machine.com"
  52. }
  53. },
  54. {
  55. "name" : "BCMFurm_4364_Notes",
  56. "_id" : ObjectId("5a95a1c32a2e2e0025e6d6e3"),
  57. "submission" : {
  58. "status" : "passed",--> this status should change to "queued"
  59. "system" : "machine.com"
  60. }
  61. }
  62. ],
  63. "Notes" : [],
  64. }
Add Comment
Please, Sign In to add comment