Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Push values into array of mongodb database through (sails js) waterline

node js,sails js,waterline. I need to update(or push) values into the below schema after insert

I am using sailsjs with waterline and mongodb.

{
"countries": {
"states": [
{
"statename": "state",
"districts": [
{
"distname": "district",
"cities": [
{
"cityname": "Hyderabad",
"places": [
                {
                  "placename": "hitechcity"
                }
              ]

          }
        ]
      }
    ]
  }
]
}
}

I need to know how to update it i need something like this after update

{
"countries": {
"states": [
{
"statename": "state",
"districts": [
{
"distname": "district",
"cities": [
{
"cityname": "Hyderabad",

              "places": [
                {
                  "placename": "hitechcity"
                },
                {
                  "placename": "someother place"
                }
              ]

          }
        ]
      }
    ]
  }
]
}
}

please someone help me.

like image 377
Shiva Gouraram Avatar asked Aug 10 '13 10:08

Shiva Gouraram


2 Answers

Great question! You'll want to use addToCollection():

await User.addToCollection(23, 'roles')
.members([3, 5, 6]);

Done on my phone so sorry about any typos :)

Edited Aug 7, 2018 to reflect best practices in Sails v1. More info: https://sailsjs.com/documentation/reference/waterline-orm/models/add-to-collection

like image 165
mikermcneil Avatar answered Nov 19 '22 19:11

mikermcneil


I found that with Sails I could not use mikermcneil answer. I had to go native:

Runtestunit.native(function(err, runtestunit){
     runtestunit.find({sessionID : sessionData.id_}).toArray(function(err, results) {
         if (err) return res.serverError(err);
         runtestunit.update({ _id: results[0]._id },
           { $push: { screenshots: filename } },
           function(err, screenshots) {
           if(err) sails.log.err( err)
         else sails.log.info("Item pushed")
       })
    });
});

FYI I'm querying my data by a sessionData.id_ key

like image 4
Zardoz Avatar answered Nov 19 '22 19:11

Zardoz