MongoDB aggregation lookup -


i aggregate building floors , rooms:

given following 3 collections:

/* buildings */ {     "_id" : objectid("59a09abe388f595b15bb5fa6"),     "name" : "home" }  /* floors */ {     "_id" : objectid("59a09abe388f595b15bb5fa3"),     "buildingid" : objectid("59a09abe388f595b15bb5fa6"),     "name" : "upstairs" } {     "_id" : objectid("59a09abe388f595b15bb5fa2"),     "buildingid" : objectid("59a09abe388f595b15bb5fa6"),     "name" : "downstairs" }  /* rooms */ {     "_id" : objectid("59a09bce388f595b15bb5fb6"),     "floorid" : objectid("59a09abe388f595b15bb5fa3"),     "name" : "bathroom",     "_userid" : objectid("590a08dba07c1a1bee87b310") } {     "_id" : objectid("59a09bce388f595b15bb5fc6"),     "floorid" : objectid("59a09abe388f595b15bb5fa3"),     "name" : "living room",     "_userid" : objectid("590a08dba07c1a1bee87b310") }

i lookup them , tried following query:

db.getcollection('buildings').aggregate([     {         "$lookup": {             "from": "floors",             "localfield": "_id",             "foreignfield": "buildingid",             "as": "floors"         }     },     {         "$lookup": {             "from": "rooms",             "localfield": "floors._id",             "foreignfield": "floorid",             "as": "floors.rooms"         }     }   ]);

this gives following result:

{     "_id" : objectid("59a09abe388f595b15bb5fa6"),     "_userid" : objectid("590a08dba07c1a1bee87b310"),     "name" : "home",     "floors" : {         "rooms" : []     } }

but have following result:

{     "_id" : objectid("59a09abe388f595b15bb5fa6"),     "_userid" : objectid("590a08dba07c1a1bee87b310"),     "name" : "home",     "floors" : [          {             "_id" : objectid("59a09abe388f595b15bb5fa3"),             "buildingid" : objectid("59a09abe388f595b15bb5fa6"),             "name" : "upstairs",             "rooms": [             {                      "_id" : objectid("59a09bce388f595b15bb5fb6"),                     "floorid" : objectid("59a09abe388f595b15bb5fa3"),                     "name" : "bathroom"                 },                 {                     "_id" : objectid("59a09bce388f595b15bb5fc6"),                     "floorid" : objectid("59a09abe388f595b15bb5fa3"),                     "name" : "living room"                 }             ]         },          {             "_id" : objectid("59a09abe388f595b15bb5fa2"),             "buildingid" : objectid("59a09abe388f595b15bb5fa6"),             "name" : "downstairs",             "rooms" : [ ]         }     ] }

as see lookup references building structure it's floors , rooms.

how can achieve that?

a glance @ aggregate query , the kind of output results makes me feel double $lookup (lookup inside lookup) not supported mongodb(till 3.4 version). best bet use $unwind , results closer expectation.

here query:

db.getcollection('buildings').aggregate([      {          "$lookup": {              "from": "floors",              "localfield": "_id",              "foreignfield": "buildingid",              "as": "floors"          }      },      {"$unwind":"$floors"},      {          "$lookup": {              "from": "rooms",              "localfield": "floors._id",              "foreignfield": "floorid",              "as": "floors.rooms"          }      }    ]);

and output:

{         "_id" : objectid("59a09abe388f595b15bb5fa6"),         "name" : "home",         "floors" : {                 "_id" : objectid("59a09abe388f595b15bb5fa3"),                 "buildingid" : objectid("59a09abe388f595b15bb5fa6"),                 "name" : "upstairs",                 "rooms" : [                         {                                 "_id" : objectid("59a09bce388f595b15bb5fb6"),                                 "floorid" : objectid("59a09abe388f595b15bb5fa3"),                                 "name" : "bathroom",                                 "_userid" : objectid("590a08dba07c1a1bee87b310")                         },                         {                                 "_id" : objectid("59a09bce388f595b15bb5fc6"),                                 "floorid" : objectid("59a09abe388f595b15bb5fa3"),                                 "name" : "living room",                                 "_userid" : objectid("590a08dba07c1a1bee87b310")                         }                 ]         } } {         "_id" : objectid("59a09abe388f595b15bb5fa6"),         "name" : "home",         "floors" : {                 "_id" : objectid("59a09abe388f595b15bb5fa2"),                 "buildingid" : objectid("59a09abe388f595b15bb5fa6"),                 "name" : "downstairs",                 "rooms" : [ ]         } }

Comments

Post a Comment

Popular posts from this blog

resizing Telegram inline keyboard -

telegram's inline keyboard great feature lots of different use cases. inline buttons added list of items this: inline_keyboard = [[inlinekeyboardbutton(text="button", callback_data="button"), inlinekeyboardbutton(text="reset",callback_data="reset")]] inline_keyboard_markup = inlinekeyboardmarkup(inline_keyboard) update.message.reply_text("hi", reply_markup=inline_keyboard_markup) the above code adds 2 buttons each half width of chat screen. i know the normal keyboard button there resize_keyboard parameter somehow can used. my question is there way resize inline buttons ? example make full width or quarter width. unfortunately, can't now. :( you can suggest @botsupport , might add feature next version.
Read more

javascript - How to bind ViewModel Store to View? -

i'm pretty new ext js , trying embed multiselect inside panel . the viewmodel has stores property can see here: ext.define('test.view.controls.search.searchfiltermodel', { extend: 'ext.app.viewmodel', alias: 'viewmodel.filter', data: { title: '' }, stores: { test: { fields: [ 'id', 'name' ], proxy: { type: 'ajax', url: 'api/test', reader: 'array' }, autoload: true } } }); i bind in view this: viewmodel: { type: 'filter' }, layout: 'fit', border: 1, plain: true, scrollable: 'y', layout: 'fit', bind: { title: '{title}', }, items: { xtype: 'multiselect', scrollable: false, allowblank: true, ddreorder: true, bind: { store: '{test}' }, valuefield: 'id', displayfield: 'name' } ...
Read more

c - Why does alarm() cause fgets() to stop waiting? -

i playing around signals in c. main function asks input using fgets(name, 30, stdin) , , sits there , waits. set alarm alarm(3) , , reassigned sigalrm call function myalarm calls system("say pay attention") . after alarm goes off, fgets() stops waiting input , main fn continues on. happens if change myalarm set variable , nothing it. void myalarm(int sig) { //system("say pay attention"); int x = 0; } int catch_signal(int sig, void (*handler)(int)) { // when signal comes in, "catch" , "handle it" in way want struct sigaction action; // create new sigaction action.sa_handler = handler; // set it's sa_handler attribute function specified in header sigemptyset(&action.sa_mask); // "turn signals in sa_mask off?" "set sa_mask contian no signals, i.e. nothing masked?" action.sa_flags = 0; // not sure, looks aren't using of available flags, whatever may return sigaction(sig, ...
Read more