Mixing
Finding list of users and iterating over in Node/Mongoose
Below in my code I am getting a list of users based on department. Than using that list I am using for loop to check if that user location is in the Loc table or not.
user.find({dept: 'main'}, {}, (err, users)=>{
for(var i=0; i<users.length; i++){
var query={userid: users[i].userid};
Loc.findOneAndUpdate({query, {$set: {locuser: user[i].locuser}}, {new: true, upsert: false}, (err, results)=>{
if(err) { console.log(err)
console.log("success")
})
}
})
When I run this code it inserts last id repeatedly. Meaning if there were 4 users found it will insert 4 locations for the same one user who was last in the list while it should enter all 4 users.
Please let me know how to fix this. Thanks
javascript node.js mongoose
edited Jan 2 at 12:12
A.H.Nuri
817511
asked Jan 2 at 11:51
J. DavidsonJ. Davidson
1,752124575
add a comment |
Below in my code I am getting a list of users based on department. Than using that list I am using for loop to check if that user location is in the Loc table or not.
user.find({dept: 'main'}, {}, (err, users)=>{
for(var i=0; i<users.length; i++){
var query={userid: users[i].userid};
Loc.findOneAndUpdate({query, {$set: {locuser: user[i].locuser}}, {new: true, upsert: false}, (err, results)=>{
if(err) { console.log(err)
console.log("success")
})
}
})
When I run this code it inserts last id repeatedly. Meaning if there were 4 users found it will insert 4 locations for the same one user who was last in the list while it should enter all 4 users.
Please let me know how to fix this. Thanks
javascript node.js mongoose
edited Jan 2 at 12:12
A.H.Nuri
817511
asked Jan 2 at 11:51
J. DavidsonJ. Davidson
1,752124575
add a comment |
Below in my code I am getting a list of users based on department. Than using that list I am using for loop to check if that user location is in the Loc table or not.
user.find({dept: 'main'}, {}, (err, users)=>{
for(var i=0; i<users.length; i++){
var query={userid: users[i].userid};
Loc.findOneAndUpdate({query, {$set: {locuser: user[i].locuser}}, {new: true, upsert: false}, (err, results)=>{
if(err) { console.log(err)
console.log("success")
})
}
})
When I run this code it inserts last id repeatedly. Meaning if there were 4 users found it will insert 4 locations for the same one user who was last in the list while it should enter all 4 users.
Please let me know how to fix this. Thanks
javascript node.js mongoose
edited Jan 2 at 12:12
A.H.Nuri
817511
asked Jan 2 at 11:51
J. DavidsonJ. Davidson
1,752124575
Below in my code I am getting a list of users based on department. Than using that list I am using for loop to check if that user location is in the Loc table or not.
user.find({dept: 'main'}, {}, (err, users)=>{
for(var i=0; i<users.length; i++){
var query={userid: users[i].userid};
Loc.findOneAndUpdate({query, {$set: {locuser: user[i].locuser}}, {new: true, upsert: false}, (err, results)=>{
if(err) { console.log(err)
console.log("success")
})
}
})
When I run this code it inserts last id repeatedly. Meaning if there were 4 users found it will insert 4 locations for the same one user who was last in the list while it should enter all 4 users.
Please let me know how to fix this. Thanks
javascript node.js mongoose
javascript node.js mongoose
edited Jan 2 at 12:12
A.H.Nuri
817511
asked Jan 2 at 11:51
J. DavidsonJ. Davidson
1,752124575
edited Jan 2 at 12:12
A.H.Nuri
817511
asked Jan 2 at 11:51
J. DavidsonJ. Davidson
1,752124575
edited Jan 2 at 12:12
A.H.Nuri
817511
edited Jan 2 at 12:12
A.H.Nuri
817511
edited Jan 2 at 12:12
A.H.Nuri
817511
817511
asked Jan 2 at 11:51
J. DavidsonJ. Davidson
1,752124575
asked Jan 2 at 11:51
J. DavidsonJ. Davidson
1,752124575
asked Jan 2 at 11:51
J. DavidsonJ. Davidson
1,752124575
1,752124575
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You can perform update operation using mongodb bulk update
var bulk = Loc.collection.initializeUnorderedBulkOp();
user.find({dept: 'main'}, {}, (err, users)=>{
users.forEach( function (userObj){
bulk.find({userid: userObj.userid}).update(update);
})
})
bulk.execute(callback)
For more detail click here
answered Jan 2 at 13:01
Muhammad UsmanMuhammad Usman
260111
Does update also creates new record if it doesnt exist? My goal is to update if it exists if not create new one
– J. Davidson
Jan 3 at 8:44
Please follow stackoverflow.com/questions/38799112/…
– Muhammad Usman
Jan 3 at 11:30
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54005857%2ffinding-list-of-users-and-iterating-over-in-node-mongoose%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can perform update operation using mongodb bulk update
var bulk = Loc.collection.initializeUnorderedBulkOp();
user.find({dept: 'main'}, {}, (err, users)=>{
users.forEach( function (userObj){
bulk.find({userid: userObj.userid}).update(update);
})
})
bulk.execute(callback)
For more detail click here
answered Jan 2 at 13:01
Muhammad UsmanMuhammad Usman
260111
Does update also creates new record if it doesnt exist? My goal is to update if it exists if not create new one
– J. Davidson
Jan 3 at 8:44
Please follow stackoverflow.com/questions/38799112/…
– Muhammad Usman
Jan 3 at 11:30
add a comment |
You can perform update operation using mongodb bulk update
var bulk = Loc.collection.initializeUnorderedBulkOp();
user.find({dept: 'main'}, {}, (err, users)=>{
users.forEach( function (userObj){
bulk.find({userid: userObj.userid}).update(update);
})
})
bulk.execute(callback)
For more detail click here
answered Jan 2 at 13:01
Muhammad UsmanMuhammad Usman
260111
Does update also creates new record if it doesnt exist? My goal is to update if it exists if not create new one
– J. Davidson
Jan 3 at 8:44
Please follow stackoverflow.com/questions/38799112/…
– Muhammad Usman
Jan 3 at 11:30
add a comment |
You can perform update operation using mongodb bulk update
var bulk = Loc.collection.initializeUnorderedBulkOp();
user.find({dept: 'main'}, {}, (err, users)=>{
users.forEach( function (userObj){
bulk.find({userid: userObj.userid}).update(update);
})
})
bulk.execute(callback)
For more detail click here
answered Jan 2 at 13:01
Muhammad UsmanMuhammad Usman
260111
You can perform update operation using mongodb bulk update
var bulk = Loc.collection.initializeUnorderedBulkOp();
user.find({dept: 'main'}, {}, (err, users)=>{
users.forEach( function (userObj){
bulk.find({userid: userObj.userid}).update(update);
})
})
bulk.execute(callback)
For more detail click here
answered Jan 2 at 13:01
Muhammad UsmanMuhammad Usman
260111
answered Jan 2 at 13:01
Muhammad UsmanMuhammad Usman
260111
answered Jan 2 at 13:01
Muhammad UsmanMuhammad Usman
260111
answered Jan 2 at 13:01
Muhammad UsmanMuhammad Usman
260111
260111
Does update also creates new record if it doesnt exist? My goal is to update if it exists if not create new one
– J. Davidson
Jan 3 at 8:44
Please follow stackoverflow.com/questions/38799112/…
– Muhammad Usman
Jan 3 at 11:30
add a comment |
Does update also creates new record if it doesnt exist? My goal is to update if it exists if not create new one
– J. Davidson
Jan 3 at 8:44
Please follow stackoverflow.com/questions/38799112/…
– Muhammad Usman
Jan 3 at 11:30
Does update also creates new record if it doesnt exist? My goal is to update if it exists if not create new one
– J. Davidson
Jan 3 at 8:44
Does update also creates new record if it doesnt exist? My goal is to update if it exists if not create new one
– J. Davidson
Jan 3 at 8:44
Please follow stackoverflow.com/questions/38799112/…
– Muhammad Usman
Jan 3 at 11:30
Please follow stackoverflow.com/questions/38799112/…
– Muhammad Usman
Jan 3 at 11:30
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54005857%2ffinding-list-of-users-and-iterating-over-in-node-mongoose%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
