aggregation framework - mongoDb: aggregate document references to subgroups -


i've set of bson documents in mongodb collection want process according form cascading sub-documents. there thousand of duplicate id's differentiated timestamps , documents type subsystem-> component -> subcomponent; , should attached each other based on source. sample have:

[{     "id": 1001,     "type": "subsystem",     "time": 1454767739,     "payload": {         "key": "..."     } }, {     "id": 1001,     "type": "subsystem",     "time": 1454767539,     "payload": {         "key": "..."     } }, {     "id": 2001,     "type": "component",     "time": 1454767778,     "source": 1001,     "payload": {         "key": "..."     } }, {     "id": 5002,     "type": "subcomponent",     "time": 1454767779,     "source": 2001,     "payload": {         "key": "..."     } }, {     "id": 5003,     "type": "subcomponent",     "time": 1454767798,     "source": 2001,     "payload": {         "key": "..."     } }]

and trying this:

  1. match elements timestamp lower maxtime value
  2. group elements (unique) id, use newest value ($max: $time) $$root (every id unique now)
  3. group attribute source array element id (or _id)

i've achieved 1.) , 2.) have group:

[{     "_id": 1001,     "reftime": 1454767739,     "element": [         {             "id": 1001,             "type": "subsystem",             "time": 1454767739,             "payload": {                 "key": "..."             }         }     ]  }, {     "_id": 2001,     "reftime": 1454767778,     "element": [         {             "id": 2001,             "type": "component",             "time": 1454767778,             "source": 1001,             "payload": {                 "key": "..."             }         }      ] }, {     "_id": 5002,     "reftime": 1454767779,     "element": [         {             "id": 5002,             "type": "subcomponent",             "time": 1454767779,             "source": 2001,             "payload": {                 "key": "..."             }         }     ] }, {     "_id": 5003,     "reftime": 1454767798,     "element": [         {             "id": 5003,             "type": "subcomponent",             "time": 1454767798,             "source": 2001,             "payload": {                 "key": "..."             }         }     ] }]

but want elements structured according links in source value. this:

{     "_id": 1001,     "reftime": 1454767739,     "element": [         {             "id": 1001,             "type": "subsystem",             "time": 1454767739,             "payload": {                 "key": "..."             }         }     ],     "attached": [         {             "_id": 2001,             "reftime": 1454767778,             "element": [                 {                     "id": 2001,                     "type": "component",                     "time": 1454767778,                     "source": 1001,                     "payload": {                         "key": "..."                     }                 }             ],             "attached": [                 {                     "_id": 5002,                     "reftime": 1454767779,                     "element": [                         {                             "id": 5002,                             "type": "subcomponent",                             "time": 1454767779,                             "source": 2001,                             "payload": {                                 "key": "..."                             }                         }                     ]                 },                 {                     "_id": 5003,                     "reftime": 1454767798,                     "element": [                         {                             "id": 5003,                             "type": "subcomponent",                             "time": 1454767798,                             "source": 2001,                             "payload": {                                 "key": "..."                             }                         }                     ]                 }                              ]         }             ]  }

is possible? i'm struggling form group has source , combine group sample 2.). or if help, introduce source: 0? every subsystem , group under single root element?

any ideas or insights? i'm stuck @ point. thank you!


Comments

Post a Comment

Popular posts from this blog

routing - AngularJS State management ->load multiple states in one page -

Image
i developing site in angularjs ui-router. have situation on button click need change , load 3 state page , 3 looks image .please me how can load multiple pages. in 1 page you need configure router config this: $stateprovider .state("state1", { url: "/url1", controller: "firstcontroller", views: { view1: { templateurl: "templates/template1.html" }, view2: { templateurl: "templates/template2.html" }, view3: { templateurl: "templates/template3.html" } } }).state("state2", { url: "/url2", controller: "secondcontroller", views: { view1: { templateurl: "templates/template4.html" }, view2: { templateurl: "templates/template5.html" }, view3: { templateurl: "templates/template6.html" } }).state("state3", { ...
Read more

python - GRASS parser() error -

i'm trying use grass on python 2.7, i'm having problems @ setting script on idle, i'm getting error @ parser() function: here script: import os import sys gisbase = os.environ['gisbase'] = 'c:\program files (x86)\grass gis 7.0.1rc1' gisrc = 'c:\grassdata' gisdbase = 'c:\grassdata' location = 'newlocation' mapset = 'tc' ld_library_path = 'c:\program files (x86)\grass gis 7.0.1rc1\lib' path = 'c:\program files (x86)\grass gis 7.0.1rc1\etc';'c:\program files (x86)\grass gis 7.0.1rc1\etc\python';'c:\program files (x86)\grass gis 7.0.1rc1\lib';'c:\program files (x86)\grass gis 7.0.1rc1\bin';'c:\python27';'c:\program files (x86)\grass gis 7.0.1rc1\python27';'c:\program files (x86)\grass gis 7.0.1rc1\msys' pythonlib = 'c:\python27' pythonpath = 'c:\program files (x86)\grass gis 7.0.1rc1\etc\python' sys.path.append(os.path.join(os.environ['...
Read more

Swift game error message -

i following ios game tutorial. cannot figure out wrong here. error on these 2 lines. let newangle = percent * 180 - 180 cannon.zrotation = cgfloat(newangle) * cgfloat(m_pi); 180.0 //error "use of unresolved identifier 'percent'" the tutorial uses: cannon.zrotation = cgfloat(newangle) * cgfloat(m_pi)/ 180.0 but changed error suggested import spritekit class gamescene: skscene { var cannon: skspritenode! var touchlocation:cgpoint = cgpointzero override func didmovetoview(view: skview) { /* setup scene here */ cannon = self.childnodewithname("cannon") as! skspritenode } override func touchesbegan(touches: set<uitouch>, withevent event: uievent?) { /* called when touch begins */ touchlocation = touches.first!.locationinnode(self) } override func touchesmoved(touches: set<uitouch>, withevent event: uievent?) { touchlocation = touches.first!.locationinn...
Read more